UK Bank CSV Cleaner

A UK bank CSV that Google Sheets™ can use, and a bank file laid out for the bank import of Xero™, QuickBooks™ or Sage™. Free to check. Dates that read two ways are listed before anything is written, and the conversion goes to a new tab, never over your original.

Install: Install from Google Workspace™ Marketplace, or search for “UK Bank CSV Cleaner” under Extensions › Add-ons › Get add-ons. It is an editor add-on for Google Sheets™ on desktop browsers — it does not run in the Google Sheets™ mobile apps.

Before

Unusable

A bank export with dates stored as text, amounts with £ signs and thousands commas, paid in and paid out in two columns, and a row of spaces at the end.

After

Ready

Real dates, real numbers, one signed amount, and a new tab in the layout your accounting package asks for. A preview first, and Undo is always there.

The one to know about

A bank import fails on small things: a date that reads 03/04 two ways, an amount that is text, a heading the package does not recognise. Each export also has its own shape. This add-on reads the shape, says what is wrong in plain English, and lays the result out as a new tab, so the file you upload is not the file the bank gave you, and the file the bank gave you is untouched.

What it covers

UK bank statement CSVs, by spreadsheet only: the add-on never connects to a bank or to an accounting package.

Clean a bank CSV: make the dates and amounts of an export usable in Sheets, whichever UK bank it came from.
Lay it out for: Xero bank statement import, QuickBooks Online (UK) 3-column or 4-column, Sage Accounting 3-column or 4-column. The result is written to a new tab.
Check before uploading: a sheet you built yourself, checked against the package's own bank-import rules.

Where a bank's layout has not been confirmed against a real export, the add-on says so and explains what it found rather than rewriting your cells. The current state is in the guide.

Three steps

Install. From Google Workspace™ Marketplace, or Extensions › Add-ons › Get add-ons and search for the name.
Scan. Open a spreadsheet, then Extensions › UK Bank CSV Cleaner › Open. Pick Clean a bank CSV or Check before uploading.
Fix. Every finding explains what is wrong and why it matters to a bank import. The safe ones have a one-click or guided fix, with a preview of the exact cell changes before anything is applied — and every ambiguous date listed before the write, never after it.

What it checks

Every finding carries a rule code, so a report you read again in six months still says which check produced which line.

Cleaning an export

`BK-01`	Bank not recognised, or only a weak match
`BK-02`	Rows below the data; opening-balance and other non-transaction rows
`BK-03`	Header row repeated inside the data
`BK-04`	Empty column, or a column with no heading
`BK-05`	Year-less and two-digit-year dates
`BK-06`	Date and time in one cell
`BK-07`	Dates stored as text, and which way round they read
`BK-08`	Whole-pound amounts missing their decimals
`BK-09`	Amounts stored as text (symbols, separators, brackets)
`BK-10`	Paid in and paid out in two columns
`BK-11`	Unsigned amount with a debit/credit indicator, reversed card signs (explained only)
`BK-12`	Payment type apart from the description; missing payee
`BK-13`	Foreign-currency rows
`BK-14`	Row count at a known export cap
`BK-15`	Duplicate rows from overlapping exports
`BK-16`	Running balance that does not follow the amounts
`BK-19`	Convert to the chosen package's layout, in a new tab
`BK-20`	Stray spaces, including blank cells

Checking before an upload

`BK-17`	The package's layout: headings, dates, amounts, zeros, weekday, size limits, blanks
`BK-18`	Formula-injection prefix in the exported report (explained only)
`BK-20`	Stray spaces, including blank cells

See the guide for what the rules mean. The package rules are built from the published help pages of the packages, and the bank layouts from the banks' own exports where we have seen one; where a behaviour could not be confirmed, the rule explains the problem and leaves your cells alone.

Free vs Pro

Free

£0

Unlimited scans and explanations, both directions
The ambiguity report
The conversion to a new tab, once the bank's layout is confirmed
The space fix, applied
Undo — always, in every tier

Pro

£25 per year, or £3 a month

Everything in Free
Every other fix, one-click and guided, with a preview
Saved settings, so the date question is asked once
An exportable report, written to its own tab
3 activations on one key
30-day free trial, no card · 30-day full refund

Prices and checkout

Your data

Your bank data never leaves Google. The rules run in the sidebar, in your browser. The only network traffic this add-on makes is to the licence server, and only a licence key, an anonymous install id and which host this is ever cross it. The add-on asks for this spreadsheet only — not your Drive, not your other files. Privacy notice.

FAQ

Does my data leave Google? No. Scanning and fixing both happen in the sidebar, against the Sheets API, without your content going anywhere else.

Does it connect to my bank? No. It edits the spreadsheet only. You download the CSV from your bank and upload the result to your accounting package yourself.

How should I import a CSV into Sheets? File › Import › Upload, with “Convert text to numbers, dates and formulas” unticked, so dates and amounts arrive as text the scan can read.

What if I want to undo a fix? Every fix saves a hidden copy of the sheet first. Press Undo in the sidebar to restore it, in any tier, at any time. Converting to a new tab never changes the original sheet, and Undo deletes the new tab.

Is it for UK banks only? Yes. Dates are read day-first and the package rules follow the UK help pages.

Is this affiliated with any bank or accounting package? No. It is an independent add-on by AppGarden. The names above are trademarks of their owners and are used only to describe compatible file formats.

Also for Excel™: UK Bank CSV Cleaner for Excel. The same licence key works in Google Sheets and Excel.

Support

Email support@appgarden.co.uk. Say which finding looked wrong and, if you can share it, a copy of the sheet with the problem (names and account numbers removed) — read the privacy notice first.

Articles

Google, Google Sheets™ and Google Workspace™ are trademarks of Google LLC. Not affiliated with, endorsed by or sponsored by Barclays, HSBC, Lloyds Banking Group, Halifax, Bank of Scotland, Starling Bank, Monzo, Xero Limited, Intuit Inc. or The Sage Group plc. Barclays, HSBC, Lloyds, Halifax, Bank of Scotland, Starling, Monzo, Xero, QuickBooks and Sage are trademarks of their respective owners and are used only to describe compatible file formats. UK Bank CSV Cleaner is not affiliated with or endorsed by Google.