Let your S7 PLC work with Excel files
The PLCDataSuite is a simple and cost-effective way to read data directly from a Siemens Programmable Logic Controller (PLC) and save it in an Excel file. Just as easy: Write data from an Excel file to a PLC. The DataSuite contains both the functions of the PLCDataReader and the PLCDataWriter. The DataSuite is a program of our PLC Data Tools.
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
and much more …
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.
Try yourself
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 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
You miss something?
The DataSuite is a combination of DataReader and DataWriter. All features can be found here:
Our products
Related news
Customized DataSuite extension
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: 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 [...]
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 [...]