How to export transactions as CSV from your UK bank
What each big UK bank says about CSV, where it only offers PDF or Excel, and what to do with the file afterwards.
Some links in this article are referral links: if you sign up through one, Vartu may receive a reward, and sometimes you do too. It costs you nothing extra.
If you want to export bank transactions as CSV from a UK bank, the honest answer is that it depends on the bank, on whether you are in the app or online banking, and sometimes on the account type. This guide goes through the main UK banks using each bank's own help pages (linked below), says plainly where a bank only offers PDF, Excel or a capped window, and then shows what to do with the file once you have it. Everything here was checked against those pages on 17 November 2026. Banks rename menus often, so treat the wording as a pointer to where to look rather than a click-by-click script.
Quick table: who offers what
| Bank | What the bank's own page says | Where |
|---|---|---|
| Monzo | PDF, CSV and QIF, any date range, Pots included | App |
| Starling | Its statements page says you can export transaction history as CSV | App and online; taps not on that page |
| Chase UK | Statements as PDF or CSV; custom statement up to 90 days | App |
| HSBC UK | Excel (xls) or CSV from the transactions list; statements are PDF | Online banking |
| NatWest | Export from Online Banking in formats including Excel and PDF; CSV not named | Online banking only |
| Lloyds | Statements as PDF; the pages we found do not mention CSV | App and online |
| Nationwide | Current accounts: a midata download (format not named); credit cards: pick a format | Internet bank; not the app |
| Barclays | Its statement help pages cover PDF only; CSV is not mentioned | Online banking and app |
| Santander | Statements as PDF; no CSV mentioned on the pages we found | App and online |
Per-bank detail is in Downloading transactions from Barclays, Lloyds, HSBC and other big UK banks. The two banks with the clearest app-based CSV route have their own pages: How to export Monzo transactions as CSV and How to export Starling Bank transactions as CSV.
Banks with CSV in the app: Monzo, Starling and Chase UK
Monzo. Monzo's help page "exporting my transactions" describes the app route: tap the three dots on your card, choose Bank statements, pick the date range and then the file format. PDF, CSV and QIF are offered, and the page says the export covers all your transactions in the app, including Pots.
Starling. Starling's statements page says you can export your transaction history as CSV and that monthly statements can be downloaded in the app. That page does not spell out the taps, so open the statements area of the app or online banking and look for a date range and a CSV option.
Chase UK. Chase's statements and documents page says statements can be exported as a PDF or in CSV format. In the app you go to your profile, then Statements, and you can create a custom statement covering up to 90 days, so a long history means several files.
Banks where the CSV route is online banking only or not clear
HSBC UK. HSBC's statements help says other file formats such as Excel (xls) or CSV are available, but only from your transactions list in online banking: choose the account, use Search and filter, run the search, then use Download at the bottom of the list. Statements themselves download as PDF, and the page says old statements go back up to six years.
NatWest. NatWest's view and search transactions page says that in Online Banking you can search transactions and export them in formats including Excel and PDF. It does not name CSV, and it does not describe exporting from the mobile app, whose search covers up to 12 months.
Nationwide. Nationwide's midata page covers current accounts: it downloads 12 months of transactions but leaves out the most recent 31 days, and it is not available in the Nationwide app. On an iPhone you can view the file but not download it. Its statements page says past credit card statements can be downloaded in a format you choose, and that current account statements are PDF.
Lloyds. Lloyds' download statements page talks about PDF statements, from the app (three-dot menu, then Download or print statement) or from Statement options online. It does not mention CSV. If you need rows, use the PDF route below.
Barclays and Santander. Barclays' print or save your online statement page covers PDF only, and Santander's transaction history page says you can view and download statements from mobile or online banking without naming a format. Some third-party guides describe CSV downloads at both banks; we could not confirm that on the banks' own pages, so we are not listing steps for it. Look for a Download or Export option next to your transaction list and see what formats it offers.
Common problems
- Short windows. Chase UK custom statements stop at 90 days. Nationwide midata skips the latest 31 days. NatWest's app search stops at 12 months.
- Different file for different jobs. A statement is usually a PDF. A transactions export is usually what you want for budgeting.
- Dates and signs. Some banks give one signed amount column, others separate money in and money out. You will see this when you choose columns.
- Joint accounts. A file can contain details of both holders, so be careful where you save it.
- Sensitive file. It lists everywhere you spend. Delete it from Downloads once imported.
When a bank only gives you PDF
Vartu reads PDF statements too and shows every extracted row for you to check before anything is saved, so a PDF-only bank is not a dead end. Tell it which columns are which if a PDF is awkward, and review the rows before saving. This is slower than a clean CSV, so if your bank offers one, use it.
Import the file into Vartu once
Vartu reads CSV files from any bank. You choose which columns hold the date, amount and description once, and the choice is remembered for that bank next time. Open the file from Files or Mail and tap "Import this file?", or go to Settings → Import statements. Rows that overlap with an earlier file are not added twice, so downloading the same month again is safe. Statement importing is a Pro feature. Vartu has tested templates only for Monzo (CSV and PDF); for every other bank you pick the columns yourself. More detail is in Import your bank statement CSV or PDF into Vartu.
If your account is in Apple Wallet, there is also a no-file route: Vartu can receive settled transactions through Apple Wallet (a Pro feature, UK and US only). If you would rather not connect a bank at all, see A budgeting app that never connects to your bank.
If a bank changes its menus and a step above is out of date, tell us at Support and we will update this page. Want to try it? Vartu on the App Store keeps your data on your iPhone, with one spending account and one broker account free; Pro adds statement importing and unlimited accounts.
On a computer?
Scan with your iPhone camera to open Vartu in the App Store.
More guides
- A pension forecast app for UK savers: no account, no sign-up
- Track your investments on iPhone, in your own currency
- A budgeting app that never connects to your bank
- Import your bank statement CSV or PDF into Vartu
Vartu is not financial advice. Forecasts and estimates are arithmetic on your own figures.