Skip to main content
Planview Customer Success Center

Configure A Connection To The Reporting API With Excel

To create a live connection to the reporting API on a PC:

1. Open Excel 2016 and create a blank workbook.

2. Click on "Data" → "New Query" → "From Other Sources" → "From Web"

           

Click to expand or shrink

           

3. Ensure that the "Basic" radio button is selected in the dialog that appears, paste your generated URL from the Reporting API URL Generator into the "URL" field, and click "OK"

  • If using an API token, ensure that the "Advanced" radio button is selected in the dialog that appears. Paste your generated URL from the Reporting API URL into the "URL" field then replace everything after token= with the API token that you generated from your account.

           

Click to expand or shrink

           

           

Click to expand or shrink

           

4. The "Access Web Content" dialog should appear, with the "Anonymous" tab selected. Click "Connect"

           

Click to expand or shrink

           

5. A "Connecting" dialog will appear while the request is made. Ensure that the data appears to have been parsed correctly on the resulting dialog, and if it is click the "Load" button

           

Click to expand or shrink

           

6. Your data should now be loaded into a new sheet in your Excel workbook.

7. You can then periodically click the "Refresh All" button to get updated data, as long as your token hasn't expired.

8. If the token does expire, simply edit/update the query URL.

           

NOTE

We recommend using only Excel 2016 to create a live Excel connection. We don't recommend using older versions of Excel, as Excel's previous versions won't accept URL's over a certain character limit.