Importing Csv Format Data Logs To Non-Usa/Uk Versions Of Microsoft Excel - Siemens SIMATIC S7-1200 System Manual

Hide thumbs Also See for SIMATIC S7-1200:

Table of Contents

12.8 Constraints

Other browsers

Follow the conventions of your Web browser to import and install the Siemens certificate.

After you have installed the Siemens security certificate "S7-1200 Controller Family" in the

Internet options for your Web browser content, you will not be required to verify a security

prompt when you access the Web server with https:// ww.xx.yy.zz.

The security certificate remains constant through reboots of the CPU; however, if you

change the IP address of the device you must download a new certificate if you are using a

browser other than Internet Explorer or Mozilla Firefox.

Importing CSV format data logs to non-USA/UK versions of Microsoft Excel

Data log files are in the comma-separated values (CSV) file format. You can open these files

directly in Excel from the Data Logs page when your system is running the USA or UK

version of Excel. In other countries, however, this format is not widely used because

commas occur frequently in numerical notation.

To open a data log file that you have saved, follow these steps for non USA/UK versions of

1. Open Excel and create an empty workbook.

2. From the "Data > Import External Data" menu, select the "Import Data" command.

3. Navigate to and select the data log file you want to open. The Text Import Wizard starts.

4. From the Text Import Wizard, change the default option for "Original data type" from

"Fixed width" to "Delimited".

5. Click the Next button.

6. From the Step 2 dialog, select the "Comma" check box to change the delimiter type from

"Tab" to "Comma".

7. Click the Next button.

8. From the Step 3 dialog, you can optionally change the Date format from MDY

(month/day/year) to another format.

9. Complete the remaining steps of the Text Import Wizard to import the file.

S7-1200 Programmable controller

System Manual, V4.2, 09/2016, A5E02486680-AK