Many types of CSV files are supported, even if they don’t exactly match the format of one of the vendors listed on the data sources overview page. Please read the format specification below if you would like to output your data in a way that Njord Analytics can understand.

It is crucial that accurate timestamp information is contained in the CSV file. The timestamp column could be named: Timestamp, Datetime, ISODateTimeUTC, SecondsSince1970, or similar. The following formats are supported for timestamp columns:

• An ISO 8601 formatted time string (e.g. 2022-04-29T13:09:29.149Z)
• Seconds or milliseconds since 1970 (Unix format, e.g. 1651237769149)
• Days since 2000 (Excel format)
• Other string formats are interpreted in DMY order by default. You can change the date order to MDY or YMD when uploading the file. Always prefer UTC timestamps, although support for time in local timezones is available as a configuration option in the upload form.

Lat and Lon columns are mandatory (except in auxiliary files, such as for wind data), and should be formatted as decimal degrees (ddd.dddddd).

For other common metrics, please match the standard names. You may include more columns than that, of course.

To automatically find starts, and the start line, you may include the following columns:

• TimeToGun (in seconds): to indicate start times.
• Portlat, Portlon, Stbdlat and Stbdlon (all in decimal degrees ddd.dddddd): to indicate the start line position. It is sufficient if these values appear in at least one row in the CSV file before the start (e.g. when the line is pinged). You don’t need to fill the entire file.

Please refer to the following sample file: njord-csv-sample.csv