Retrieve data using Excel and Intervals API

This guide allows you to connect to your Intervals account using our API and Excel from Microsoft 365. First, get your API token from your account section.

Navigate to Data > From Web:

Excel from Web

Enter the following information in the From Web settings below and click OK:

In the next step, fill out the form by entering your API token, and enter the API URL if not already filled:

 

The next step should successfully connect to the API. In this example we are querying the time resource, so we’ll drill down to the time element that contains the actual data we need. Right click it and select Drill Down:

Excel Intervals API Transform

In the next data preview, right click again and select To Table:

Excel API Transform

Leave default values in the popup that appears after that step and click OK:

Intervals API Excel Transform

Click the column expand icon and ensure to use original columns as the prefix:

API Excel Steps

Once completed, the following screen should appear showing the time entries. The steps on the right can be repeated for any of our other API resources:

Excel API Query

Close power query, and choose to keep the settings:

Excel Intervlas API

Excel showing the completed API query transform into a table:

Intervals API Data Into Excel Table

Don't have an Intervals account? Start your own unlimited trial.

No credit card required. No software to install. Cancel any time.

Try it Free