Import data from the XOVI API into Microsoft Excel

[rifat28dddd]

Microsoft Excel is the world's most widely used spreadsheet program. Due to its widespread use, the standard file format (XLS or XLSX) is also supported by most other spreadsheet software. Since 2014, Excel has also been available on mobile devices.

The Excel functions WEBDIENST() and FILTERXML()
Note : These functions are available from Excel 2013

To import data from XOVI into an Excel spreadsheet, you can use the belgium cell phone number list/ two Excel functions WEBDIENST() and XMLFILTERN() . Importing into Excel is somewhat more complex than in Google Sheets and involves several steps.

First, load the contents of the API query into your table using the WEBDIENST function. The function syntax is:

WEBDIENST(URL)

Enter your API query as the URL. Click in a field where you want the XML content to be loaded and enter the function there, preceded by an equal sign: