CSV import format
Spec for Mirai Kanai's dedicated CSV format (UTF-8, comma-separated).
Download the template CSV
Includes sample data. Use it as a reference when creating your file.
Header row (line 1, required)
日付,種別,カテゴリ,金額,取引先,メモ日付RequiredYYYY-MM-DD format (e.g. 2026-01-15)種別Required“収入” (income) or “出費” (expense)カテゴリRequiredA display name registered in your categories (e.g. 食費)金額RequiredDigits only (e.g. 1500)取引先OptionalPayee name (may be blank)メモOptionalA note (may be blank)Sample data
| 日付 | 種別 | カテゴリ | 金額 | 取引先 | メモ |
|---|---|---|---|---|---|
| 2026-01-01 | 出費 | 食費 | 1500 | セブンイレブン | 夜食 |
| 2026-01-05 | 収入 | 給料 | 300000 | 株式会社〇〇 | 1月分給与 |
| 2026-01-10 | 出費 | 光熱費 | 8000 | 東京電力 | 1月分 |
| 2026-01-15 | 出費 | 交通費 | 3000 | JR東日本 | 定期券 |
| 2026-01-20 | 出費 | 娯楽費 | 5000 | 映画館 |
Check before importing
Green: OK (importable)
Yellow: Category not registered. You can switch to an existing category from the dropdown.
Red: Error (invalid date or amount). That row cannot be imported.
Notes
- UTF-8 encoding is recommended (Shift-JIS is auto-detected too)
- Up to 1,000 rows per file
- Category names must exactly match a registered display name
- CSV files we can read as they are don't count toward your monthly limit (only files read by AI count)