Skip to main content
InSource Solutions

TN InSight009 Extracting Data to Excel from Wonderware On-Line Historian

Description

 

This article from InSource shows how to extract data from Wonderware's OnLine Historian using the web based InSight client tool.

  • Author: Chris Selph
  • Published: 12/2/2018
  • Applies to: Wonderware on-Line InSight

Details

Pre-Requisites

You must have a Microsoft Office 365 on-line account. 

Using the InSight tool:

Start by creating a trend of the data you want to export to Excel.

Then click the Blue icon in the bottom right corner and Click Download.

1.1.jpg

Then choose excel on-line

2.jpg

Choose or add your Microsoft Office 365 account and login if required.

3.jpg

Excel On-Line will start and the Data assistant for InSight will show on the right.

Choose how you want to see the data: 

Raw values or 

Aggregated in 15 minute, 1 hour or 1 day time periods

4.jpg

If you chose an aggregate you then choose the calculations you want to see like AVG, MIN, MAX

Then click import

5.jpg

Your data will be imported with time stamped columns and the rows are the tags and calculated values if aggregated as in this example.

Note you can edit the time period fields to retrieve a different period of data.

 

6.jpg

When you have your dataset, You can download a local copy in Excel if you prefer.

7.jpg