Convert Metro Bank statements to Excel or CSV
Metro Bank keeps statements back to account opening under Documents, then Account Statements, which makes it practical to convert years of history in batches. Its CSV export is only a transaction list without opening and closing balances, so for full months use the PDFs. BankConv converts them to Excel, CSV or Google Sheets.
Updated
Download your Metro Bank statement
- 1.Log in to Metro Bank online banking (personal or business). Turn off pop-up blockers first.
- 2.Click the account, then Documents, then Account Statements.
- 3.Select the year, click View for the month you need, and download the PDF.
- 4.Repeat for each month.
Do you need to convert at all?
Metro Bank online banking lets you export a list of transactions to a CSV or PDF file.
The export is a transaction list, not the formatted statement with opening and closing balances. For full monthly statements, download the PDFs from Documents.
Metro Bank export formats: CSV
What to know about Metro Bank PDFs
- Statements go back to account opening
- Metro Bank says you can download PDFs of all your statements since you opened the account, and see transactions as far back as 2015. That makes it practical to convert a full history, but convert a few months from each year first, since older statements may use an older layout.
- Money out and money in are separate
- Debits and credits usually sit in two columns with no minus signs. Keep both, or build one signed amount (money in minus money out) before you import into software that wants a single Amount column.
- Closing an account? Save the history first
- Metro suggests downloading your transaction history from online banking before you close an account. Afterwards it keeps the history for at least 5 years and sends it as a printed copy, which you'd then need to scan.
Metro Bank statements downloaded from online banking are usually text-based PDFs. Because Metro keeps statements back to account opening, they also work well for converting years of history in batches.
How to get Metro Bank transactions as CSV
Which route you take depends on whether you need a quick list or full statements.
- Transaction list: use the export option in online banking to save the transactions as CSV.
- Monthly statements: go to Documents > Account Statements, save the PDFs, upload them to BankConv (up to 10 at a time), and export CSV or Excel.
Accountants and lenders usually want the statements, because they show the opening and closing balance for each period.
What to check after converting
Check each statement against its own balances before you import.
- Balance: the opening balance plus money in minus money out should equal the closing balance.
- Overlap: if you also used the CSV export, remove rows that appear in both files.
- Dates: UK dates are day first, so make sure your software reads 05/09 as 5 September.
For Xero, see importing into Xero. More UK banks are on the UK banks page.
Sources: Metro Bank: Where can I find my statement? · Metro Bank: Online Banking · Metro Bank: Transaction and statement export · Metro Bank: Transaction history for closed accounts
Columns you get
| Date | Description | Money out | Money in | Balance |
|---|---|---|---|---|
| 01 Sep 2026 | Card purchase WAITROSE 0812 LONDON | 27.90 | 1,482.10 | |
| 03 Sep 2026 | Direct debit LONDON BOROUGH COUNCIL TAX | 142.00 | 1,340.10 | |
| 05 Sep 2026 | Faster payment ACME LTD SALARY | 2,310.00 | 3,650.10 | |
| 09 Sep 2026 | Card purchase TFL TRAVEL CHARGE | 6.80 | 3,643.30 |
Sample rows in Metro Bank's layout, fictional data. First 5 pages free to check.
Deleted after 24 hours
Your PDF and its converted files are deleted automatically. Account owners can choose 48 or 72 hours instead.
Read only to extract transactions
Your statement is read (with OCR for scans) to pull out the transaction rows you download.
Encrypted in transit
Uploads and downloads use HTTPS (TLS).
Passwords never stored
The password of a protected PDF is used once to open the file.
No bank login
BankConv works from the PDF you download, never from a connection to your bank.
Metro Bank statement questions
Can I export Metro Bank transactions to CSV?
Yes. Metro Bank online banking can export a list of transactions to CSV or PDF. For complete monthly statements with balances, download the PDFs from Documents and convert them in BankConv.
How far back can I download Metro Bank statements?
Metro says you can download PDFs of all your statements since you opened the account, from the Documents tab in online banking.
Can I get a Metro Bank statement by post instead?
Yes. Metro says you can order one by phone and it takes about 10 working days to arrive, while online downloads are immediate. BankConv also converts scanned paper statements.
Other United Kingdom banks
- Barclays
- HSBC UK
- Lloyds Bank
- NatWest
- Santander UK
- Nationwide
- Halifax
- Monzo