Exported .csv File Format
Depending on the language setting in the controller, the exported .csv file uses different characters to separate the fields. See the following table for language formatting details.
Language | Date/time | Field delimiter | Number format |
|---|---|---|---|
English (en_US) | MM/dd/yyyy hh:mm:ss | , | 123.456 |
Czech (cs_CZ) | dd.MM.yyyy hh:mm:ss | ; | 123,456 |
German (de_DE) | dd.MM.yyyy hh:mm:ss | ; | 123,456 |
Spanish (es_ES) | dd/MM//yyyy hh:mm:ss | ; | 123,456 |
French (fr_FR) | dd/MM/yyyy hh:mm:ss | ; | 123,456 |
Korean (ko_KR) | yyyy-MM-dd hh:mm:ss | , | 123.456 |
Italian (it_IT) | dd/MM/yyyy hh:mm:ss | ; | 123,456 |
Japanese (ja_JP) | yyyy/MM/dd hh:mm:ss | , | 123.456 |
Portugese (pt_BR) | dd/MM/yyyy hh:mm:ss | ; | 123,456 |
Russian (ru_RU) | dd.MM.yyyy hh:mm:ss | ; | 123,456 |
Swedish (sv_SE) | yyyy-MM-dd hh:mm:ss | ; | 123,456 |
Chinese (zh_CN) | yyyy/MM/dd hh:mm:ss | , | 123.456 |
Depending on the language setting in the computer, formatting problems may occur when opening the exported .csv file. To avoid problems, always match the language used in the controller and computer.
