S7-to-Excel

Exporting process data from the SIMATIC S7 to Excel

S7-to-Excel product image
Using Excel templates, process data, data on malfunctions, production, entire recipes and more are called up consistently directly from the SIMATIC S7 and become part of the process chain according to your own specifications - without further post-processing.

How to use

The graphic Windows application, also known as the "S7-to-Excel tool", records and logs every available date in the desired format according to specifications in the specially defined Excel template. The evaluations automatically created in this way thus become – without post-processing – directly part of the process chain and can provide, for example, daily current forecasts and much more without manual intervention.

Application view from S7 to Excel.

While the desired data type, its formatting and coding can be defined for each data area, all data areas can be specifically logged according to certain specifications. Triggers are available for logging after a certain interval, after an edge and after a certain condition.

1. Define the Template

Example of a template in Excel.

2. Fill in the Worksheets

Example of a completed Excel spreadsheet.

In addition, the free definition of recurring regions based on the assignment of data areas to table areas enables extended evaluations, which thus also allows, for example, a simple comparison of processes. This extension of the worksheets is thus possible dynamically in horizontal and vertical direction.

Advantages

  • Free evaluation without registration
  • Simple and fast logging
  • Industrial reliability
  • Qualified support
  • Comprehensive documentation

Editions

FeatureStandardAdvancedExpertEvaluation
Trigger based log file creationxxxx
Maximum number of channels1111
Maximum number of triggers1 / Sheet1 / Sheet1 / Sheet1 / Sheet
Interval triggerxxxx
Value change triggerxxxx
Boolean triggerxxxx
Conditional / Edge Triggerxxxx
Expand worksheet with region(s)xx
Maximum number of variables100

Licensing

A licence is purchased once for a specific installation or as a dongle and is valid for an unlimited period (= unlimited licence lifetime). In addition, our top level support by our developers as well as updates including new functions can be purchased for 12 months.

Shortly before the support expires, it is possible to extend it for at least another 12 months for 10% of the current list price. Updates and new functions can only be obtained with valid support. Support requests can still be submitted, but will be processed on a priority basis depending on their scope. Up to one month before the expiry of active support, we will notify you of the possibility of support renewal. A support renewal is possible at any time in the first year after expiry of the support for 10% + 20% for each started quarter (since expiry of the support) of the current list price. After the first year, a new licence must be purchased for the support renewal.

Features

  • Siemens controllers like ...

    SIMATIC LOGO! / SIMATIC S7-200 / SIMATIC S7-300 / SIMATIC S7-400 / SIMATIC S7-1200 / SIMATIC S7-1500

  • Reading and logging of ...

    Inputs, outputs, flags, data blocks, timers and counters

  • PDU-optimised accesses for ...

    High-performance logging of consistent data

  • Termination detection to ensure ...

    constant connections through automatic reconstruction

  • Addressing of all data areas with ...

    Identifiers in SIEMENS and IEC syntax format

  • Boolean values and numeric values of ...

    1 to 8, 16, 32 and 64 bit data length - also as ARRAY OF

  • Integer values with and without sign via ...

    BYTE, WORD, DWORD, INT and DINT - also as ARRAY OF

  • Single/double precision floating point values via ...

    REAL and DOUBLE - also as ARRAY OF

  • Date and time values via ...

    TIME, S5-TIME, DATE and DATE_AND_TIME

  • Characters and character strings via ...

    CHAR to S7-STRING - also via BYTE with own encoding

  • Supported platforms

    Windows