Skip to content

Excel can retrieve data from many sources. Using the AmetricX API you can integrate with Microsoft Excel to facilitate access to your metrics.

Create a new data connection

New data from web

Define connection url

This screen constructs the URL for the API call. You must be aware url formatting.

? indicates that parameters follow

& separates the parameter

  • Review this document to understand the required parameters.
  • Make sure you use the correct endpoint for your accout
  • Click OK to continue

Connection url

Data preview

Excel provides a preview of the data prior to loading with the option to transform the data. Click load to continue

Data Preview

Load

Connection url