Retrieve data using Excel

To manually import Historian Client Web 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:

   http://localhost:32569/Historian/v2/TagGroups?$format=atom

   

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: