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. The value for Authorization is the word “Basic” followed by a space, followed by your API token that has been run through a base64 encoder. When encoding your API token, add these characters to the end before encoding :x. For example YourAPIToken:x results in WW91ckFQSVRva2VuOng=

Excel API Settings

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