Barclays bank statement to CSV
Convert Barclays bank statements from PDF into a clean spreadsheet with dates, descriptions, signed amounts and balances. Free, no signup, and your file is never stored.
Convert a Barclays statement
Drop your Barclays PDF statement here
or click to browse · 10MB max · nothing is stored
About Barclays statements
Barclays statements use the standard UK layout with paid out, paid in and balance columns. The two money columns have to be merged into one signed amount before anything useful happens in a spreadsheet.
How to download your Barclays statement as a PDF
Sign in to Barclays online banking or the app, open the account, choose Statements, and download the PDF.
Always take the statement file the bank issues rather than printing a transaction list from the browser. The issued statement is the document of record, and it converts more reliably than a printed page.
What a Barclays statement looks like
A statement header shows the account and sort code, then a dated table with description, paid out, paid in and balance.
Barclays quirks to watch for
These are the details that break a copy-paste into Excel, and the reason a Barclays statement rarely lands cleanly on the first try:
- Paid out and paid in are separate columns rather than one signed amount.
- Descriptions carry transaction type codes such as DD, SO, BGC and FPI.
- Statement periods often follow a monthly cycle rather than the calendar month.
- UK statements print dates day first, so 03/04 is the third of April. Dates are normalised on export so Excel cannot silently read them as March 4th.
What you get back
Every Barclays conversion returns the same columns, in GBP, so statements from different months and different accounts stack in one spreadsheet without rework:
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-03-04 | CARD PAYMENT TO SUPERMARKET | -64.20 | 2,481.19 |
Check the export before you use it: opening balance plus the sum of the amount column should equal the closing balance printed on your Barclays statement.
Why not just export from Barclays directly?
Use the direct export when it covers the period you need. It rarely does. Direct CSV, OFX and QBO downloads are usually capped at a recent window, while PDF statements stay available for years, and they are the only thing left once an account is closed. Converting the PDF removes the date limit entirely.
Frequently asked questions
+What do the codes in Barclays descriptions mean?
DD is direct debit, SO is standing order, BGC is bank giro credit and FPI or FPO is a faster payment in or out. The codes are preserved in the description column.
+Are amounts exported in pounds?
Yes, sterling amounts are kept as plain numbers so Excel and accounting software read them correctly.
+Is the Barclays statement converter free?
Yes. No signup, no email and no watermark on the output. The only limit is a 10MB file size.
+Do you store my Barclays statement?
No. The PDF is processed in memory to build the CSV and is never written to disk or retained.
+Is this service affiliated with Barclays?
No. This is an independent tool with no connection to Barclays. It reads a PDF you already have and never connects to your account.