PLC-data in Excel
![](images/Homepage-Bilder/S7toExcel.png)
![](images/Homepage-Bilder/S7toExcel.png)
![](images/katalog/SPSDateninExcel.png)
Create with the S7-PLC Excel-files
Site / Branch / Standort License
windows (any)
writing Simatic S7 Processdata to Excel file by
XLS-Template
count of variables unlimited
all possibilities of enhancement
"PLC-data in Excel" creates Excel files from any PLC variables according to your design.
For Windows (any)
You design the look directly in Excel.
Advantages
- Free evaluation without registration
more...
ARTNR: 9773-S7-E-3
PLC-data in Excel-tool - Expert
EAN number: | 4260363246453 | |
HS-code: | 85234990 |
"PLC-data in Excel" creates Excel files from any PLC variables according to your design.
For Windows (any)
You design the look directly in Excel.
Advantages
- Free evaluation without registration
- Simple and fast logging
- Industrial reliability
- Qualified support
- Comprehensive documentation
- Siemens controls like
SIMATIC LOGO! / SIMATIC S7-200 / SIMATIC S7-300 / SIMATIC S7-400 / SIMATIC S7-1200 / SIMATIC S7-1500 / S7-compatible PLC (for e.g.: VIPA, Saia, Berthel) / S5 (over S5-LAN++) / S7-LAN - Reading and logging of
inputs, outputs, flags, data-blocks, timers and counters - PDU-optimized access for
high-performance acquisition of consistent data - Abort-detection for backup of
constant connections through automatic reconnection - Addressing of all data areas with
identifiers in the format of the SIEMENS and IEC syntax - Boolean values and numeric values of
1 to 8, 16, 32 and 64 bit data length – also as ARRAY OF - Signed and unsigned integer-values
BYTE, WORD, DWORD, INT and DINT – also as ARRAY OF - Single/double precision floating point values
REAL and DOUBLE – also as ARRAY OF - Date and time values about
TIME, S5-TIME, DATE and DATE_AND_TIME - Characters and character strings above
CHAR to S7-STRING – also via BYTE with its own encoding - Supported Platforms
Windows (any) - free create of the Excel-tables with formulas and formats
- Insert data records (regions) to Excel file, (as of V 2.0)
- Operation without Excel-installation
- event- and time-controlled writing per worksheet (time-/event-trigger)
- no programm in the PLC necessary
- no limit on the count of variables
- file-creation with time-stamp in the file-name
- easy parameterization
- the addresses of the PLC-variables are specified directly in the Excel table (for e.g. PLC_ADDR,DB10.DBW100,INT)
- S7-LAN
- S7-1500
- S7-1200
- S7 300/400
- S7-200
- S7-SoftPLC
- Logo!-SPS
- VIPA-S7
- all S7 compatible controls
- S5 (over S5-LAN++)
The template includes all information as:
- target directory
- target-file with format-specification for the date and time
- connection-parameters to the PLC (ip-address etc.)
- addresses of the PLC-variables
- Time or event trigger for generating the target file / appending records
- This information is indicated with the help of keywords at any position in the Excel worksheet. Variables from the PLC will appear in the target file at the same position (cell), where the relevant variable address has been entered.
Template:
Result:
screenshot of the configuration
![](data/beschreibung/../../images/Homepage-Bilder/S7toExcel-Konfig.png)
program flow
![](data/beschreibung/../../images/Homepage-Bilder/S7toExcel-Programm.png)
Differences of license types:
Features
|
Standard
|
Advanced
|
Expert
|
Evaluation
[Demo] |
Trigger based log-file creation |
x
|
x
|
x
|
x
|
Maximum number of channels |
1
|
1
|
1
|
1
|
Maximum number of triggers |
1 / Sheet
|
1 / Sheet
|
1 / Sheet
|
1 / Sheet
|
Interval trigger |
x
|
x
|
x
|
x
|
Value-change trigger |
x
|
x
|
x
|
x
|
Boolean trigger |
x
|
x
|
x
|
x
|
Conditional/edge trigger |
x
|
x
|
x
|
x
|
Extend worksheet with region(s) |
|
|
x
|
x
|
Maximum number of variables |
100
|
∞
|
∞
|
∞
|
License | |
Single License | Installation on one workstation/PC |
Subsequent License | Installation on an additional workstation/PC one subsequentlicense for each additional workstation/PC Requirement: 1x singlelicense |
Site / Branch / Standort License | unlimited number of installations at one location (= one postal address) of a company |
Support/Updates:
A license is purchased once for a specific installation or as a dongle and is valid indefinitely (= unlimited license lifetime). In addition, our top-level support from 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 (= current demo-version) and new functions can only be obtained with valid support. Support requests can still be made, but depending on the scope, these will be dealt with later.
Up to one month before the end of active support, we will inform you about the possibility of extending support. A support renewal is possible at any time in the first year after the end of support for 10% + 20% for each started quarter (since the end of support) of the current list-price. After the first year, a new license must be purchased for the support renewal.
Differences between"PLC-data logging/triggering" and "PLC-data in Excel" (Find the right product for your requirements):
Features
|
PLC-data logging/triggering
|
PLC-data in Excel
|
What happens in the event of a trigger event |
Defined values are appended in a given file with a time stamp
one file for several trigger events (infinite list) |
The specified file is filled with values from the controller and saved as a new file
one Excel file per trigger event |
Filename |
Specified by the configuration of the tool
|
Can be specified by the PLC, otherwise by the tool
|
Number of configured S7 connections |
Depending on the license from 4 to 256
|
1 connection
|
Number of variables/connection |
Depending on the license from 100 to 1000
|
Depending on the license from 100 to unlimited
|
Licensing process:
Free download of the complete range of functions
for 14 days:
/9773-S7-E-3_sps-daten-in-excel.html/SUP-9773-S7-A-3_sps-daten-in-excel.html/SUP-9773-S7_sps-daten-in-excel.html/
Licensing under "License"
(mouse click on the key symbol)
Your machine-code for this PC with order by email
to verkauf@process-informatik.de
You will receive a license code to enter under
"License", so that the program is licensed on your
PC.
With a USB-dongle, there is no machine-code, the
USB-dongle contains the license, comes via UPS.
![Produkbild](images/showimage.php?size=227.5&path=../images/katalog/SPSDateninExcel.png)
Logging of workflows, recording of operating states, archiving of process data, all of these requirements can be handled
with "PLC data in Excel".
You create a template-file in Excel, enter special keywords as placeholders for PLC-data such as flags, timers, counters,
I/O and the connection-parameters and save the file as a template for the tool. The tool runs on a Windows compatible PC
and polls the defined controller. As soon as the trigger event occurs, the configured PLC-data is read out and entered
in the template file instead of the placeholder and saved under a specified file-name in the specified directory.
It is also possible to communicate with controllers without a network-interface via S7-LAN (with S7-200/300/400) or
S5-LAN++ (with S5-90U to 155U).
A corresponding Excel-file for each trigger event.
support-service:
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel standard single-license
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
Software Update & Support service dongle-version
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel advanced single-license with dongle-license
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
Software Update & Support service dongle-version
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel standard single-license with dongle-license
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel expert Site / Branch / Standort License
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel expert subsequent-license
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a S7-To-Excel expert single-license
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel advanced Site / Branch / Standort License
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel advanced subsequent-license
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel advanced single-license
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel standard Site / Branch / Standort License
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel standard subsequent-license
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
Software Update & Support service dongle-version
Automatical Upgrade for innovations incl. technical support for 12 months for a S7-To-Excel expert single-license with dongle-license
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
accessories:
PLC-data in Excel license-dongle AddOn
USB-dongle with license-key instead of software-key windows (any) from Win7
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
Einzel-Lizenz
PLC-data in Excel-tool - Standard
Singlelicense windows (any) writing Simatic S7 Processdata to Excel file by XLS-Template limited for 100 variables
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
PLC-data in Excel-tool - Advanced
singlelicense fwindows (any) writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
PLC-data in Excel-tool - Expert
singlelicense windows (any) writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited all possibilities of enhancement
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
Folge-Lizenz
PLC-data in Excel-tool - Standard
subsequentlicense windows (any) writing Simatic S7 Processdata to Excel file by XLS-Template limited for 100 variables
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
PLC-data inExcel-tool - Advanced
subsequentlicense windows (any) writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
PLC-data in Excel-tool - Expert
subsequentlicense windows (any) writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited all possibilities of enhancement
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
Standort-Lizenz
PLC-data in Excel-tool - Standard
Site / Branch / Standort License windows (any) writing Simatic S7 Processdata to Excel file by XLS-Template limited for 100 variables
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
PLC-data in Excel-tool - Advanced
Site / Branch / Standort License windows (any) writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
PLC-data in Excel-tool - Expert
Site / Branch / Standort License windows (any) writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited all possibilities of enhancement
![](images/Homepage-Bilder/S7toExcel.png)
plus VAT. and shipping
PLC-software-tools
![](images/showimage.php?path=Homepage-Bilder/SPS-Datensicherung-Gesamt.png&size=150)
PLC-Backup and restore for the S5- and S7-PLC
![](images/showimage.php?path=Homepage-Bilder/CIM2001.png&size=150)
Process - Visualisation, PLC - data directly into Excel
Industrie 4.0 tools
![](images/showimage.php?path=Homepage-Bilder/CoDaBix-Grundbild.png&size=150)
Universal - simple - contemporary - one platform for many purposes
![](images/showimage.php?path=Homepage-Bilder/opclogo.png&size=150)
data recall by OPC-Server
![](images/showimage.php?path=Homepage-Bilder/S7TimeServer.png&size=150)
Easy automatic setting of the S7-PLC-time
![](images/showimage.php?path=Homepage-Bilder/s7filelogger.png&size=150)
Record of PLC-variables over time