Matrikon OPC Excel Reporter

Simplified Excel Reporting for OPC Data
Manual Datasheet

Matrikon OPC Excel Reporter

OPC Excel Reporter converts Excel into a reporting tool for process and equipment data by connecting to real-time (OPC DA) and historical (OPC-HDA) data sources. It includes sample reports to help you start quickly and effortlessly generate production, quality, and performance reports.

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 a ready-to-use solution that's simple to set up, configure, and manage, allowing you to be operational in 5 minutes

No Historian, No Problem!
If you’re manually reporting PLC data, automate the process with Excel Reporter to avoid entry errors. This plug-in integrates seamlessly with Excel 2010/2013/2016/2019/MS365.

OPC vs. DDE

Upgrade from your Excel-DDE solution to OPC Excel Reporter. Here’s why OPC-Excel is preferable to DDE

Supportability: Microsoft is phasing out DDE, while OPC offers more data source options
Interoperability: OPC ensures client and server compliance through thorough testing
Speed and Throughput: OPC provides superior real-time performance compared to DDE
Scalability: OPC with Excel allows easier connections to multiple data sources
Robustness: OPC features built-in error handling, unlike DDE
Security: OPC offers more flexible and effective security for networked environments

Turn Your Process Data into Valuable Insights with OPC Excel Reporter

Set up the tool in less than 5 minutes and begin generating customized reports from any PLC data source. Start today!
Contact Us

Excel Reporter converts Microsoft Excel into a tool for generating reports on your process and equipment data. Effortlessly produce reports on production, quality, and performance. Link to any real-time or historical data source through OPC.

Features

  • Compatible with Office versions 2003, 2007, 2010, 2013, 2016, and 2019
  • Easily compare data across different time periods
  • Generate scheduled or on-demand reports effortlessly
  • Connect to various data sources, including popular PLCs, DCSs, and historians
  • VBA compatible
  • Security features designed for high-security settings
  • Filter data directly from the source
  • Supports millisecond-level queries
  • Retrieve both processed and raw data
  • Supports array values

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

Excel Compatibility

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

User-Friendly/Convenient

OPC Excel Reporter harnesses the power of Excel, the most commonly used tool for data analysis and reporting. It allows you to easily access process and equipment data from anywhere in your organization and utilize Excel’s advanced features for calculations and data manipulation.

Comprehensive Data Access

OPC is the leading method for accessing industrial automation data. OPC Excel Reporter enables you to pull data from multiple systems into Excel using both OPC DA and OPC HDA, without needing custom tools for each device. You can compare data from different lines, units, or plants using a single tool.

Real-time Dashboards

With OPC Excel Reporter’s real-time data access (OPC-DA), Microsoft Excel becomes a straightforward dashboard for monitoring your system from office. You can calculate KPIs, use color coding, track trends, and perform real-time analysis.

Automated Reports

Perfected your report? Our scheduler can eliminate your Monday morning reporting hassles. Set your KPI reports to be sent out every Monday, capture daily production data, or compile your monthly material balances automatically.