The most recent version of Excel, Excel 2013 (as part of Office365), now provides some functions to directly integrate web services and to extract XML paths.
With this, also a direct integration of OpenPHACTS into Excel is possible and allows to query content of Excel cells against the OpenPHACTS API. The attached demo sheet demonstrates a simple use case example:
The /compound part shows how to extract different data from the output of one API call. The /compound/classifications part is a first test how to extract multiple result records from one XPath node by applying Excel's array formulas.