Handling CSV Import Errors (Garbled Text, Misaligned Columns, Dates)

When you get an error importing a CSV, you can usually fix it by adjusting the file's character encoding or format.

When text comes out garbled

• Cause: the file was saved in Shift-JIS encoding.
• Fix: open it in Excel or similar and re-save it as "UTF-8."
• Or, if your bank or card company's site lets you choose "UTF-8," use that option.

When columns are misaligned

• Cause: a field in the CSV contains a line break or a delimiter character.
• Fix: you can set the "column mapping" manually on the import screen. Pick the columns for date, amount, and description.

When you get a date-format error

• Supported formats: YYYY/MM/DD, YYYY-MM-DD, and the Japanese YYYY年MM月DD日.
• If you're using an unsupported format, convert it in bulk in Excel first, then import.

Errors in the amount column

• Comma-separated amounts (like 1,000) are handled automatically.
• Negative amounts are recognized by a ▲, △, or − sign.
• Amounts mixed with letters or symbols will cause an error.

If it still doesn't work

Contact us through the support form and include the error message along with your bank or card company name. Support can handle the major formats.

Related articles

• Importing a bank statement CSV
• Importing a credit card statement CSV