AppGarden UK Bank CSV Cleaner logo AppGarden

UK Bank CSV Cleaner

Open a UK bank CSV in Excel™ without Excel™ rewriting your dates and amounts

By Paul Kemp · Published

You download a statement as CSV and double-click it. Excel™ opens it and quietly decides what each column is. Dates may be read the wrong way round, amounts with pound signs and commas may become text, and long reference numbers may lose digits. Once it has happened, the original text is gone.

Why a double-click is risky

Import it as text

These steps apply to Excel™ in Microsoft 365.

  1. Open a blank workbook and choose Data → From Text/CSV.
  2. Pick the file. In the preview, set Data Type Detection to Do not detect data types, so nothing is guessed.
  3. Choose Transform Data if you want to review the columns, then load the data.
  4. Everything arrives as text, exactly as the bank wrote it.
  5. Convert each column deliberately: dates with a day-first conversion you have checked, amounts after removing symbols and separators.
  6. Check a few dates against the statement.

If a date column has no year, or two-digit years, convert only after you decide what the year should be.

Let the pane read the text

UK Bank CSV Cleaner reads a bank export already in the workbook and explains each finding: dates stored as text and which way round they read (BK-07), amounts stored as text (BK-09), and more. It never rewrites your original sheet when it converts; it lays the result out on a new one. The scan and explanations are free, and the workbook is not uploaded. No bank's layout is confirmed against a real export yet, so layout-dependent findings explain rather than rewrite.

See UK Bank CSV Cleaner for Excel™

Microsoft, Excel and Microsoft 365 are trademarks of the Microsoft group of companies. UK Bank CSV Cleaner is not affiliated with or endorsed by Microsoft, any bank or any accounting software supplier.