Reading and writing Excel files with a PLC
The simple and cost-effective way to read and write Excel files with a Programmable Logic Controller (PLC). The easy-to-use program interface allows you to get the results you need quickly. A supplied manual as well as our service hotline will support you even with difficult tasks.
By loading the video, you agree to YouTube's privacy policy.
Learn more
PLCDataSuite explained in 3 minutes
You can implement recipe management with Excel files or save machine settings in CSV files. In adition you can create quality certificates including company logos on the basis of a template file. Our software makes it easy for you: You do not need either an OPC server, WinCC or an Excel license.
Main features:
Read and write real Excel files (xlsx or CSV) with your PLC
Unlimited number of variables (tags) included
No additional software required
Compatible with all Siemens Simatic S7 PLC models
Easy to setup and operate
Compatible with Windows 7, 10 and Windows Server
Supports all major S7 PLC data types
Create real Excel files with a PLC
The days when you and your customers tormented yourself with CSV files are finally over: Our software reads and writes real Excel files (xlsx).
Design Excel templates according to your wishes. Logos, formulas and everything else Excel has to offer. And if you don’t want or need the luxury of real Excel files: Our software supports CSV as well.
Diagrams
Present important data in diagrams and charts. Use the power of Excel and show important information in pie charts, line charts or other charts. All diagrams can be included in Excel templates.
Your PLC controls everything
Due to our innovative trigger concept, the PLC has all power. The S7 makes the decision which Excel data should be read or written. Furthermore, you have the full flexibility when writing the Excel file. You can design the logging cell by cell, line by line or block by block. Configuration remains very simple thanks to our clear program interface.
Also possible: Trigger at the push of a button
You do not want to start the triggers from your S7 program – no problem. You can also start all triggers directly from our program. A simple visualization allows the machine operator to load Excel files into the machine or to create an Excel protocol at the push of a button.
You can release each created trigger individually for the machine operator interface. The settings can optionally be protected by password. This is what we call full control and simple operation.
Simple setting of triggers.
Multi-PLC made simple
With the help of our clear configuration center you always keep the overview. The connected PLCs, their connection status and further information are displayed clearly and unambiguously. So you can also manage a large number of S7 PLCs without problems.
The configuration center
References
Our customers range from industrial groups and medium-sized global market leaders to small businesses.
PLC simulator and live data view
Thanks to the integrated simulator, you can also configure our software without a connected PLC. This allows you to prepare and test the configuration in advance before you go to the plant.
The live data view shows you the currently read PLC data blocks live. This view differs only slightly from the simulator. In contrast to the simulator, you cannot write data: Only values are displayed.
The S7 PLC simulator (similar to live data view)
Customer feedback
“I must say that it is a really good product, no crashes, easy to setup, and error free PLC-blocks”
“Im very impressed by your software, its perfect for our clients need.”
“Very sophisticated software tool.”
„Nice, small and simple program.“
„I have to realize that your solution is the best on the market.“
“Easy configuration and handling.”
“It’s fun to work with.”
Prices and further information
Sales exclusively to self-employed persons and businesses. No sale to private persons. Prices excl. VAT and shipping.
PLCDataReaderLite
- one time price, no subscription
- Read data from the PLC
- Writing CSV files
PLCDataReader
- one time price, no subscription
- Read data from the PLC
- CSV and XLSX/XLSM files
- Block trigger to read many tags at once
- Copy/move/delete Trigger
- Start trigger by button
- Report templates
PLCDataWriter
- one time price, no subscription
- Write data into the PLC
- CSV and XLSX files
- Block trigger to read many tags at once
- Copy/move/delete Trigger
- Start trigger by button
PLCDataSuite
- one time price, no subscription
- All functions of the DataReader
- All functions of the DataWriter
Buy once – updates included
Not up for a subscription? No problem. You only buy our software once, including updates until the next major version. Example: You buy DataSuite version 2.7. An update is released, e.g. version 2.8. Now you can download and use the new version free of charge from our download portal. If a new main version is released, e.g. 3.0, you can continue to use your version 2.7 without restrictions or upgrade to the new version 3.0 at a reduced price.
Version 2.8.11
PLCDataSuite + PLCDataWriter: If no Writer trigger is created, the file import trigger [...]
Version 2.8.10
Adjustment of the trial limitations: Triggers can now be executed 100 times each [...]
Version 2.8.9
Date format can now be adjusted for CSV files [...]
Version 2.8.8
Windows service is now available for the english version Improvement of the [...]
Version 2.8.7
Settings are now the same for all users of a PC Adjustment [...]
Version 2.8.6
Limitations of the demo version have been adjusted Bug fixed when creating [...]
Version 2.8.5
If the settings of another PLC are copied when a new PLC connection [...]
Version 2.8.4
Improvement of license management for virtual machines
F.A.Q.
Frequently asked questions
You can provide our software with your own logo. Together with an adapted Excel template, this will result in a coherent overall picture.
An instrution for the so-called white labeling can be found in our user manual and is done very easily.
You can define in the program where which data is written. You can also define a template file to display the data in your desired format.
Yes, the software can be started as a Windows service. For details please refer to the manual.
This depends mainly on your setup. Which PLC do you use? Which PC? Where is the data stored?
If you are not sure whether the speed is sufficient, we recommend to make some tests in advance with our free trial version. With our free PLC scanner you can also test the speed of your setup and make changes if necessary.
No. The number of variables is not limited by our software. Even the smallest license, the PLCDataReaderLite, can process any number of different variables.
For this case we offer a company license. This allows you to equip as many machines or plants as you like with our software. You only pay the one-time price, no matter how many installations you make.
You can create and save an Excel file with the desired graphics, formulas and formatting using Excel. Then specify this file as a template in the trigger configuration in the program.
Real Excel files (xlsx/xlsm) and CSV files are supported. For CSV files you can choose the separator and the date format freely.
Yes, but please regard that the CP 343-1 Lean can only provide 4 connections. Our backup software needs 2 connections. Alternatively you may also use a Profinet-MPI adapter.
No. We have an automatic scan function for this case. This reads the structure and number of blocks from the PLC before a backup and automatically configures the following backup correctly.
Alternatively, you can define yourself which blocks should be backed up and which not, then the scan is switched off.
In many cases a backup should only be performed in certain machine states, e.g. when the machine is in home position. This ensures that all backed up data is consistent with each other and that the machine is immediately ready for use in case of a recovery.
In simple environments where there are clearly defined machine downtimes, the backup can also be time-controlled. This can be at night, for example, when production is at a standstill. However, there are more and more machines and plants that do not have longer downtimes. For these machines a PLC-controlled data backup is very important. This is the only way to ensure that the backup is stored consistently.
The following applies to data blocks (DB): Yes
For all other modules, the following applies: We are currently working on this function. The next release will contain this function.
If you fill out our price list request, you will receive an order form with price list as PDF by e-mail. If you need an individual offer with your company address, please send us an e-mail with your address and exact company name: " data-enc-email="vasb[at]zo-fhf.qr" data-wpel-link="ignore">
No, you can reach our support hotline from monday to friday between 8:30 am and 4:30 pm by phone and e-mail. All questions concerning the software, its functions and operation are answered by our own employees. We will be happy to help you further.
If you need extensive support with project planning and commissioning, you can take advantage of our extended service, which is subject to a charge.
No, if you have purchased a license, then you can download all updates up to the next major version free of charge from our download portal. Example: You have purchased version 1.1. An update with improvements and new functions appears as version 1.2. Now you can download and install the new version free of charge with your access data.
For a new main version, in this example version 2.0, you will receive an upgrade offer at special conditions as an existing customer.
We are currently working on this function. The next release will include this function.
For S7-300 and S7-400 applies:
– Data blocks and flags can be backed up with the DataBackup
– The saving of OBs, FCs and FBs is only possible with the DataBackupPro
For S7-1200, 1500 and ET200 applies:
– Non-optimized data blocks and flags can be saved with the DataBackup
No. The single user licenses are intended for one PC. Simultaneous use on several PCs is not possible.
Yes, but only nine times. It is NOT a floating license. The transfer to another PC is only intended for the case of a hardware defect.
Yes, without any difficulties.
We do not offer special prices for resellers. Our prices are the same for all customers.
Yes, that is expressly permitted. Machine manufacturers or system integrators like to use our company license as a kind of license flat rate: pay once, create and sell as many installations as you like.
It should be noted in this context that we only provide support to the company license holder.
In our software itself there is no limitation. Of course there are limits due to CPU power and network speeds. We cannot give an exact number, as this depends on your local conditions. A clue: We know customers who use our DataBackup software for more than 60 controllers without any problems.
Further information and trial downloads
News
Control a Wolke thermal inkjet printer with a Siemens S7
Connectiong 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 [...]
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 [...]