How to Convert a Barclays Statement PDF to Excel
1
Download from BarclaysLog in to Barclays Online Banking → Statements → Select period → Download PDF
2
Upload PDF HereClick above or drag and drop your Barclays PDF statement
3
Download Excel or CSVGet all transactions in a clean spreadsheet — Date, Description, Amount, Balance
Supported Barclays Account Types
Personal Accounts
Barclays Current Account
Barclays Premier Account
Barclays Basic Account
Barclays Student Account
Barclays Instant Access Savings
Barclays Everyday Saver
Barclays Cash ISA
Barclays Joint Account
Business Accounts
Barclays Business Current Account
Barclays Premium Business Account
Barclays Business Savings
Barclays Startup Account
Barclaycard Credit Cards
Barclaycard Avios
Barclaycard Rewards
Barclaycard Platinum
Barclaycard Forward
Barclaycard Initial
Barclaycard Select
Barclays PDF vs Barclays CSV Export — What's the Difference?
Barclays Online Banking offers a CSV export, but it has limitations:
| Feature | Barclays CSV Export | Our PDF Converter |
|---|
| Maximum history | Last 3 months only | Any period — any PDF |
| Older statements | Not available | Upload any old PDF |
| Multiple accounts | One at a time, manually | One PDF at a time |
| Output formats | CSV only | Excel, CSV, QBO, OFX, QIF, JSON |
| Signup required | Yes (Barclays login) | No signup needed |
Common Uses for Barclays Statement Conversion
- UK mortgage application: Most UK lenders require 3 months of Barclays statements — export to Excel for clean review
- Self-assessment tax return: Filter business income and expenses from your Barclays current account for HMRC
- Xero or Sage import: Convert to CSV and upload to Xero Manual Bank Statement or Sage Bank Import
- QuickBooks Desktop: Convert to QBO and import via File → Utilities → Import → Web Connect Files
- Annual spending review: Combine 12 months of Barclays PDFs into one Excel file for annual budget analysis
- Universal Credit application: DWP may request recent bank statements — Excel format is easy to share
How to Download Barclays Statement as PDF
Barclays Online Banking: Log in → Home → Click your account → Statements → Select month → View → Print/Save as PDF
Barclays Mobile App: Tap your account → Statements → Select month → Share icon → Save to Files as PDF
Barclaycard: Log in to Barclaycard online → Statements → Select statement period → Download PDF
Frequently Asked Questions
Does it work with all Barclays account types?
Yes. Barclays Current Account, Savings, Student Account, Premier Account, Basic Account, Business Account, and all Barclaycard credit card statements are supported.
Can I export more than 3 months of Barclays history?
Yes. Barclays Online Banking limits CSV export to the last 3 months. By downloading your PDF statements for any period and uploading them here, you can convert any historical period — months or years.
Does it work with Barclaycard credit card statements?
Yes. Barclaycard statements (Avios, Rewards, Platinum, Forward, Initial) are all fully supported alongside current and savings account statements.
How do I import Barclays data into Xero?
Convert your Barclays PDF to CSV format using this tool. In Xero, go to Accounting → Bank Accounts → Import a Statement → Select your CSV file. Map the date, description, and amount columns when prompted.
Is there a page limit when converting Barclays statements?
No. There is no page limit. You can convert a 1-page monthly statement or a 200-page annual statement — the process is the same and completely free.
What the Conversion Looks Like
Here is a real example of how raw PDF bank statement text is transformed into a clean, structured Excel file:
| Before → After Comparison |
|---|
| Raw PDF (what the bank gives you) | Clean Excel (what you get) |
|---|
| 01 Jun 2026 UPI/CR/466893467/Received from Rajesh Kumar/SBIN0003456 5,000.00 1,23,450.00 Cr |
Date: 2026-06-01
Description: Received from Rajesh Kumar [UPI: rajesh@sbi]
Credit: 5000.00 Balance: 123450.00 |
| 03 Jun 2026 NEFT/DR/SALARY/ACME CORP LTD/REF20260603001 Cr 85,000.00 2,08,450.00 |
Date: 2026-06-03
Description: SALARY/ACME CORP LTD / REF20260603001
Credit: 85000.00 Balance: 208450.00 |
| 07 Jun 2026 POS/AMAZON.IN/DEBIT Dr 3,299.00 2,05,151.00 |
Date: 2026-06-07
Description: POS / AMAZON.IN
Debit: 3299.00 Balance: 205151.00 |
Every column — Date, Description, Debit, Credit, Balance — is extracted and separated automatically. Dates standardised to YYYY-MM-DD. Currency symbols removed. Ready for Excel pivot tables, QuickBooks import, or Tally.
Convert Your Bank Statement Free
No signup required. Works with every bank worldwide.
Start Converting Now