Exporting to JSON, CSV, and Microsoft Excel

Cordelia isn't available for macOS yet.

To export your data:

  1. Create or open a database.
  2. Choose Export in the navigation panel.
  3. Choose a format: Export XLSX, Export JSON, or Export CSV.

For .FIT export instead, see Exporting .FIT Files.

The Export panel showing Export XLSX, Export JSON, Export CSV, and Export FIT buttons.

While an export runs, the export and import buttons are greyed out, and the Database panel shows none of its buttons. They come back when the export finishes or you cancel it.

The Export page with its four formats, under a green banner: Export finished, 24 sheets written to activities.xlsx, with Open file and Show in folder.

When an export finishes, a banner says where it went. After an XLSX export, Open file and Show in folder take you to it.

Every table in the database is exported. There's no per-table selection step. Progress for large exports is reported in the console panel, the same as for imports.

Exporting to CSV

Export CSV asks for a destination folder, then writes one .csv file per database table into it.

A folder-picker dialog for a CSV Export destination folder.

Each file opens directly in a text editor or spreadsheet, with a header row of column names:

Event.csv opened in a text editor, showing a header row and many data rows of comma-separated values.

Exporting to JSON

Export JSON also asks for a destination folder, writing one .json file per table as an array of objects, one per row.

A folder-picker dialog for a JSON Export destination folder.
Activity.json opened in a text editor, showing an array of objects with fields like PrimaryKey, Timestamp, and total_timer_time.

The result is a folder with one file per table, sized according to how much data that table holds:

A file manager showing a JSON folder with one .json file per database table, from Activity.json and BikeProfile.json through to GpsMetadata.json.

Exporting to Microsoft Excel

Export XLSX asks for a single destination file instead of a folder; every table becomes its own sheet in one .xlsx workbook.

A save-file dialog set to the .xlsx extension, naming a new file export.xlsx.

Building a large workbook takes longer than the other formats, so a progress bar appears in the header the same way it does during a large import:

The Export panel mid-operation, showing a progress bar in the header.

The result opens in any spreadsheet application, with one sheet tab per table:

The exported workbook open in LibreOffice Calc, showing the DeviceInfo sheet with columns including manufacturer_id, serial_number, and product_id, and a row of sheet tabs along the bottom for every table.

See also