Remote Monitoring & Management Help

Directly import API information into a Spreadsheet

Depending on the program used, it may be possible to query the Data Extraction API URL and import the data directly into your spreadsheet software for analysis and manipulation.

api_excel_imported

The following example covers the basic steps involved in importing data from an API URL into Microsoft Excel 2010.

Please note, in line with best practice we would suggest verifying the API URL is valid and returns the expected data before attempting to import the data.

Open Microsoft Excel and select the Data tab

Choose From Web in the Get External Data section

api_excel_get_data

Enter the API URL in the Address field of the New Web Query dialog and click Go

The contents of the URL are displayed in the dialog’s window and if everything is in order click Import.

This initiates the download of the data into Microsoft Excel (depending upon its configuration you may be required to accept an XML scheme informational message).

In the Import Data dialog decide on the location Where you want to put the data? to complete the process.

api_excel_new_query api_excel_import_data

The data can now be manipulated and analyzed as required from within Microsoft Excel, for example with Pivot Tables.