TABLE OF CONTENTS

• Step 1 - Go to Data and select From Web
• Step 2 - Select Advanced
• Step 3 - Go to Analytic Views in Position Green
• Step 4 - Fill in URL and headers
• Step 5 - Click OK to load data
• Step 6 - Click To Table
• Step 7 - Click OK
• Step 8 - Click on the icon in the Column to expand
• Step 9 - Select all columns
• Step 10 - Then click on Close & Load
• Step 11 - To refresh data click on Refresh
  
  

Feeling more comfortable elaborating with data in Excel? Don't worry, it is possible to integrate your analytics views with Excel. 

Any application that supports REST can be used off-the-shelf to communicate with Position Green. Microsoft Excel has a data connection for REST which means we can use Excel to poll data from Position Green. The only thing you will need from us is your client_id and the client_secret, which you will receive upon request from your Sustainability Platform Team.

Please follow the step-by-step guide to set up your integration.

  Note that this functionality in Microsoft Excel is only available on Windows

Step 1 - Go to Data and select From Web

Step 2 - Select Advanced

Step 3 - Go to Analytic Views in Position Green

For the view you want to import to Excel, click on the three dots and click "Copy id".

Step 4 - Fill in URL and headers

URL parts:

Using the copied id enter the URl in Excel.

The base url is https://api.positiongreen.com/v1/tables/<id>.

HTTP request header parameters:

Send in the header both the client id and secret.

Step 5 - Click OK to load data

Step 6 - Click To Table

Step 7 - Click OK

Step 8 - Click on the icon in the Column to expand

Step 9 - Select all columns

Step 10 - Then click on Close & Load

Step 11 - To refresh data click on Refresh