OPC Excel Reporter

Easy Excel Reports for OPC Data
Manual Datasheet

Easy Excel Reports for OPC Data

OPC Excel Reporter is an OPC Client for Excel that transforms Excel into a reporting tool for your process and equipment data. Connect to any real-time (OPC DA) or historical (OPC-HDA) data source. Sample reports make getting started a snap. Easily create production, quality and performance reports.

OPC Excel Reporter is an out-of-the-box solution that is easy to set up, configure and manage - get up and running in less than 5 minutes

No Historian, No Problem!

Are you manually reporting on data from your PLC? 
Eliminate errors caused by manual entry and automate it with Excel Reporter

Excel reporter is a standard Excel plug-in that works directly in Excel 2010/2013/2016/2019/MS365

OPC vs. DDE

Replace your Excel-DDE solution with OPC Excel Reporter. 
Why use an OPC-Excel solution instead of DDE?

Supportability: Microsoft is gradually phasing DDE out – and there are more OPC data sources
Interoperability: OPC has compliance and interoperability testing for clients and servers
Speed and Through-put: OPC has better performance for real-time applications than DDE
Scalability: With Excel as an OPC client, you can connect to multiple data sources more easily
Robustness: Unlike DDE, OPC has built in error handling in the specification
Security: OPC Security is more flexible and works better over networked configurations

 

Transform your process data into actionable insights with OPC Excel Reporter

Set up in under 5 minutes and start creating custom reports from any PLC data source. Get started now!
Contact Us

Excel Reporter transforms Microsoft Excel into a reporting tool for your process and equipment data. Easily create production, quality, and performance reports. Connect to any real-time or historical data source via OPC

Features

Office 2003, 2007,2010, 2013, 2016 and 2019 compatible
Easily compare data from different time ranges
Create scheduled or adhoc reports easily
Connect to multiple data sources including popular PLC’s, DCS’s and Historians
Compatible with VBA
Security signed for high-security environments
Filter results from the data source
Supports millisecond queries
Pull processed and raw data
Array Value Support

Supported OPC Specs

OPC DA (OPC Data Access) 1.0a
OPC DA (OPC Data Access) 2.0a
OPC DA (OPC Data Access) 2.05a
OPC DA (OPC Data Access) 3.0a
OPC HDA (OPC Historical Data Access) 1.0
OPC HDA (OPC Historical Data Access) 1.1
OPC HDA (OPC Historical Data Access) 1.2

Microsoft Excel Supported

Microsoft Windows 7 (32-bit or 64-bit)
Microsoft Windows 10
Microsoft Windows 11
Microsoft Windows Server 2008 R2 SP1
Microsoft Windows Server 2012 R2
Microsoft Windows Server 2016
Microsoft Windows Server 2019
Microsoft Office Excel:
Excel 2010 (32-bit)
Excel 2013 (32-bit)
Excel 2016 (32-bit)
Excel 2019 (32-bit)
Office 365

Familiar & Convenient

Unlike other reporting solutions, OPC Excel Reporter uses the power of Excel. Excel is the most widely used tool for data analysis and reporting. With OPC Excel Reporter, now you can retrieve process and equipment data easily from anywhere in your organization and take advantage of Excel's advanced calculations and data manipulation features

Access All Your Data

OPC provides the most popular access method for industrial automation data. With both OPC DA and OPC HDA access, OPC Excel Reporter lets you pull data from multiple systems in Excel using OPC, without relying on custom tools for each device. Compare data from separate lines, units, or plants, all in a single tool

Real-time Dashboards

OPC Excel Reporter’s (OPC-DA) real-time data access turns Microsoft Excel into a simple dashboard for keeping track of your system, from the comfort of your office. Calculate KPIs, color code, trend, and analyze them all in real-time

Scheduled Reports

Got your report just right? Our report scheduler can wipe out your 6am Monday reporting blues. Schedule your KPI report to go out every Monday, grab the day's production numbers, or tally up your monthly material balance