Bank Statement to Excel

Most ways of getting a statement into Excel end with numbers stored as text: right-aligned dates that will not sort, amounts Excel refuses to add up, a minus sign that is really a hyphen. This page writes a genuine spreadsheet file instead, with the values typed the way Excel expects them.

What lands in the spreadsheet

Four columns when your statement carries a running balance, three when it does not: date, description, amount, and balance. Nothing else is added - no invented categories, no guessed payee names, no blank filler rows.

• Dates are written as text in ISO order, year first, so they sort correctly no matter which country your copy of Excel thinks you are in.
• Amounts are numbers, not text. Money out is negative, money in is positive, so a plain SUM over the column gives you the net change.
• Currency symbols are stripped out of the amount column. A column of numbers is what a spreadsheet can work with; the symbol belongs in the formatting, not the value.
• The balance column is only there if the statement actually printed one. Card statements normally do not.

Why the numbers are checked before you download

When a statement prints a running balance, every row has to add up to the next one. The page walks that chain and shows you the result before you press download - a green line when every step adds up, a plain warning when it does not. It is the difference between a converter that is confident and one that is correct. Where there is no balance column to check against, the page says so rather than implying the numbers were verified.

Opening the file

The download is a real .xlsx workbook, so Excel opens it directly with no import wizard, no delimiter question and no encoding prompt. It also opens in Numbers on a Mac, in LibreOffice, and in Google Sheets through File then Import. If you would rather have a plain text file to feed into something else, take the CSV instead.

Will the dates be recognised as dates?

They are written in year-month-day order, which sorts correctly as text and which Excel converts to real dates with one Text to Columns pass if you need date arithmetic. This is deliberate: writing them in the local order would mean guessing whether your Excel expects month first or day first, and guessing wrong silently turns the third of February into the second of March.

Related

Bank Statement to CSV · Bank Statement to QuickBooks · Bank Statement to Google Sheets