CSV export

CSV export lets you move measures from a series into a file that can be opened in a spreadsheet or another tool.

What the export contains

The exported file contains raw measures. It does not contain aggregated chart values.

This means a “Coffee” series with three measures of 1 on the same day exports three rows. Even if the chart displays a total of 3, the CSV keeps the original entries.

Export the whole series or a period

You can export all measures from a series, or only a period.

A complete export is useful for saving or analyzing the full history. A period export is better when you only want to work on a week, month, or precise interval.

When you choose a period, the start date must be earlier than or equal to the end date. DataJot interprets the period from the beginning of the start day to the end of the end day.

File format

The CSV contains two columns.

Date contains an ISO 8601 date with fractional seconds. Value contains the numeric value in a stable format.

Rows are sorted by ascending date, which makes the file easier to read in a spreadsheet.

File name

A complete export uses this kind of name:

Series_Name_all.csv

An export limited to a period uses this kind of name:

Series_Name_yyyy-MM-dd_yyyy-MM-dd.csv

Example

If you export the “Weight” series from June 1 to June 30, the file contains the raw measures saved during that period. You can then open them in Numbers, Excel, or another tool for your own analysis.