If you bank with Barclays and need your statements as a CSV or Excel file — for bookkeeping, a loan application, or expense tracking — you have a few options. Barclays online banking can export transactions directly, and if you only have a PDF statement, you can convert it to a spreadsheet in seconds. This guide covers both paths.
Download a Barclays statement from online banking
Barclays online banking lets you export transaction data for a chosen date range. The exact wording shifts as Barclays updates its interface, but the flow is the same:
- Log in to Barclays online banking and open the account you want.
- Find the download or export option for statements or transactions.
- Choose the date range you need — for reconciliation, match it to a statement period.
- Pick a file format. CSV is the most universally useful; some views also offer OFX, QIF, or PDF.
- Download the file and open it in Excel or Google Sheets.
If you are asked to choose between "statement" and "transactions", transactions give you the raw rows you want for a spreadsheet, while statements reproduce the official document.
Download from the Barclays app
The Barclays app can share or export statements too. Open the account, look for statements or documents, and choose the period you need. The app typically produces a PDF — which is fine for records, but not for a spreadsheet. If the app cannot export CSV, download the PDF and convert it (below).
Which format should you choose?
- CSV — the safest all-round choice. Plain text, one row per transaction, opens anywhere.
- Excel (.xlsx) — best when you want formulas and formatting kept intact.
- OFX / QIF — for importing into accounting software such as Quicken, GnuCash, or older personal-finance tools.
- PDF — the official document, but not directly usable in a spreadsheet.
What if you only have a Barclays PDF statement?
Older statements, archived statements, and paper statements that were scanned often exist only as PDFs. A PDF is great for reading and poor for working with — you cannot sum a column or filter a date range in a PDF viewer.
That is where a converter comes in. Upload the Barclays PDF to our PDF to Excel converter and the AI extracts the account details, summary, and every transaction into a spreadsheet — digital and scanned PDFs both work. It is free with no signup.
Common issues with Barclays statements
- UK date format — Barclays uses DD/MM/YYYY, which can sort incorrectly in a spreadsheet if it is imported as text. Our converter normalizes dates to YYYY-MM-DD so they sort correctly.
- Money in / money out columns — some Barclays exports split debits and credits into separate columns. Our converter merges them into a single signed amount.
- Multiple accounts — if you export several accounts at once, each account's transactions are kept separate.
Frequently asked questions
Can I get a Barclays statement as a CSV file?
Yes. Barclays online banking supports exporting transactions, and CSV is typically one of the available formats. If your statement only exists as a PDF, you can convert it to CSV with a converter instead.
Does the converter work with Barclays credit card statements?
Yes. Barclays credit card statements convert with purchases, payments, and interest as separate rows. See our Barclays statement converter page for details.
Is the conversion free?
Yes. The converter is free with no signup — you can convert one page per day without an account.