TN InSight009 Extracting Data to Excel from Wonderware On-Line Historian
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
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.
Then choose excel on-line
Choose or add your Microsoft Office 365 account and login if required.
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
If you chose an aggregate you then choose the calculations you want to see like AVG, MIN, MAX
Then click import
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.
When you have your dataset, You can download a local copy in Excel if you prefer.