Documentation

CSV import

Import measures from a CSV file into one or more DataJot series.

Updated on September 6, 2026

CSV import adds measures to existing series. It can import several series from the same file, but it does not create those series for you.

Prepare the file

The file must be a UTF-8 CSV containing:

  • one date column;
  • one or more numeric value columns.

DataJot detects comma, semicolon, and tab separators, as well as the probable presence of a header row. Check the displayed separator and correct the header option if needed.

The format produced by DataJot export can be reused directly.

Import one or more series

  1. From the dashboard, a category, or a series, open Import and export, then select Import.
  2. Choose the CSV file.
  3. Indicate whether the first row contains headers.
  4. Select the date column and its format.
  5. Map each value column to an existing series, or choose to ignore it.
  6. Choose Add or Replace period.
  7. Review the summary, then select Import.

The same series cannot receive more than one column during a single import. To import several series, map each value column to a different series.

Choose the date format

Three formats are available:

  • ISO 8601 for dates exported by DataJot or another tool that uses this standard;
  • Local date for a date without a time;
  • Local date and time when the file contains both.

DataJot suggests the column and format based on the file contents. Check them in the preview, especially when the day and month could be confused.

Add or replace measures

Add keeps existing measures and inserts the new ones. Duplicates are therefore possible if the file contains measures that are already present.

Replace period first deletes, in each mapped series, every measure between the first and last importable dates, then inserts the values from the file. Measures outside this period are not changed.

Replacement is destructive. DataJot displays a confirmation with the period, affected series, and number of existing measures that will be deleted.

Ignored values

The summary shows the number of importable values, ignored rows, and ignored cells:

  • a row with a missing or invalid date is ignored completely;
  • an empty or non-numeric cell is ignored without blocking other valid values in the row;
  • a column that is not mapped to a series is ignored.

Resolve unexpected warnings before importing, especially with Replace period.