PLC Excel Tools
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.
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.
Features
Processes real Excel (xlsx) or CSV files
Easy to setup and operate
No additional software required
Unlimited number of variables included
Compatible with Windows 7, 8 and 10
Supports all major PLC 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, LTODCompatible with all models with ProfiNet:
e.g. ET200, S7-300, S7-400, S7-1200, S7-1500, WinAC, Siemens Software Controller, VIPAExcel files with logos, diagrams, formulas, layout, etc. possible
Many applications
Recording of quality data in Excel files
Production and machine data analysis
Configuration of machines and plants
Backup and restore machine settings
Recipe management with Excel files
And much more …
Request a price list and further information
PLCDataSuite explained in 3 minutes
More videos
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.
Full control to your PLC
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.
Simple setting of triggers.
Trial
Try now for free
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. You can find more details here: References
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)
Request a quote
Request a price list and further information
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.” (translated from German)
„Nice, small and simple program.“ (translated from German)
„I have to realize that your solution is the best on the market.“ (translated from German)
“Easy configuration and handling.” (translated from German)
“It’s fun to work with.” (translated from German)
A wide range of options for your S7
With our PLCDataBackup you can master the challenges of the industry 4.0 easily and economically completely without programming the PLC.
You can perform a manual or automatic backup of PLC data with our PLCDataBackup. You are well prepared for the worst-case scenario and can restore important data quickly and easily. Never before has it been so easy to keep control of the S7.
Further products:
How the PLCDataBackup works:
Automatic and manual backup
Easily restore previous data state
Scanning the data blocks
PLC Data Backup
Our products
PLCDataReader
Read data from a PLC and write it to Excel or CSV files.
Starts from 399 EUR.
PLCDataWriter
Read data from Excel or CSV files and writes them into your PLC.
Starts from 869 EUR.
PLCDataSuite
The PLCDataSuite combines all functions of the DataReader and the DataWriter in one software.
Starts from 1369 EUR.
News
Save data and function blocks of a PLC automatically
Many S7 programmers ask themselves: How can I automatically save data and function blocks of a PLC? The answer is surprisingly easy for the older series, such as the S7-300 and S7-400: The new [...]
It’s simple: Writing 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 [...]
PLCDataBackup – Operation via command prompt
You would like to use the command prompt for the PLCDataBackup software? No problem! Besides the user interface you can also operate the software via the command line. You only need a few steps to [...]
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 [...]
Better use of production data
If you want to make your production more efficient, you have to collect and use your data. For user companies, this means intelligently linking technical concepts such as Big Data and Industry 4.0 with [...]
Academic licenses for research and teaching
With our PLC Data Tools great things can be created even beyond the industrial everyday life. This is especially true for research and teaching at colleges and universities. But there are also exciting projects [...]
Applications in the food industry
We are always amazed at how diverse the applications of our customers are. For example, our PLC Data Tools is used to brew beer, produce steel, produce switches and build sports cars. Customer applications [...]