Import CSV Data

Note: Importing data from a CSV file is only available on iOS 15.4/macOS 12.4 and later.

You can import your data from a CSV file. The CSV must include a header row. The CSV file should have the following columns:

Required columns:

• Date (String)
  yyyy-MM-dd, yyyy-MM-dd HH:mm, yyyy-MM-dd HH:mm:ss, yyyy-MM-dd HH:mm:ssZ, or yyyy-MM-dd'T'HH:mm:ssZ format. If parsing fails, the date defaults to the current time.

• Category (String)
  Matching is case-insensitive. If not found, Expenses falls back to No Category when available; otherwise it uses the first category for the flow type.

• Price (Double)
  -: expense, +: income. If empty or invalid, it is treated as 0 (expense). If you need to use , as a decimal separator, wrap the value with double quotes like "-12,34".

• Notes (String)
  The value can be empty, but the column must exist.

Optional columns:

• Currency (String)
  If missing or empty, it uses the sheet currency. Values are uppercased.

• Rate (Double)
  Fixed exchange rate. Only positive values are used. Ignored if Currency matches the sheet currency.

• Rate Type (String)
  Case-insensitive; spaces or hyphens are treated like underscores. Allowed values: auto_refresh, custom, default.

• Paid By (String)
  Useful for shared sheets. The value is matched against sheet participants by name or record ID. You can also use Me for the current user. If the column is missing, the value is empty, or it doesn’t match a participant, Expenses falls back to the current user when available. In non-shared sheets, this column is ignored.

Exchange rate behavior (when Currency differs from the sheet currency):

• Rate Type = auto_refresh: always use auto-refresh.
• Rate Type = custom: use Rate if provided; otherwise auto-refresh.
• Rate Type = default: use Rate if provided; otherwise use the sheet reference rate.
• Rate Type empty: use Rate if provided; otherwise use the sheet reference rate.

Example:

Date,Category,Price,Currency,Rate,Rate Type,Notes,Paid By
2024-03-31,Groceries,-1000.0,JPY,,default,Supermarket,Alice
2024-03-30,Salary,2500.0,USD,1.08,custom,,
2024-03-29,Transport,-300.0,,,,,Me
...

┏━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━┓
┃    ┃ Date       ┃ Category    ┃ Price         ┃ Currency ┃ Rate Type ┃ Notes             ┃ Paid By ┃
┡━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━━━╇━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━┩
│    │ 2024-03-31 │ Groceries   │      -1,000.0 │ JPY      │ default   │ Supermarket       │ Alice   │
│    │ 2024-03-30 │ Salary      │       2,500.0 │ USD      │ custom    │                   │         │
│    │ 2024-03-29 │ Transport   │        -300.0 │          │           │                   │ Me      │
...