CSV Upload Not Working

If your CSV upload isn't working, here are the most common causes and fixes.

"Unsupported format" or "No transactions found"

Cause: GigBooks couldn't detect your bank's format or find transaction data.

Fixes:

• Make sure you downloaded a CSV file, not a PDF, OFX, or QIF
• Open the file in a text editor to verify it contains comma-separated data
• Some banks export as semicolon-separated (;) — GigBooks handles this, but check for other delimiters
• If your bank isn't auto-detected, GigBooks will prompt you to map columns manually

"Invalid date format"

Cause: Dates in an unexpected format.

Fixes:

• Most Canadian banks use YYYY-MM-DD or MM/DD/YYYY
• If your bank uses a different format, try re-exporting with different settings
• Some banks include time of day — this is handled automatically

File too large

Cause: CSV file exceeds the size limit.

Fixes:

• GigBooks accepts files up to 10MB
• If your file is larger, split it by date range and upload in parts
• Remove any extra rows or formatting your bank may have added

Encoding issues (garbled characters)

Cause: File uses non-UTF-8 encoding.

Fixes:

• Open in Excel, then Save As → CSV UTF-8
• Or use a text editor to convert encoding to UTF-8

Bank-specific tips

• CIBC: Files have no headers and only 3 columns — this is expected, GigBooks handles it
• TD: Look for "Download" in the account activity section, choose CSV format
• RBC: Export from the "Activity" tab, select CSV format and your date range