Convert Barclays Statement to CSV
Upload a Barclays statement PDF and convert it into a structured CSV with transaction date, description, credits, debits, and balance fields. Works with personal, business, and Barclaycard statements.
Barclays CSV output columns
What's unusual about Barclays statements
- Transaction type codes (
DD,SO,FPI/FPO,CPT,BGC) appear as a narrow column — these are preserved intransaction_type. - Business statements use a slightly different header layout but the same transaction code vocabulary.
- Barclaycard credit card statements are grouped by billing period rather than calendar month, which is preserved in the
datefield.
Need Excel instead of CSV? Convert PDF bank statement to Excel.
How to download your Barclays statement PDF
- Sign in to Barclays Online Banking or the Barclays app.
- Select the account you want a statement for.
- Choose Statements and pick the period you need.
- Download the statement as a PDF (not a screenshot or printed copy — the original PDF has the best OCR accuracy).
- Upload the PDF to StatementCSV and export as CSV or Excel.
Frequently asked questions
How do I download my Barclays statement as a PDF?
Sign in to Barclays Online Banking or the Barclays app, open the account you want a statement for, select Statements, choose the period, and download the statement as a PDF. The original PDF from Barclays converts more accurately than a printed-and-scanned copy.
Which Barclays account types does StatementCSV support?
Personal current accounts, savings, Barclaycard, and Barclays business current accounts are all supported. Layouts differ between personal and business statements but both extract cleanly.
Does the CSV keep Barclays transaction codes like DD, SO, and FPI?
Yes. The transaction_type field preserves whether a row is a direct debit (DD), standing order (SO), faster payment (FPI/FPO), card purchase (CPT), or bank giro credit (BGC), so you can filter by type in your spreadsheet.
Will opening and closing balance rows appear as transactions?
No. Opening balance, closing balance, and any "brought forward" or "carried forward" rows are excluded from the transaction output so your CSV contains only real movements.
Use this page when you need to
- Prepare Barclays data for accountant handoff
- Import transactions into bookkeeping systems
- Audit and reconcile monthly statement activity
- Consolidate Barclays personal and business accounts into a single spreadsheet
Convert statements from other UK banks
Dedicated converters for the most common UK bank statement formats.