Retrieve data using Excel

To manually import 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 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. Click Use this name and password, and specify your Insight user name and password. Click Next.

5. In the Select Tables box, mark the element to include. Click Next.

   

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

   

7. Specify how and where to place your data in the spreadsheet. Click OK.

   

   Excel will place the data where you specified: