You can edit a CSV file saved on a CF Card/USB storage device using general spreadsheet software (such as Excel) on a computer.
The sampling data (SA****.csv) saved to CF Card/USB Storage (SA*****.csv) is not the same as the [Display/Save in CSV] settings. A portion of the format is fixed.
Regardless of the settings, the calculation rows will not be output as CSV. Only the Item Name row and data display rows will be outputted.
One Date column and one Time column will be displayed in a fixed position. When outputting as CSV, the Display Format is fixed as "yy/mm/dd" and "hh:mm:ss". However, when the [Sampling Cycle] is set to milliseconds in the Action, the Time column will be fixed as "hh:mm:ss.000".
The Date/Time column item names are fixed as "Date" and "Time". In Custom Settings, the Item Name row is not set and will appear in the first row. In that case, the data column item name will be blank.
Even if you set a Text row or Text column in the Custom Settings, they will not be outputted in the CSV file.
If [Add Time Data] is not defined as the Action, the Date column and Time column will be blank and only the item name will be displayed.
In Custom Settings, if the Item Name column is not set, the far left is the Date column, the 2nd is the Time column, and the 3rd and other columns are the Data columns. The order of the data columns will follow the order set in the Custom Settings.
When multiple blocks are set, a space is inserted between blocks.
Character codes in the CSV file only uses the native code. Use Shift-JIS for Japanese. Western European languages display using CodePage 1252. If you use text that does not exist in CodePage 1252, it will be replaced by a single space.
For a read error, data is output as [****].
Even if the [Display Color], [Background Color], [Text Color], [Numeral Value Color], or [Blink] color is set, the color will not be output to the CSV file.
When a sampling data CSV file is opened in Excel
Excel Display Example for Basic Settings
The following example shows how data is saved to the CF Card with custom settings (CSV save), and how the CSV file looks in Excel.
Mode
Action: Set Time, [Overwrite old data after finishing the specified cycles] is cleared
Start Time: 09:00
Sampling Cycle: 3 hours
Cycles: 4
Blocks: 2
Display/Save in CSV Settings
Excel Display
Excel Display Example for Basic Settings
The following will introduce an example for when data is saved to the CF Card with custom settings (CSV save) and the CSV file is then opened in Excel.
When [Overwrite old data when designated block count finishes] is set
Display/Save in CSV Settings
Excel Display
When [Overwrite old data after finishing the specified cycles] is cleared
Display/Save in CSV Settings
Excel Display
