AmetricX

Data Onboarding – transformer builder

Enable your customers and partners to upload CSV/XLS files and

transform them to match your internal data schemas.

Follow this Open Source project -> GitHub

Demo
Share CSV Files for FREE

Share CSV / JSON with Excel integration

Sharing CSV files with business partners can be challenging, especially when it comes to ensuring the security of the shared data. Excel can retrieve data from many sources. Using the AmetricX API you can integrate with Microsoft Excel to facilitate access to your metrics in CSV or JSON format.

Create a new data connection

Excel can retrieve data from many sources. Using the “From Web” connection you can define your access to AmetricX to retrieve metrics data​

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 account
Click OK to continue



Data preview

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

Load

When you click load after previewing the data, you metrics is loaded into a Spreadsheet

There is more you can do in Excel to transform and query data. This post is just getting you started!

Home » CSV Files and Excel integration

Reference