Barclays Bank Statement Converter:
PDF to Excel & CSV

Check what Barclays gives you first

A file straight from your bank will always be more accurate than one reconstructed from a PDF, so it is worth two minutes to check before converting anything. Barclays offers a CSV export from desktop Online Banking, covering recent transactions, over a window Barclays does not publish. If the period you need sits inside that, use it and skip this page.

Barclays current accounts can export transactions as CSV, but only from desktop Online Banking, not the app, and only for recent activity. Barclays does not publish how far back the export reaches, and users report the dates sometimes need repairing before the file imports cleanly. A remortgage asking for statements from three years ago, or a self-assessment covering a closed tax year, is where the PDFs become the only complete record.

Downloading the statement from Barclays

Statements live in the Statements section of Online Banking or the Barclays app, chosen per account, and the online archive runs to five to seven years at the time of writing. Pick the period you need and download the PDF rather than printing to PDF from a screen, because a printed screen loses the transaction table structure the converter reads.

If the account has been closed, or the statement was forwarded to you by someone else, you will not have online banking access at all. That is the most common reason people end up converting a PDF: it is the only copy that exists.

Converting it to Excel or CSV

1. Upload the Barclays PDF to the converter above, up to 10MB. Several months in one file is fine, and so is a scanned PDF. Remove any password from the PDF first, because the converter cannot unlock it.
2. The pages are read, with OCR where the statement is a scan rather than text.
3. Check the transactions on screen against the statement before you download anything.Barclays statements typically carry Date, Description, Amount and Balance.
4. Download an Excel workbook (.xlsx), or a CSV to open in Google Sheets or import into QuickBooks, Xero, FreshBooks or Sage.

Your first conversion runs without an account. A free account adds 7 free pages, and the monthly plans are priced by page count if you are working through years of statements or several clients.

What happens to your Barclays statement

Uploads travel over an encrypted HTTPS connection. There is no long-term file storage: the statement sits on the server only long enough to be read and is deleted 24 hours after upload. Conversion is fully automated, so no member of staff opens it. To read the pages, the converter sends them to Google's Gemini AI. The full privacy policy sets out the detail.

Reading a Barclays statement once it is in columns

Barclays publishes its own list of statement abbreviations, and several differ from other banks: DDR for a Direct Debit rather than DD, STO for a standing order rather than SO, and BBP for a bill payment, alongside BGC for a bank giro credit and REV for a reversal. The abbreviations are only three or four characters and sit inline with the rest of the description, which makes them nearly impossible to total in a PDF and trivial once each is its own filterable value.

Who converts Barclays statements, and why

Barclays covers a very broad UK retail base, so the common jobs are equally broad: self-assessment returns where HMRC wants the year evidenced, rental applications where a letting agent asks for three to six months, and Universal Credit or benefit reviews where an assessor wants to see a specific period. The twelve-statement export limit means anything touching a closed tax year is a PDF job.

Barclays statement converter FAQs