How to export statements from Barclays (PDF and CSV)

Barclays gives you two different things people both call a "statement": the official monthly PDF, kept in a documents area for up to seven years, and a separate transaction export that produces spreadsheet-ready files. Which one you want depends on the job — proof for a landlord, lender or visa application needs the PDF; getting numbers into Excel or accounting software needs the export. They live on different screens, cover different date ranges, and people regularly find one while never discovering the other.

The official PDF statement (Online Banking)

1. Log in to Barclays Online Banking.
2. Select Manage accounts, then Statements and documents.
3. Pick the account and the statement period you need.
4. The statement opens as a PDF — use the PDF icon in the toolbar (or the File menu) to save or print it.

The same files are also reachable from the homepage: click your name, then My documents and messages, then My Barclays documents. Barclays keeps up to seven years of statements for open accounts — one of the longer archives among UK banks — so old months are almost always still there.

In the Barclays app

1. Open the Barclays app and go to Help from the home page.
2. Select Statements.
3. Choose the account and month, then save or share the PDF.

The spreadsheet export (CSV, OFX, QIF)

Separately from statements, Barclays Online Banking can export your transaction list in machine-readable formats — accounting guides consistently report CSV, OFX and QIF options, which is broader than most UK banks offer. The export lives on the account's transaction view rather than in the documents area.

The catch is coverage: the export draws from the recent transaction list, whose date window is far shorter than the seven-year PDF archive. For anything beyond the recent months, the PDF statement is the only source — which is exactly when converting a Barclays PDF stops being a convenience and becomes the only route to a spreadsheet.

Three Barclays quirks worth knowing

• Written-out descriptions, not type codes. Barclays statement lines say "Direct Debit to…" and "Card Payment to…" rather than the short DEB/DD/SO codes Lloyds-group banks use. If a tool or template expects a type-code column, Barclays files need different handling. (Our abbreviations glossary covers both styles.)
• Pending lines change. Recent card and contactless payments can sit as pending before posting with their final descriptor, so an export taken mid-month may not match the eventual statement line for line.
• Closed accounts lose history. Access drops from seven years to up to five after closure — worth downloading everything before you switch away, not after.

Getting a clean spreadsheet either way

If the months you need are inside the export window, use the export — an exact file beats any conversion. If they're older, download the PDFs and run them through the Barclays statement converter: it reads the PDF's own text, reconciles every line against the statement's printed balances so you know nothing was dropped, and outputs CSV, Excel, QIF or OFX with every merchant named. For the general background on why PDF conversion goes wrong, this guide covers it.