Read, Log and Write Siemens 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, … .
Thanks to the clear ribbon, the clear task panes and the familiar Excel environment, ‘S7 Excel Connect’ is extremely easy to use.
‘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.
Subscription users can access the online support section and get in touch with our experts for troubleshooting, advice, … on ‘S7 Excel Connect’.
All the functions of ‘S7 Excel Connect’ are together with examples clearly described in our support section. Read more.
‘S7 Excel Connect’ Use Cases
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.
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.
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.
- 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