Input
Bank CSV file (up to 20 MB)
Or paste the text instead
Separator
Detect
Comma
Semicolon
Tab
Pipe
Lines up to and including the header
Date order
Detect (I will ask if unclear)
Month / day / year (03/04/2024 = 4 March)
Day / month / year (03/04/2024 = 3 April)
Year-month-day (2024-03-04)
Decimal mark in amounts
1,234.56 (period)
1.234,56 (comma)
Dates are checked once a file is loaded.
How amounts are laid out
One Amount column: negative = money out
One Amount column: positive = money out (many credit cards)
Separate Debit and Credit columns
Which column is which
Date
Description or payee
Amount
Memo (optional)
Debit (money out)
Credit (money in)
Check number (optional)
Running balance (optional)
Output
Layout
3 columns: Date, Description, Amount
4 columns: Date, Description, Credit, Debit
Dates in the output
2024-03-31
03/31/2024
31/03/2024
Add a Memo column
Add a Check Number column
Add a Balance column (needs a balance column above)
Reverse the row order (oldest first)
Remove exact duplicate rows
Put “Ref ” in front of descriptions that are only numbers
Keep original cell text exactly (may be unsafe in Excel)
Exports neutralise spreadsheet formulas by prefixing a quote to any cell that starts with = + - or @; plain amounts are left as numbers.
Drop rows I cannot read (totals, footers) and keep the rest
Clean the CSV
Start over
Cleaned CSV
Choose a file to begin.