How to Download Barclays Statements as CSV
If Barclays shows a CSV or export-records option for your account, use that native file first. Barclays' official help pages document Online Statements and online-banking records/downloads, while CSV/export availability can vary by account and product. If you only see PDF statements, download the official Barclays PDF and convert it locally.
Start in Barclays Online Banking
Barclays' Online Statements page says to log into Online Banking, go under your profile to My Barclays documents, then select a document to view, download or print. Barclays' Online Banking page also describes downloading records and customising financial reports. Start there rather than from a screenshot or email attachment.
For transaction-style CSV, look for a recent transactions, records, export or download option for the relevant account and date range. If your account offers CSV, download that native Barclays file and use it directly.
- Use Online Banking on desktop first; app statement views are useful for PDFs, but export options vary.
- Choose the account and date range that match the period you need.
- Keep the original Barclays file unchanged until it imports cleanly.
If Barclays only gives you PDF
Barclays' public statement help is clearest about online statements and PDF download/print flows. If you cannot see a CSV/export option, do not invent one: download the official text-based PDF statement and convert the PDF locally with StatementSift.
Drop the PDF into Bank Statement to CSV / QBO Converter, review the balance check, then export CSV or QBO only after the rows look right.
- Use the Barclays PDF from Online Banking or the app, not a phone screenshot.
- Avoid scans where possible; scanned OCR is a fallback and needs row-by-row checking.
- If a row is flagged, fix it before importing into accounting software.
CSV or QBO?
Choose CSV for spreadsheets, Xero/Wave templates, and tools that ask for Date, Description and Amount columns. Choose QBO/OFX when your QuickBooks workflow accepts Web Connect-style bank-import files.
The converter does not connect to Barclays or QuickBooks; it only creates a local file you review and import yourself.
Frequently asked questions
Sometimes Barclays Online Banking or a specific account product may expose records/export options, but Barclays' public help is clearer about online statements, PDFs and downloaded records than a universal CSV path. Use native CSV if your account shows it; otherwise download the official PDF and convert locally.
Use the app for official statement PDFs when available. For CSV or records export, check Online Banking on desktop because export options can vary by account and product.
No. Use a native CSV if available, or the official text-based Barclays PDF. Screenshots and scans are harder to verify and need much more manual checking.
Updated · StatementSift team