PLCDataReader – create excel files with your Siemens S7 PLCMarkus Bläser2021-02-27T07:55:10+01:00
Read let your Siemens PLCs save data to Excel files
Write Excel files with your Siemens PLC
The PLCDataReader is a simple and cost-effective way to write Excel files with your Siemens PLC (Programmable Logic Controller). These can be e.g. protocols or measurement data. The DataReader is a program of our PLC Data Tools.
The program runs in the background, so that the Computer can be used for other things. Via a tray menu entry you can view the status and change the configuration. You can make the most important settings in just a few steps. This includes the PLC connection, the memory options and the assignment of PLC data to the Excel cells or rows. Done! Now you can program the S7 to fit. We support you with an example program for TIA-Portal.
Acquisition of production data
Acquisition of quality data
Logging of processes which are controlled by the S7
Supply of quality proofs
Saving machine settings
and many more applications …
Convenient: the single user license
Flexible: the company license
System requirements and compatibility
Compatible with all PLC models with ProfiNet:
e.g. ET200, S7-300, S7-400, S7-1200, S7-1500, WinAC, Siemens Software Controller, VIPA
Supports all major data types:
BOOL, BYTE, WORD, DWORD, LWORD, INT, DINT, SINT, LINT, UINT, UDINT, USINT, ULINT, WORD, DWORD, LWORD, REAL, LREAL, CHAR, ARRAY OF CHAR, STRING, DT (Date_And_Time), DTL, LDT, DATE, TIME, TOD, LTOD
No additional software required for operation: You don’t need WinCC, OPC-Server or Excel. Simply install and get started!
Compatible with Windows 7/8/10/2008/2012/2016 (32 Bit and 64 Bit)
You can realize a multiple applications with the PLCDataReader. All data stored in the data blocks of the PLC can be written to Excel tables or CSV files. The process is completely controlled by the S7 PLC. By means of so-called triggers. These trigger conditions can be set somewhere in the PLC program.
As a result, e.g. such an Excel file could be generated:
An Excel file designed by you can be specified as a template in the program configuration.
Our customers range from industrial groups to medium-sized global market leaders to small entrepreneurs. You can find more details here: References Some examples from the food industry
Simple data assignment
You can completely determine the appearance and content of the Excel files yourself. Simply assign data block addresses to Excel columns. Would you like to handle master data, such as machine names, separately? No problem. You can easily define so-called header data by assigning columns and rows. If you have a lot of repetitive data: We make it easy for you! You can define blockwise repeating structures once. These are then written X times.
Simple assignment of PLC data blocks / addresses to Excel cells / columns.
Should the file name be specified by the PLC? Or should it contain date and time? Or both at the same time? Everything is possible! See directly in the preview how the result of your settings will look like.
Flexible storage options allow you to save Excel files in different scenarios.
Save as CSV
You want to save your S7 data in a CSV file. No problem! You can import the CSV files into different database systems. You can also adjust the date format of the individual data types for CSV export.
You would like to generate Excel protocols of your machines or plants? Simply configure the desired triggers and place them on the new trigger window. This enables the machine or plant operator to generate quality reports or other documents based on machine data at the touch of a button.
This function offers the user the possibility to start triggers from the user interface of the PLCDataReader instead of from the PLC.
How does that work exactly? In PLCDataReader a window with buttons is configured. The window enables the operator of the plant to write the trigger in the control DB himself. A PLC program change is therefore not necessary. Only the control data block must be present in the S7.
This makes it possible to generate reports and protocols at the push of a button from the data of a Siemens S7 PLC.
Multi-PLC with overview
With the help of our configuration center you always keep the overview. The connected S7 PLCs, their connection status and further information are displayed clearly and unambiguously. So you can also manage a large number of PLCs without problems.
OPC server? No, thank you.
Reading data from several PLCs without an OPC server, is that possible? Yes! You don’t need any further programs, not even an OPC server!
A small brewery controls its brewing process by means of a Siemens S7-1500 PLC. To monitor the quality, measured values and brewing parameters are recorded several times a day in an Excel file. This enables the customer to monitor the brewing process and thus, for example, to view and compare the effects of recipe changes in Excel.
Screw manufacturer realizes 100% control with PLCDataReader
A manufacturer of screws has received a new order for a customer in the automotive industry. This order requires the manufacturer to carry out a 100% inspection of all parts produced, i.e. to check every screw before delivery. The test results must be recorded. As he already has a modern plant for the production of the screws, almost all data is available in the PLC. Now all he needs is our software, which reads the data from the PLC and writes them into an Excel table. The screws have 5 properties each, which are recorded in a column. For each newly produced screw a new row is created in Excel with the 5 measured values. When the batch is completed, a new file is created.
Connecting an Wolke Thermal Inkjet Printer to our DataSuite According to our slogan "Software written for you", our Excel-PLC software is used in many different industries and fulfills various functions. In most cases, [...]
You would like to generate Excel protocols of your machines or plants? With the latest version of our PLCDataSuite it is easier than ever before. Simply configure the desired triggers and place them on [...]
Automation specialists are increasingly confronted with the question: "How can I write Excel files with my S7? This is not possible by default. In this context, Siemens likes to refer to the possibility of [...]
Our PLC Data Tools has been available for several years now. The programs PLCDataSuite, PLCDataReader and PLCDataWriter have been continuously developed and extended by new functions. We now offer the DataReader Lite as [...]