CSV Import

The exact file format Settings → Import CSV expects, with a ready-to-edit example.

The format

A plain CSV file with a header row, then one row per journal entry:

date,body,created,updated

Column	Format
`date`	`YYYY-MM-DD`, zero-padded (e.g. `2024-01-05`, not `2024-1-5`). One row per date — a second row for a date you've already used gets skipped unless you turn on "Overwrite existing entries" in Settings first.
`body`	Your entry text. Wrap it in double quotes if it contains a comma, a line break, or a quote mark — and if it contains a quote mark, write that one quote as two (`""`). See the example file below for both cases.
`created`, `updated`	UTC timestamps, RFC 3339, no fractional seconds — `2024-01-05T20:30:00Z`. If you don't know the exact time you wrote something, any time on the right date is fine; the app only ever displays the date, not the time.

Import is all-or-nothing: the whole file is checked first, and nothing is written unless it's valid. Rows that fail validation are reported individually (with the row number, same as your spreadsheet shows) rather than aborting the rest of the import.

Example

Three rows: a plain entry, one with a comma in the text, and one with a quoted phrase inside the text — the two cases the quoting rule above covers.

date,body,created,updated
2024-01-15,First day of the new job. Nervous but excited.,2024-01-15T20:30:00Z,2024-01-15T20:30:00Z
2024-01-16,"Coffee, then a long walk. Simple day, good day.",2024-01-16T21:00:00Z,2024-01-16T21:00:00Z
2024-01-17,"Rain all day. Stayed in and read. Quote of the day: ""Every day is a good day.""",2024-01-17T19:45:00Z,2024-01-17T19:45:00Z

Where a file like this comes from

Settings → Export CSV in ReminDiary itself produces a file in exactly this format — the easiest way to see it for real is to write one entry and export.
A spreadsheet: put these four column headers in row 1, one entry per row below, then save as CSV (not .xlsx).
Another journaling app's export, reshaped into these four columns.