Convert Barclays Statement to Excel, CSV, or OFX

Q: How do I download my Barclays statement as PDF?

Log into your Barclays online banking, go to "Documents" or "Statements" section, then download the desired statement as PDF.

Q: Can I convert every Barclays statement layout?

Barclays layouts can vary by account type, statement period, and document quality. Process a representative file first, then compare dates, signs, row count, and balances with the source before using the export downstream.

Q: Is my Barclays data secure?

Transfers are encrypted with TLS 1.3. Source PDFs are deleted after processing. Exception: source PDFs for multi-table extractions by signed-in users may be retained for up to 7 days for quality review. We do not ask for or store your banking credentials.

Q: Can I convert multiple Barclays statements at once?

Yes. Signed-in uploads support up to 15 files and 100 pages in total, with a 50 MB limit per file. Each standard page uses 1 credit (5 on signup, then 5/month).

Q: Does Barclays show 'Money in' and 'Money out' as separate columns on the PDF?

Yes. Barclays statements present 'Money out' and 'Money in' as two separate columns plus a running Balance. When converting to CSV or Excel you can keep them as two columns or merge them into one signed amount, depending on what your accounting software expects on import.

Q: Can I convert a statement exported from the Barclays app?

Yes. The PDF you download from the Barclays app has the same layout as the one from online banking — Date, Description, Money out, Money in and Balance — so it converts to CSV or Excel the same way. For long date ranges or many months, downloading from the desktop online banking site is often quicker.

Q: Why is the date missing on some Barclays transaction rows?

Barclays prints the date once for a block of transactions that share the same day, so the rows beneath it look blank. A proper converter carries the date down to every transaction in that day's block so each row in your spreadsheet has a complete date.

Transform your Barclays PDF bank statements into usable Excel, CSV, or OFX files in just a few clicks.

Get Started

Try it with a Barclays statement

Drop a Barclays PDF statement and watch the extraction happen live. Instant preview, no signup required.

Data-protection controls
Export Excel/CSV/OFX
Secure data

Drag and drop your PDF files here, or click to select

1 file · 100 pages max · 2-page preview

Result preview

PDF · Before

BarclaysStatement — May 2026

05/02Salary payment+2,480.00

05/04Card · Supermarket-86.30

05/07Electricity bill-74.90

05/09CB Amazon-39.99

05/15Rent payment-720.00

Hours of data entrydone in seconds

Excel · After

DateDescriptionAmountCategory

05/02Salary payment+€2,480.00Salary

05/04Card · Supermarket-€86.30Groceries

05/07Electricity bill-€74.90Utilities

05/15Rent payment-€720.00Housing

No file handy?

Convert Barclays statements to Excel Upload a PDF statement and export the extracted table as XLSX. Convert Barclays statements to CSV Create a clean CSV for accounting imports, analysis, or reconciliation. Browse all supported bank guides Find guides for banks in your country and other supported regions.

About Barclays

Barclays is a British multinational bank with over 300 years of history, serving millions of customers in the UK. Their PDF bank statements present transactions chronologically with columns for date, payment type, description, money in, money out, and running balance.

Pro tip — How to download your statements

On the Barclays app or online banking, go to Statements & Documents. Barclays' clean tabular format with 'Money in' and 'Money out' columns is ideal for spreadsheet conversion.

Barclays statement format

Here's what a Barclays PDF statement looks like and what matters for extraction.

Columns: Date Description Money out Money in Balance
Date format: DD/MM/YYYY
Decimal separator: period (1,234.56)
Running balance: Yes
Multi-line labels: Yes

Barclays PDF statements use clear 'Money out' and 'Money in' columns with a running Balance on the right. The Description column carries the payment method or scheme on its own line (for example 'Direct Debit', 'Card Payment', 'Faster Payment', 'Giro') followed by the payee, so a single transaction often spans two lines. Statements typically group transactions under each date and show the start and end balance for the period.

Download your Barclays statement as PDF

1 Open the Barclays app or log in to Barclays Online Banking on a desktop browser.
2 Select the current or savings account you want a statement for.
3 Go to 'Statements & Documents' (in the app this is under the account's documents area).
4 Pick the statement period or month you need.
5 Download or save it as a PDF, then upload that PDF to convert it to CSV or Excel.

Extraction pitfalls to watch

Format quirks to know before converting a Barclays statement.

The payment method label ('Direct Debit', 'Card Payment', 'Faster Payment') sits on a separate line above the payee, so the description must be reassembled to avoid orphaned rows.
'Money out' and 'Money in' are two distinct columns, so they need to be combined into a single signed amount without flipping the sign of returns or reversals.
Date is often printed only once per group of same-day transactions, leaving following rows with a blank date that must be carried down.
Pending or reserved card transactions may appear differently from settled ones, which can cause duplicates if a later statement is converted over the same window.

Export formats

CSV Excel (XLSX) OFX

Works with

QuickBooks Xero FreeAgent Sage

How to convert your Barclays statement

📤

Download your Barclays statement

Log into your Barclays online banking, download your statement as PDF, then upload it to BankStatementLab.

⚙️

Automatic extraction

Our engine analyzes your Barclays statement and automatically extracts all transactions: dates, descriptions, amounts.

💾

Export to Excel, CSV, or OFX

Download your structured file and import it into Excel, Google Sheets, or your accounting software.

Why convert your Barclays statements with us?

🏦

Barclays statement guidance

Use the bank-specific format, download, date, and column notes on this page before reviewing the extracted rows.

🎁

5 credits included

5 credits on signup, then 5/month. No credit card required to sign up.

🔒

Secure and confidential

Source PDFs are deleted after processing. Exception: source PDFs for multi-table extractions by signed-in users may be retained for up to 7 days for quality review. Transfers are encrypted with TLS 1.3.

⚡

Reviewable exports

Check the extracted table against the source statement before exporting to Excel, CSV, or a supported OFX workflow.

FAQ - Barclays Statement Conversion

How do I download my Barclays statement as PDF?

Can I convert every Barclays statement layout?

Is my Barclays data secure?

Can I convert multiple Barclays statements at once?

Does Barclays show 'Money in' and 'Money out' as separate columns on the PDF?

Can I convert a statement exported from the Barclays app?

Why is the date missing on some Barclays transaction rows?

Related guides

Go further with converting and importing your statements.

Convert a Barclays PDF statement to Excel Import Barclays statements when there is no bank feed Best Bank Statement Converter Software in 2026 (Compared) How to Categorize Bank Transactions Automatically: From PDF to Sorted Spreadsheet Convert a Bank Statement PDF for Xero (CSV, Not PDF)

Pricing & credits 5 credits included to start. 1 credit = 1 page. Accounting integrations QuickBooks, Xero, Sage and more.

Ready to convert your Barclays statements?

Create your account. 5 credits are included on signup, then 5/month. 1 credit = 1 page.