PLCDataSuite
Read and write Excel-Files with your Siemens PLC
Reading and writing Excel files with a S7 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 Siemens 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. See all our versions and prices at our new website: https://mb-datasuite.com/en/
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 3.1. An update is released, e.g. version 3.3. 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. 4.0, you can continue to use your version 3.1 without restrictions or upgrade to the new version 4.0 at a reduced price.
F.A.Q.
Frequently asked questions
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.
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
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.
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.
Yes, the software can be started as a Windows service. For details please refer to the manual.
No. The number of variables is not limited by our software. Even the smallest license, the PLCDataReaderLite, can process any number of different variables.
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.
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.
Yes, without any difficulties.
We do not offer special prices for resellers. Our prices are the same for all customers.
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.
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.
Real Excel files (xlsx/xlsm) and CSV files are supported. For CSV files you can choose the separator and the date format freely.
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.
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.
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, 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.
Software packages and trial downloads
News
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 [...]