Excel Connector
The OAS Excel Connector makes it easy to connect Microsoft Excel with your live industrial data. This powerful IIoT Excel interface brings real-time plant floor data right into your spreadsheets, helping you track performance, visualize operations, and update settings without needing extra software.
Live Dashboards In MS Excel
Use Excel to visualize what's happening on the floor in real time. The OAS Industrial Automation Excel Gateway works with Excel versions 2007, 2010, 2013, 2016, and 2019, as well as Excel for Microsoft 365.
Each licensed service for the OAS Excel Connector can support unlimited local and remote Excel workbooks. You can even have Excel workbooks access live data over the internet using our IIoT Excel gateway..
a server-based, highly-scalable, network platform that enables the transport and transformation of your data
Data HistorianAchieve fault-tolerant logging, zero data loss, and multi-destination storage with our high-performance Store and Forward technology.
Visualization ToolsBuild Visualizations, User Interfaces, and server configuration interfaces for .NET, web technologies, native iOS and Android mobile apps
Device & Data ConnectorsThe OAS Platform provides rapid communications and connectivity to a wide variety of PLCs, devices, and databases.
IoT ConnectorsConnect to cloud-base IoT gateways such as AWS, Azure IoT Hub, Azure Event Hubs, Kafka, and more.
Alarm Logging & NotificationCapture events on each data point, log to open formats for historical analysis and archiving, and trigger real time notifications
SDKs & APIsExplore a wide variety of Developer Tools and APIs to allow you to create applications and system integrations to execute in any environment.
Networking FeaturesOpen Automation Software implements edge computing with a Distributed Network Architecture.
Download a fully functional trial of Open Automation SoftwareKey Features & Benefits
Industry 4.0 Data Sources
Easily link Excel to Modbus, Allen Bradley PLCs, Siemens S7 Controllers, OPC UA, OPC DA, MQTT, Sparkplug B, MTConnect, AWS IoT Core, Kafka, .NET, REST Clients, and Databases. With this industrial automation Excel connector, you get a seamless bridge between your OT and IT systems.
Direct Excel Integration
With our built-in Excel Add-In, you can read and write live values directly in Excel. The industrial automation Excel interface works behind the scenes so you can focus on reporting, monitoring, or sharing data.
Real Time KPIs and ROI
Implement operational dashboards with real time ROI calculations and KPIs from live plant production data.
Drive Excel Charts
Using OAS data, you can drive charts, graphs, and calculations from live data points, with as low as a 30 millisecond update rate.
Local and Remote Networking
No matter where your data is coming from, our IIoT Excel connector makes it easy to source it from local or remote OAS servers. Collaborate with teams across your network with real-time data.
Every Data Source, One Interface
OAS brings it all together. Use Excel to access data from OPC UA, PLCs, MQTT brokers, Sparkplug B EoNs, and other connected devices, all in one easy-to-use IIoT Excel gateway.
Display KPIs
Create user interfaces for both visualization and data entry. Leverage the extensive array of Excel functions and inspiring online examples to craft an engaging monitoring console for your Key Performance Indicators, highlighting the performance of your production lines.
Transfer Data from Excel to Industrial Data Source
With the IIoT Excel interface, you can use Excel functions to calculate setpoints or other values and send them directly to your connected equipment. No coding needed. This simplifies configuration and makes daily workflows more efficient.
Remote Deployment
Deploy Excel workbooks to an unlimited number of workstations, connecting plant floor data and sharing it among colleagues. The industrial automation Excel gateway ensures it all stays in sync.
Common Use Cases
Order Processing
Similar to the OAS Database Connector, which enables recipe execution to retrieve batch or order operational setpoints from a database, the OAS Excel Connector can perform the same function to update values using Excel lookup functions. Specific cells within a worksheet can be configured to write values to local or remote OAS Tags, which are then passed to the data source defined in each tag.
Data Sharing
With OAS acting as the central data hub, users across your organization can update and read live data from any Excel workbook. The IIoT Excel connector keeps everything in sync and up to date.
User Interface
Excel can be used to create workbooks that visualize data meaningfully and summarize plant floor data along with operational targets. Incorporate line charts or bar graphs that display real-time data, providing an insightful visual representation of trends and patterns as they emerge.
Looking for a web user interface? Learn more about the UIEngine
Learn how thousands of customers are using the OAS Product Platform around the globe to achieve truly open industrial automation
24/7/365
Support
Technical support available by phone, chat, and email
30+ Years
Experience
Product efficacy, market testing, and reliability
Used in 10K+
Data Servers
OAS is used in thousands of businesses worldwide
OAS Platform Features
Cross-Platform Support
The OAS Platform supports multiple operating systems and deployment options including Windows, Linux, Docker Containers, and can even run on low footprint devices such as a Raspberry PI 4.
Networking
OAS is an edge solution that offers flexible networking options for standalone installations, multi-tenant data aggregation, and even secure unidirectional data transport.
Programmatic Setup
Utilize our .NET SDK or REST API for flexible and automated setup, ensuring full integration with your asset management software. You can also import and export CSV files, which helps you work with Excel and third-party applications.
Calculations, Time On, Counts, and Totals
Merge data from various controllers and additional data sources while performing real-time computations and logic processing, all without the need for coding. Monitor the duration of activities for specific points and the frequency of their transitions over a defined period. Aggregate analog values both daily and over the entire timeline.
See How We Compare
The initial cost of OAS is far less than our competitors – but the savings don’t stop there. We work with OEMS and System Integrators to provide perpetual licenses with quantity discounts with flexible tag pricing and unlimited client connections.
No Question Left Unanswered
We make getting started with OAS easy - Follow this step-by-step introduction to using the Open Automation Software platform, from selecting your data sources, product features, and data destinations.
Getting Started - Download, Setup & Support
Step-by-step introduction to using the Open Automation Software platform
How to use the OAS Excel Connector.
More about the 3 key networking methods included with licenses.
How to active and manage OAS license.
Related Videos
