Downloading transactions from Barclays, Lloyds, HSBC and other big UK banks
What each bank's own help page says about CSV, Excel and PDF, with the limits you will hit, and what to do when only PDF is offered.
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 searched for "Barclays download transactions CSV" or the same for Lloyds, HSBC, NatWest, Nationwide or Santander, here is what each bank's own help pages say. We checked them on 17 November 2026 and have only used what those pages state. Where a bank's page does not mention CSV, we say so rather than guess. For the quick comparison table see How to export transactions as CSV from your UK bank; Monzo and Starling have their own pages: How to export Monzo transactions as CSV and How to export Starling Bank transactions as CSV.
Barclays
Barclays' help page on printing or saving online statements covers PDF only. In Online Banking it points to Manage accounts, then Statements and documents; in the app, Help on the home page, then Statements. It states no date limits and does not mention CSV. Some third-party help sites describe a Download & export option on the account page with a CSV choice, but that is not on Barclays' pages, so look for it yourself on your account and see what formats are listed. If there is none, use the PDF statements.
Lloyds (and the same-group brands)
Lloyds' download statements page describes PDFs: in the app, select the account, open the three-dot menu and choose Download or print statement; online, choose Statement options on the account page. Online banking statements go back up to 7 years and the app at least ten. The page does not mention CSV or QIF. We have not checked Halifax or Bank of Scotland, so check their own help rather than assuming it matches.
HSBC UK
HSBC is the clearest of the high street banks. Its statements help says that Excel (xls) or CSV downloads are available, but only from your transactions list: in online banking choose the account, use Search and filter, press Search, scroll to the bottom and choose Download, then your format. Statements themselves are PDF, available back up to six years. The page does not say how many rows a download can hold, so check the first and last dates in the file.
NatWest
NatWest's view and search transactions page says that in Online Banking you can search transactions, then export or print them and select the export format, "including Excel and PDF". It does not name CSV. If Excel is all you get, open the sheet and save it as CSV, or check whether your NatWest menu lists CSV. The app's search covers up to 12 months and the page does not mention exporting from it.
Nationwide
For current accounts Nationwide offers midata, described here. It downloads 12 months of transactions but leaves out the most recent 31 days. It is not supported in the Nationwide app, and on an iPhone or iPad you can view the file but not download it, so you will need a computer or an Android device. Nationwide says not to edit the file. Its statements page says credit card statements can be downloaded in a format you choose, current account statements are PDF, and you can view 36 months in the app and internet bank.
Santander
Santander's transaction history page says you can view and download statements from mobile or online banking, but names no file format. We could not find a Santander page that confirms CSV, so we are not quoting a row cap or steps. Check the download options on your account; if only PDF is offered, use that.
Chase UK
Chase UK's statements page says statements can be exported as PDF or CSV. In the app: profile icon, Statements, then Monthly statements, or create a custom statement for up to 90 days. For a year of history that means several files.
Where only PDF is offered
Vartu imports PDF statements and shows every row for you to check before saving, so Barclays, Lloyds and Santander PDF-only routes still work. Expect more checking than with a CSV: look at dates, signs and anything that looks merged. If your bank offers both, choose CSV.
Common limits to expect
- Windows: Chase UK custom statements are limited to 90 days; Nationwide midata excludes the latest 31 days; NatWest's app search covers 12 months.
- Web-only: HSBC, NatWest and Nationwide midata are online-banking routes, not app routes.
- Format names: "Excel" and "midata" may not be the CSV you expect; open the file before importing.
Import the file into Vartu
Open the file from Files or Mail and tap "Import this file?", or go to Settings → Import statements. Pick the date, amount and description columns once; Vartu remembers them per bank, skips rows that overlap earlier files and offers a duplicate review. Statement importing is a Pro feature. Vartu has not been tested against these banks' exact files, which is why you choose the columns yourself. Details: Import your bank statement CSV or PDF into Vartu. If any step on this page is out of date, tell us at Support.
Choosing between Excel, CSV and PDF
If a bank offers Excel only, the file will usually open in Numbers or Excel; saving a copy as CSV (comma separated values) gives you something Vartu can read, though dates sometimes change format when a spreadsheet opens them, so check a few rows. If a bank offers PDF only, importing the PDF directly avoids that conversion. If you have a choice, CSV first, Excel second and PDF third.
A routine that works across banks
- Export one longer range the first time, within whatever limit the bank gives.
- Import it, check the first and last dates and a few rows in the preview, then save.
- Set a few rules for regular merchants.
- Each month, export the previous month only. Overlaps are skipped, so a day too many does no harm.
Where a bank's window is short, as with Chase UK's 90 days, do the first import in several pieces and keep going from there.
If your bank is not on this page
The principle is the same everywhere: find where your bank lets you download transactions or statements, see which formats it lists, and take CSV if offered. Vartu reads any bank's CSV once you choose the columns, so the bank not being listed here does not stop you. Starling and Monzo are covered in their own articles linked at the top, and Revolut and smaller banks usually put the option under account statements in the app.
Joint accounts, business accounts and credit cards
Most of the pages above are written for personal current accounts. Credit cards often have their own statement area and sometimes their own formats (Nationwide's page says credit card statements let you choose a format, for example). Business accounts are different products with their own export tools, often richer than personal ones, and are outside this guide. For a joint account, remember a file contains both holders' spending, so agree where it is kept.
Keep the file safe
A transactions file is a detailed record of your life. Save it to Files rather than leaving it in email, and delete it after importing. Vartu keeps your data in one file on your iPhone with Face ID or passcode lock, with no account and no server holding your records.
You can try Vartu on the App Store: your data stays on your iPhone, and one spending account and one broker account are free.
On a computer?
Scan with your iPhone camera to open Vartu in the App Store.
More guides
- How to export Starling Bank transactions as CSV
- How to export Monzo transactions as CSV
- How to export transactions as CSV from your UK bank
- A pension forecast app for UK savers: no account, no sign-up
Vartu is not financial advice. Forecasts and estimates are arithmetic on your own figures.