CSV files
RouteConverter reads and writes .csv files — plain text tables that almost every spreadsheet, script and database can produce. Two flavors are supported: comma-separated and semicolon-separated. When a file is opened, both separators are tried, so either flavor loads without configuration.
The first row is required
The first row of a CSV file is a header row — every column is identified by its header name, not by its position. A file without a header row cannot be read.
Columns are matched by exact name (case-sensitive); the aliases below let German spreadsheets work unchanged.
Header names
| Data | Header | Aliases |
|---|---|---|
| Latitude | Latitude |
Breite, Breitengrad |
| Longitude | Longitude |
Länge, Längengrad |
| Altitude (m) | Elevation |
Höhe, Altitude |
| Speed (km/h) | Speed |
Geschwindigkeit |
| Heading (0–359°) | Heading |
Richtung, Kurs, Course, Direction |
| Pressure (mbar) | Pressure |
Druck |
| Temperature (°C) | Temperature |
Temperatur |
| Heartbeat | Heartbeat |
hr, Herzschlag, Herzschlagfrequenz |
| Time (UTC) | Time |
Zeit, Timestamp, Zeitstempel, Date, Datum |
| Description (UTF-8) | Description |
Beschreibung, Comment, Kommentar |
Latitude, longitude and description are the columns RouteConverter requires; rows missing all three are skipped. Every other column is optional and is read only when its header is present.
Encoding
UTF-8 is preferred. A file that is not valid UTF-8 is read as Windows-1252 (ANSI), which keeps files exported from older German spreadsheets readable.
See also
- Convert a file between formats — Convert GPS data
- The same header contract for spreadsheets — Microsoft Excel files