PLCDataReader
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.
Applications
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 …
Licensing
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, VIPASupports 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, LTODNo 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)
Processes real Excel files (xlsx) or CSV files.
Flexible use
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.
References
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.
Flexible storage options
Visualization for machine operators
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
Example applications
Brewery monitors quality with PLCDataReader
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.
Our products
Related posts
Control a Wolke thermal inkjet printer with a Siemens S7
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, [...]
Writing Excel data to S7 DBs?
You would like to write Excel files into your Siemens S7 PLC? In the past a quite complicated project, today quite simple: With our PLCDataWriter you can write any Excel (xlsx) files [...]
PLC-PC data exchange: Without OPC Server?
When it comes to exchanging data between the PC world and the automation world, there is no way around an OPC server. At least that is a widely held opinion. However, our experience [...]
Create Excel files faster and better with S7
More and more often there is the need to read or write Excel files with an S7 controller. If you use Siemens products, e.g. WinCC, you can read and write data from CSV [...]
New in our Excel PLC software: Visualization for machine operators
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 [...]
It’s simple: Write Excel files with the Siemens S7
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 [...]
Your logo in our software
The white label function - your logo in our software What's white label? In short: You can make our PLC Data Tools look as if you developed it yourself. You can integrate [...]
ERP connection of machines and plants
edited, Image Source: UlrichAAB How ERP and machines/plants find each other A continuous data flow across all automation levels up to the ERP system is the vision of many companies. [...]
Write CSV files with the S7: Our new DataReader Lite
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 [...]