Trim Whitespace From an Accounting CSV Before Import

How to trim whitespace from an accounting csv before import

Step 1
Export the accounting CSV — Download the transaction, invoice, or journal CSV from your source.
Step 2
Drop into Whitespace Trimmer — Select all columns or target the Amount and Reference columns specifically.
Step 3
Run the trim and download — Export the cleaned file.
Step 4
Import into QuickBooks or Xero — Upload the trimmed CSV. Amount and reference fields should now parse without errors.

Why would an amount column have whitespace?+

Spreadsheet formulas that combine text and numbers, copy-paste from PDFs, and some bank export formats introduce invisible leading spaces.

Will trimming an amount column change the numeric value?+

No. Only surrounding whitespace is removed. ' 1500.00 ' becomes '1500.00' — the value is the same.

Does this work on tab-delimited accounting exports?+

Yes. PapaParse detects TSV and CSV formats automatically.

Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.

Step 1
Export the accounting CSV — Download the transaction, invoice, or journal CSV from your source.
Step 2
Drop into Whitespace Trimmer — Select all columns or target the Amount and Reference columns specifically.
Step 3
Run the trim and download — Export the cleaned file.
Step 4
Import into QuickBooks or Xero — Upload the trimmed CSV. Amount and reference fields should now parse without errors.

Why would an amount column have whitespace?+

Spreadsheet formulas that combine text and numbers, copy-paste from PDFs, and some bank export formats introduce invisible leading spaces.

Will trimming an amount column change the numeric value?+

No. Only surrounding whitespace is removed. ' 1500.00 ' becomes '1500.00' — the value is the same.

Does this work on tab-delimited accounting exports?+

Yes. PapaParse detects TSV and CSV formats automatically.

Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.