Barclays Bank Statement to Excel & CSV Converter
Upload a Barclays PDF statement and get back a clean Excel, CSV or Tally XML file — current account, Premier, Barclaycard or business, all handled the same way.
Drop your large PDF here
Supports statements up to 500 pages and 150MB
5/5nothing's kept afterwards
Excel, CSV, Tally XML
current, Premier, Barclaycard, business
free to try
Built around how Barclays actually lays its statements out
Barclays statements follow the usual UK conventions that catch out a lot of generic converters — dates written DD/MM/YYYY, amounts in GBP, and transaction codes such as BGC (bank giro credit), FPO (faster payment outgoing) and DD (direct debit). Current account statements also carry a standing order summary and, if you've dipped into an arranged overdraft, an interest table — both sat apart from the main list of transactions. Barclaycard statements are their own thing again, with balance transfers and interest charges laid out differently to a current account. None of that gets flattened into one generic template here.
Which Barclays accounts this covers
- Barclays current accounts
- Barclays Premier
- Barclaycard (Platinum, Avios, Forward and balance transfer cards)
- Barclays Business Banking
- Barclays savings accounts and ISAs
How it works
- 1
Get your statement from Barclays
Log into Barclays online banking or the app, open the account you need, and download the PDF for the period in question. Online banking keeps roughly two years' worth on hand — anything older needs to be requested from Barclays directly.
- 2
Upload it here
Drag it in, or upload a batch if you've several months or accounts to get through in one go. Password-protected PDFs are fine too — you'll just be asked for the password when it's needed.
- 3
Pick your format
Excel for a proper workbook, CSV if it's going straight into Xero or Sage, or Tally XML for Tally Prime. Dates stay in DD/MM/YYYY throughout, and debits and credits are kept in separate columns rather than lumped together.
- 4
Check it over and download
The extracted transactions sit next to the original PDF so you can check nothing has slipped through, then the file is yours to download. After that, it's wiped from our end.
Straight into your accounting software
Columns come out already matching what UK bookkeeping software expects, so there's no re-mapping to do once it's exported.
Common questions
How do I convert a Barclays statement to Excel?
Upload the PDF — current account, Premier, Barclaycard or business, it doesn't matter which — and pick Excel, CSV or Tally XML as your output. The layout is read automatically, dates and all, so there's nothing to configure beforehand.
Will it cope with a Barclaycard statement, not just a current account?
Yes. A Barclaycard statement is laid out quite differently from a current account one — balance transfers and interest instead of standing orders — and that gets picked up on its own. You never have to tell it which type of statement you've uploaded.
What happens to my statement once it's converted?
It's deleted. That's the whole point of the Zero-Retention Protocol — your file sits in memory for as long as it takes to read it, then it's gone. Nobody here ever sees your transactions, and nothing is kept on a server afterwards.
Can I get the file ready for Xero, Sage, QuickBooks or FreeAgent?
Yes — the columns come out already matching what UK accounting software expects: date, description, debit, credit, balance. Export as CSV for Xero or Sage, or Excel if you'd rather have a formatted workbook first.
My Barclays statement is older than the 60–90 day CSV window — does that matter?
No, and this is usually why people end up here in the first place. Barclays online banking only lets you download recent transactions as a CSV; anything further back only exists as a PDF. Upload that PDF and it converts exactly the same way, however old it is.
Is Tally XML included, or is that extra?
It's included alongside Excel and CSV, no extra charge. Handy if your books are done through Tally Prime or an outsourced bookkeeping setup that runs on it.
Is this an official Barclays tool?
No — this isn't affiliated with, endorsed by, or connected to Barclays Bank UK PLC in any way. It's an independent converter built to read the statement format Barclays produces, nothing more.
Other UK banks
Barclays is one of several UK banks covered here. If you're dealing with more than one bank — or want to see the full picture for UK statement conversion — head over to the UK bank statement converter hub, which covers HSBC, Lloyds, NatWest, Santander UK and Halifax alongside Barclays.
This tool is independent and is not affiliated with, endorsed by, or connected to Barclays Bank UK PLC. "Barclays" is used here to describe statement compatibility only.
