Retrieve data using Excel

To manually import AVEVA Insight data to Excel

1. Open Excel 2013 or later.

2. From Data, choose Get External Data, choose From Other Sources, and then choose From OData Data Feed.

3. In the Link or File box, specify a URL for your query, formatted as an atom feed (that is, end with "$format=atom’").

   Here is a query example:

   https://online.wonderware.[DOMAINSUFFIX]/s/ik97r5/apis/historian/v2/TagGroups?$format=atom

   Note: Retrieval endpoints are unique for each AVEVA Insight solution. This example uses the endpoint "https://online.wonderware.[DOMAINSUFFIX]/s/ik97r5", but yours will be different. Learn how to find the basic-authentication retrieval endpoint for your solution.

   

4. Select Use this name and password, and specify your AVEVA Insight user name and password.

5. Select Next.

6. In the Select Tables box, mark the element to include.

7. Select Next.

   

8. Review the information displayed on Save Data Connection File and Finish and then select Finish. Excel creates an ODC (OData Connection) file.

   

9. Specify how and where to place your data in the spreadsheet. Select OK.

   

   Excel will place the data where you specified: