How to Download Your Bank Statement as a CSV From the 5 Biggest UK Banks
Find out exactly where to download a CSV bank statement from Barclays, NatWest, HSBC, Lloyds and Santander. Step-by-step instructions for each bank.
You've decided to take control of your finances. Maybe you want to track your spending, build a budget, or finally convert your bank statement to Excel so you can see where your money is actually going. There's just one problem: you can't figure out how to download your transactions in the first place.
You're not alone. Millions of UK bank customers hit this exact wall every year. The download option exists, but every bank buries it somewhere different, and most people give up after spending a significant amount of time clicking through the wrong screens without finding it.
This guide cuts straight through that frustration. We'll walk you through exactly where to find the CSV or OFX export in the five biggest UK banks: Barclays, NatWest, HSBC, Lloyds, and Santander. We'll also explain which file format you actually need, what to do if your bank only gives you a PDF, and the quickest way to turn your downloaded statement into a working budget.
No technical knowledge required. If you can log into your online banking, you can follow these steps.
Why Your Bank Makes This Harder Than It Should Be
Every major UK bank offers a way to export your transactions. The frustrating part is that none of them make it obvious.
Rather than a clearly labelled "Download" button on your main dashboard, the export option is typically buried inside account detail views, statement history pages, or settings menus. You can have a perfectly straightforward budgeting goal in mind and still spend a significant amount of time clicking through the wrong screens before finding it.
Banks do acknowledge this as a real support issue. Santander, for instance, maintains a dedicated Midata page specifically to help customers locate their data export options. But acknowledging the confusion is different from resolving it, and none of the major banks proactively guide you through the process when you first log in.
What most people don't realise is that you have a legal right to this data. The UK's Open Banking framework requires the six largest banking providers, including all five covered in this guide, to make your transaction data accessible. Midata rules reinforce that right further. The regulations exist; awareness of them simply doesn't.
The gap between your legal right and your practical experience is entirely a design problem. Banks meet their regulatory obligations without making the feature easy to find.
This guide closes that gap. If you're also weighing up whether your current bank suits your budgeting needs more broadly, our breakdown of the best UK bank accounts by use case and budgeting fit is worth a look alongside these steps.
CSV, OFX, or PDF: Which Format Do You Actually Need?
Before you click anything, it helps to know what you're actually downloading.
CSV (comma-separated values) is the format to request whenever your bank offers a choice. Open the file and your transactions appear in rows in Excel or Google Sheets, ready to sort, filter, and total up immediately. No conversion needed.
OFX (Open Financial Exchange) is a structured banking format that some banks offer instead of, or alongside, CSV. It holds richer transaction metadata, but you cannot simply double-click it and start working. You need software or a converter to turn it into something readable.
PDF is the default format most banks use for the statements they send or display online. A PDF behaves more like a photo of a document than a data file. To convert a bank statement to Excel from a PDF, you need an OCR-based tool that can read the text and pull out the transaction rows. A straight file-open will not work.
Not every bank offers CSV directly. Some default to OFX, some offer both, and a handful only provide PDF downloads depending on the account type. Knowing this in advance stops you expecting a CSV and hitting a dead end.
If your bank exports OFX or PDF rather than CSV, that is not a blocker. StatementToBudget accepts all three formats, automatically extracts your transactions, and converts them into categorised budget data. The format your bank uses does not determine whether you can build a useful budget from it.
Barclays: How to Export Your Transactions
Barclays does offer an export option from the desktop site; you just need to know where to look.
Go to barclays.co.uk and log in. From the account overview, select the specific account you want to export.
Click "Statement" or "View Statements" inside that account. Look inside the statement view for an export or download option, it may not be visible from the main transaction feed.
Choose your statement period. Then look near the statement header for an "Export" or "Download" link. It is a small link or icon rather than a prominent button, so scan the top of the statement rather than the bottom.
Select your format. Check which formats Barclays offers at the download step; CSV is the most useful for spreadsheet work if available. If you are curious how that file then becomes a working budget, see how it works with Barclays statements.
If you cannot find the export option on mobile, switch to a desktop browser for the full range of options.
NatWest: How to Export Your Transactions
NatWest follows a similar pattern to Barclays, but there's one important difference in where the export option lives. Use a desktop or laptop browser to access the full range of export options.
Steps:
Log in to NatWest Online Banking and click on the account you want to download transactions from. This opens the transaction list view.
Look for 'Export transactions' or a download icon near the top of the transaction list. NatWest's export tends to sit near filtering controls rather than inside a Statements menu.
Select your preferred date range when prompted.
Choose your file format. Select CSV if it is offered as an option. The downloaded file opens directly in Excel, making it a clean, immediate way to convert your bank statement to Excel with no extra steps needed.
If you want to go further than a spreadsheet, see how it works to upload your CSV and get your transactions automatically categorised into a working budget.
HSBC: How to Export Your Transactions
HSBC works a little differently from NatWest. Rather than placing the export option near the transaction list, HSBC routes you through its statements area instead.
Steps to export your HSBC transactions:
Log in to HSBC Online Banking and click directly on the account name you want to export. This opens the transaction history view for that account.
Look for a statements or documents section in the navigation menu. HSBC keeps its export function inside this section, not on the main transaction feed, so this is the key step most people miss.
Once inside that section, select the time period you need. HSBC may offer a machine-readable format alongside PDF, check the download options before confirming.
Choose CSV or the spreadsheet-compatible option when prompted. That gives you a CSV bank statement you can open directly in Excel with no conversion needed. If your download lands as a PDF instead, you can still extract your transactions using the same statement, other formats approach covered elsewhere on StatementToBudget.
If you need older transactions, look within the same section for any archived statements listed separately.
Use a desktop browser rather than the mobile app to access the full range of export options.
Lloyds Bank: How to Export Your Transactions
Lloyds makes the export option more visible than most banks, which is a welcome change after HSBC's navigation.
Log in at lloydsbank.com and select the account you want from your accounts overview. This opens the transaction history directly.
Look above the transaction list for an 'Export' link. Lloyds positions it alongside the date filter and search controls.
Click Export and a popup appears asking for a date range and file format. Select CSV for the most direct result; the downloaded file opens straight in Excel as a readable bank statement with no conversion needed. Note that each export is capped at 90 days and 150 transactions, so high-activity accounts may need two or three sequential downloads to cover a full year.
Lloyds also offers OFX in the same format list, which suits accounting software imports. For personal budgeting in a spreadsheet, CSV is the simpler choice.
Use a desktop browser, not the mobile app. The Lloyds app does not support CSV downloads at all; the export option only appears in full on a computer.
If you are weighing banks partly on how easily you can get your data out, What Comparison Sites Miss: Statement Export Quality covers what the standard review sites overlook on this front.
Santander UK: How to Export Your Transactions
Santander works slightly differently to the other banks in this guide, and it's worth knowing why before you start clicking.
Log in to Santander Online Banking and select the account you want from your accounts summary page. That opens your transaction history, which is where the export option lives.
Santander's download feature sits within its Midata functionality. Midata is a UK regulatory initiative giving customers the right to access and export their own financial data, and Santander has built its export tool around that obligation. In practical terms, it means the option may be labelled or grouped differently to what you've seen in the other banks.
Within your transaction view, look for a 'Download' or 'Export transactions' option near the statement or transaction history area of the page, rather than in a separate settings menu.
Santander's Midata tool allows you to export your transaction history, check the download options for the available file formats, including whether CSV is offered.
If you cannot find the export option within Online Banking, Santander's dedicated support page at santander.co.uk/personal/support/understanding-our-services/midata provides official guidance on accessing your data.
One thing to note: if you also want to use your Santander transactions with accounting software, the process is similar but the format differs. You can read about same statement, other formats to understand your options before downloading.
What to Do When Your Bank Only Gives You a PDF
Even if you followed the steps above perfectly, you may find that older archived statements only download as a PDF. Some bank interfaces also default to PDF for certain account types.
The OCR tools built into generic converters like Adobe Acrobat can struggle with bank statement layouts specifically, misreading column alignments, merging rows, or dropping figures entirely, leaving you with a spreadsheet that needs significant manual correction before it is usable.
StatementToBudget's PDF converter is built specifically for bank statement layouts. You upload your PDF, and the AI-powered OCR identifies the transaction structure automatically, extracts every row, categorises your spending, and presents the results as budget insights. No reformatting, no manual cleanup.
Because it is purpose-built for bank statement layouts rather than general documents, it handles quirks that trip up general-purpose tools, such as multi-line transaction descriptions and varying column orders, without any extra effort on your part.
The Quickest Route From Statement to Budget
Whatever format your bank provides, you now have a clear path forward. The harder part, finding where the export option actually lives, is solved.
The friction across all five banks is navigational, not technical. Once you know the exact menu path for your bank, the download itself is quick. That knowledge is worth keeping: bookmark the export page directly so next month you go straight there rather than hunting through menus again. Making this a monthly habit is what turns a one-off exercise into a genuine budgeting routine.
CSV opens directly in a spreadsheet; if your bank gives you OFX or PDF, StatementToBudget handles the conversion.
Once your file is ready, the final step is straightforward:
Go to StatementToBudget.com
Upload your CSV, OFX, or PDF file
Review your categorised spending insights instantly, at no cost
The gap between a raw statement and a working budget is now just a download and an upload. Five banks, one consistent process, and a clear picture of where your money is going every month.
Conclusion
Getting your bank statement into a usable format should never be the obstacle standing between you and a clearer financial picture. Here is what this guide has shown you:
Every major UK bank offers a transaction export, but finding it requires knowing exactly where to look
The hard work is now done. You have the menu paths, the format guidance, and a reliable fallback for PDFs.
Your next step is simple. Download your latest statement today, upload it to StatementToBudget.com, and see exactly where your money went this month. Clear data leads to better decisions, and better decisions start right here.