CSV export

CSV export lets you use DataJot measures in a spreadsheet, save a copy, or import them back into DataJot.

Export one or more series

Export is available from the dashboard, a category, or a series. Where you start only determines the suggested selection:

• the dashboard preselects all series;
• a category preselects the series it contains;
• a series detail page preselects that series.

You can change this selection before exporting.

1. Open Import and export, then select Export.
2. Select the series to include.
3. Choose their name or key as the column header.
4. Choose All data or Period.
5. Check the number of measures shown for each series.
6. Select Export, then choose where to save the file.

If you use keys as headers, DataJot keeps the name for a series that has no key or whose key is not unique within the selection.

What the export contains

The file contains raw measures, not the aggregated values in the chart. If three measures of 1 produce a daily total of 3, the CSV keeps three entries.

The first column is Date. One value column is then created for each selected series. Cells remain empty when a series has no measure at the date of that row.

Export a period

Both the start and end dates are included. The start date must be earlier than or equal to the end date.

The summary lets you check the total number of measures and their distribution by series before creating the file.

File format

The Date column uses ISO 8601 with fractional seconds. Rows are sorted by ascending date, and numbers use a stable format that does not depend on the device language.

This format can be used directly with the Import a CSV file guide.