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 generating “Excel-compatible” files with the help of WinCC. CSV files are meant here. These are a relic of the last century. They do not offer much more than a line-based storage of values. You can import them into Excel, but something else is nice.

Today, customers expect a neat layout in the form of a real Excel file (xlsx). Sometimes they even make concrete specifications regarding logo, colors or fonts.

PLC trend evaluation with Excel

Excel file with formatting, created from machine data

In addition, Excel offers a whole range of other functions that are only possible with real Excel files. Often formulas or graphs are used. It is therefore easy to design an Excel template with a measured value representation in the form of line graphs or bar graphs. The result can look like this:

Excel chart

Excel file with diagram, created from machine data

That’s the easy way

With our DataSuite (previous name PLCDataReader) you can easily create such and other Excel files with your Siemens S7 PLC. Our program reads data blocks (DB) from your S7 and generates real Excel files. You do not need WinCC, an installed Excel program or an OPC server. Simply install the DataReader on a Computer with a Profinet connection, configure the data blocks, and you’re done. It’s that easy to write Excel data with a PLC. Further information: PLC Data Tools

That can be real Excel files

  • Formulas, such as Total, Average, Max/Min

  • Diagrams: Bars, lines, pie charts, etc.

  • Graphics: Logos, drawings, etc.

  • Formatted text: Bold, italic, etc.

  • … and much more

Further information and free demo download

DataSuite 3