UK bank statements to Excel: what each bank actually gives you
Most UK banks export recent transactions as CSV but issue the official statement as PDF only. Which bank does what, and when you actually need a converter.
The UK has some of the most export-friendly online banking anywhere. Before looking for a converter, check whether your bank already gives you what you need - often it does, and this page will have saved you a step.
But there is a distinction that trips people up, and it is the reason converters exist here at all.
Transaction export is not the same as a statement
Almost every UK bank lets you export recent transactions to CSV or Excel from the transaction list. That is not the same thing as your statement.
A statement is the formal document for a period: it carries the opening balance, the closing balance, the account details and the bank's branding. It is what a mortgage lender, an accountant, an auditor or a visa application asks for. Banks almost always issue that as PDF only.
So you can hit two walls even at a CSV-friendly bank:
- The transaction export covers a limited recent window, and you need something older.
- You need the statement itself, with balances - and it only exists as a PDF.
What each bank does
Barclays - transactions export to Excel and CSV from the transaction list, but full statements are available as PDF only.
HSBC UK - has removed CSV and Excel export from most retail online banking screens, leaving a short transaction list download. If you remember exporting from HSBC and cannot find it, you are not imagining it.
NatWest - exports for Excel, CSV or PDF.
Lloyds - formal monthly and quarterly statements as PDF, plus CSV, OFX and QIF export aimed at accounting software.
Monzo and Starling - statements are generated on demand in the app rather than on a monthly cycle. Everything is there from account opening, which makes them the easiest of the lot.
Bank interfaces change. Treat this as a starting point and check your own account.
When you genuinely need a conversion
- The period you need is older than the export window.
- You need the official statement, balances and all, and it is a PDF.
- Someone sent you a PDF - if you do bookkeeping, this is nearly every statement you handle.
- The account is closed, or at a bank you have left.
- You only have paper, a scan, or a photo.
Why the balance check matters
A converted statement is only worth as much as the certainty that no row is missing. A file with a hole in it looks completely normal in a spreadsheet.
So every conversion is checked against the statement's own figures:
opening balance + sum of transactions = closing balance
If that does not hold to the cent, it is flagged and you are not charged. This is also why one statement is converted at a time: the arithmetic only closes inside its own period.
Get the right file
Download the PDF the bank produces, not a screenshot and not a printed page rescanned. The PDF holds the text as text, so the amounts are read exactly as the bank wrote them. Then convert it to Excel, CSV, or a layout ready for QuickBooks or Xero.