Microsoft Excel files

RouteConverter reads and writes both Excel workbook flavors: the classic Excel 97-2003 .xls format and the current Excel 2007+ .xlsx format. Routes and tracks land on the first worksheet as a normal table, so a file can be opened in Excel, edited there and loaded back.

The first row is required

As with CSV files, the first row is a header row and every column is identified by its header name. A sheet without a header row cannot be read.

Matching is forgiving: column names are compared case-insensitively and without spaces, so Breitengrad, breiten grad and BREITENGRAD all find the latitude column.

Column names

Excel files use the same column names as CSV files — see CSV files for the full table of headers and their aliases.

Written column order

When a file is written, the columns always appear in this fixed order, left to right:

Longitude, Latitude, Elevation, Speed, Heading, Temperature, Pressure, Time, Description

Columns whose data is absent are left empty rather than removed, so the layout stays stable between exports.

Supported since

Excel support ships since RouteConverter 2.22.

See also