Create a wide-format CSV data file
- Last UpdatedMay 09, 2023
- 1 minute read
To create a wide-format CSV data file
-
Open a new file using a spreadsheet for a CSV file, or text editor for a JSON file.
-
On line 1, define the header.
For CSV, name the first column "DateTime" (case-insensitive). For JSON, name the first parameter "dateTime" (case-sensitive).
Assign tag names to the remaining columns/parameters.
-
Beginning on line 2, add values for each record, ordered by time from the oldest to the newest.
-
Save the file as a CSV file or JSON file, as appropriate.
Wide-format data file example
This CSV file imports four records.
DateTime,Numeric_Tag,String_Tag
2019-05-31T10:30:00.000Z,1,String 1
2019-05-31T10:30:00.500Z,2,String 2
2019-05-31T10:30:01.000Z,3,String 3
2019-05-31T10:30:01.500Z,4,String 4