PLC Excel Tools2020-11-14T08:00:04+01:00

PLC Excel Tools

Read and write Excel-Files with your Siemens PLC

PLCDataSuite

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.

YouTube

By loading the video, you agree to YouTube's privacy policy.
Learn more

Load video

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.

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 …

Pricelist and information

A price list and further information

Here we go

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

Download a trial

Try now for free

Here we go

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).

PLC trend evaluation with Excel

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

Excel chart

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.

DataWriter Trigger Settings

Trial

Download a trial

Try now for free

Here we go

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.

Manuel Trigger Interface
Simple setting of triggers.
Get a price list

price list and further information

Here we go

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.

Multi PLC configuration center
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 PLC simulator (similar to live data view)
The  S7 PLC simulator (similar to live data view)

Try yourself

Download a trial

Try now for free

Here we go

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.”

David R., Emil Lundgren AB

“Very sophisticated software tool.”

„Nice, small and simple program.“

T. Wolter, Hydro Aluminium

„I have to realize that your solution is the best on the market.“

Axel Schnabel, as Automation

“Easy configuration and handling.”

“It’s fun to work with.”

T. Wolter, Hydro Aluminium

Prices and further information

Sales exclusively to self-employed persons and businesses. No sale to private persons. Prices excl. VAT and shipping.

PLCDataReaderLite

399single PC and PLC
  • one time price, no subscription
  • Read data from the PLC
  • Writing CSV files

PLCDataReader

869single PC and PLC
  • 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

869single PC and PLC
  • 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

1369single PC and PLC
  • 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

10.09.2020|

PLCDataSuite + PLCDataWriter: If no Writer trigger is created, the file import trigger [...]

Version 2.8.10

10.07.2020|

Adjustment of the trial limitations: Triggers can now be executed 100 times each [...]

Version 2.8.9

12.02.2020|

Date format can now be adjusted for CSV files [...]

Version 2.8.8

21.01.2020|

Windows service is now available for the english version Improvement of the [...]

Version 2.8.7

08.11.2019|

Settings are now the same for all users of a PC Adjustment [...]

Version 2.8.6

04.10.2019|

Limitations of the demo version have been adjusted Bug fixed when creating [...]

Version 2.8.5

27.08.2019|

If the settings of another PLC are copied when a new PLC connection [...]

Version 2.8.4

26.07.2019|

Improvement of license management for virtual machines

F.A.Q.

Frequently asked questions

Can I sell the software to my customers with my own logo?2020-07-21T15:39:35+02:00

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.

I want to generate the CSV/Excel file in a certain format, how can I do that?2020-07-21T15:41:28+02:00

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.

Is it possible to run the software without user login?2020-07-21T15:39:45+02:00

Yes, the software can be started as a Windows service. For details please refer to the manual.

I want to save a lot of PLC data in Excel files in a short time. How fast does this work?2020-07-21T15:41:52+02:00

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.

I want to save many different S7 variables in Excel. Does it cost extra?2020-07-21T15:40:16+02:00

No. The number of variables is not limited by our software. Even the smallest license, the PLCDataReaderLite, can process any number of different variables.

I want to equip many machines with the Excel-PLC software. Which possibilities do I have?2020-07-21T15:45:19+02:00

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.

How can I integrate formulas and graphics?2020-07-21T15:40:29+02:00

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.

Which file formats are supported?2020-07-21T15:41:44+02:00

Real Excel files (xlsx/xlsm) and CSV files are supported. For CSV files you can choose the separator and the date format freely.

I own a CP343-1 Lean, can I use the software with it?2020-07-21T15:35:10+02:00

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.

The number and structure of my building blocks change frequently, does this cause problems?2020-07-21T15:35:25+02:00

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.

Why should the backup be done via PLC trigger?2020-07-21T15:36:07+02:00

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.

I have password protected blocks. Can I also secure them?2020-07-21T15:36:08+02:00

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.

I need an official offer. How can I get one?2020-07-21T13:46:19+02:00

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">

I have questions and need help. Does it cost me anything?2020-07-21T13:49:04+02:00

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.

Do I have to pay once more for updates?2020-07-21T15:24:50+02:00

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.

Can I backup my hardware configuration?2020-07-21T15:36:12+02:00

We are currently working on this function. The next release will include this function.

Which modules can I save?2020-07-21T15:36:24+02:00

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

Can I use a single user license on several PCs at the same time?2020-07-21T13:57:43+02:00

No. The single user licenses are intended for one PC. Simultaneous use on several PCs is not possible.

Can I transfer a single-user license, once installed, to another PC?2020-07-21T15:24:16+02:00

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.

I would like to install the software on a PC without internet connection, is that possible?2020-07-21T14:16:52+02:00

Yes, without any difficulties.

I’m a reseller. Do I get special conditions?2020-07-21T13:45:20+02:00

We do not offer special prices for resellers. Our prices are the same for all customers.

Can I resell my license?2020-07-21T15:24:34+02:00

Yes, that is expressly permitted.

Is it allowed to resell company license installations?2020-07-21T15:44:59+02:00

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.

How many controllers can I backup with the software?2020-07-21T15:36:32+02:00

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

PLCDataReader

Reading data from an S7 controller and writing them into an Excel file.

These can be protocols, measurement data or quality certificates, for example.

PLCDataWriter

Read data from an Excel file and write it into your S7 controller.

These can be recipes, parameters or machine settings, for example.

PLCDataSuite

PLCDataSuite combines all functions of the DataReader and DataWriter in one software.

Many application possibilities, e.g. recipe management with Excel files

News

Go to Top