PLCDataSuite
Write Excel data to Siemens PLCs and
save data to Excel files
Read and write Excel files with your Siemens S7 PLC
With our PLCDataSuite you can read and write Excel files with your Siemens S7 PLC Programmable Logic Controller (PLC). The DataSuite contains both the functions of the PLCDataReader and the PLCDataWriter.
By loading the video, you agree to YouTube's privacy policy.
Learn more
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 S7 PLC connection, the memory options and the assignment of PLC data to the Excel cells or rows. Done! Now program the PLC to fit. We support you with an example program for TIA-Portal.
Varios applications
Simple recording of production and quality data in Excel files
Control of machines and plants by Excel files
Backup and restore machine settings
Recipe management with Excel files
Configuration of a production process using XLSX or CSV files
and much more …
Try yourself
Licensing
Convenient: the single user license
Flexible: the company license
System requirements and compatibility
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 PLC models with ProfiNet:
z.B. ET200, S7-300, S7-400, S7-1200, S7-1500, WinAC, Siemens Software Controller, VIPA- Unlimited number of variables included
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)
Processes real Excel files (xlsx) and CSV files.
ERP integration made simple
With our DataSuite, you can connect a machine or plant to a merchandise management system, an ERP system or another higher-level system. This means that the machine data can also be used in other areas of the company. In addition, orders and machine parameters can be loaded directly into the system.
Further details: ERP connection of machines and plants
Simple data assignment
By simply assigning Excel columns or rows to data block addresses, you determine which data is to be written to a S7 PLC. Our flexible trigger system allows you to configure different variants. These trigger conditions can be set anywhere in the PLC program.
Simple assignment of which Excel data should be written to which address in the Siemens S7 DB.
Which file can it be?
You have the choice: Enter the file name with the PLC (via data block) or should the same file always be written? You can also create a selection dialog on the Computer so that a user can determine the file name and the storage location.
Simply assign which Excel data should be written to the Siemens S7 DB at which address.
Simple setup and operation
Delivery including comprehensive operating instructions with technical background, examples and tips
Sample application preconfigured so you can start right away
Exact and clear assistance in the program, e.g. for setting up the DBs in TIA Portal
Service included
If you have any questions you can of course contact us by phone or email. We will be glad to help you with questions and problems. In addition, each software comes with a detailed manual (PDF file).
Simple setup and operation
Delivery including comprehensive operating instructions with technical background, examples and tips
Sample application preconfigured so you can start right away
Exact and clear assistance in the program, e.g. for setting up the DBs in TIA Portal
Our products
Related news
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 DataSuite 3 Software (old name PLCDataWriter) you can [...]
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 DataSuite 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 DataSuite Basic (previous name: PLCDataReader Lite)
Our PLC Data Tools has been available for several years now. Our DataSuite software has been continuously developed and extended by new functions. We now offer the DataSuite Basic as a slim and [...]