Exchange Siemens S7 PLC Data Using Microsoft Excel
‘S7 Excel Connect’ allows the user to read, log and write Siemens S7 PLC data using Microsoft Excel. Inputs, outputs, datablock, marker, … data can be read from the PLC, datablock and marker data can be written to the PLC and this direct in Excel without the need for additional software or drivers. ‘S7 Excel Connect’ can be used for many uses ranging from a reporting tool, spreadsheet for advanced calculations on live process values to a tool to write extensive recipes from Excel to one or multiple S7 PLC’s. Download your free 7 days trial version today!
Starting at 49.50€, explore licensing options.
‘S7 Excel Connect’ Features
Write Data From Excel To S7
With ‘S7 Excel Connect’, the user can write data to a datablock or marker direct from Excel without the need of a third party software or driver.
Read Various Datatypes
A whole range of datatypes can be read in Excel from any profinet connected S7 PLC. Data can be read from datablock, marker, input, output, timer, counter, … .
User Friendly
Thanks to the clear ribbon, the clear task panes and the familiar Excel environment, ‘S7 Excel Connect’ is extremely easy to use.
Data Logging
‘S7 Excel Connect’ Ultimate is equipped with the data logging function. Log all your Siemens S7 PLC variables in Microsoft Excel with adjustable time interval.
Online Support
Subscription users can access the online support section and get in touch with our experts for troubleshooting, advice, … on ‘S7 Excel Connect’.
Documentation
All the functions of ‘S7 Excel Connect’ are together with examples clearly described in our support section. Read more.
‘S7 Excel Connect’ Use Cases
Process Optimization
Pharmaceutical, food, health care, energy, manufacturing, hospitality, entertainment or any other industry, ‘S7 Excel Connect’ is widely applicable in every industry. Collect and log all essential process data from any LAN connected S7 PLC directly in Microsoft Excel with ‘S7 Excel Connect’. Perform calculations on the obtained data, create custom reports and optimize your processes by adjusting parameters directly from Excel.
Energy Monitoring
Whether it concerns the production or consumption of energy, ‘S7 Excel Connect’ can be used. Read S7 PLC connected Siemens Sentron PAC energy measuring devices or any other S7 PLC connected energy meter, smart circuit breaker, PV inverter, diesel generator, wind turbine, … . Map your entire energy flows using ‘S7 Excel Connect’ and discover where energy flows can be optimized.
Agriculture
Greenhouse, pigsty, cowshed, vegetables storage, … . Keep a close eye on realtime and logged data such as heating/cooling data, humidity, temperature, energy/gas consumption, CHP data, … and adjust setpoints from the familiar Excel environment. At a glance you have an overview of all your data from several locations in the field collected in only one Excel spreadsheet.
System Requirements
- OS: Microsoft Windows 7 or above (both 32 and 64 bit versions)
- Microsoft Excel 2010 or above, local installation
- Processor: Intel or AMD
- RAM: At least 1 GB of RAM
- Microsoft .NET framework 4.5 or greater
