Log into your HSBC online banking, go to "Documents" or "Statements" section, then download the desired statement as PDF.
Convert HSBC Statement to Excel, CSV, or OFX
Transform your HSBC PDF bank statements into usable Excel, CSV, or OFX files in just a few clicks.
Try it with a HSBC statement
Drop a HSBC 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
HSBCStatement — 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
statement_may_2026.xlsx
DateDescriptionAmountCategory
05/02Salary payment+€2,480.00Salary
05/04Card · Supermarket-€86.30Groceries
05/07Electricity bill-€74.90Utilities
05/15Rent payment-€720.00Housing
1 file selected
page 0
No file handy?
✨ Liked what you see?
About HSBC
HSBC is one of the world's largest banking and financial services organisations, headquartered in London. In the UK, it serves over 14 million customers. HSBC statements feature transactions listed by date with clear payment type indicators, balance columns, and a monthly summary of all credits and debits.
Pro tip — How to download your statements
In HSBC UK Online Banking, go to Statements > View/Save Statements. HSBC provides up to 7 years of PDF statements. Their structured format with payment type codes converts reliably.
HSBC statement format
Here's what a HSBC PDF statement looks like and what matters for extraction.
- Columns
- Date Payment type and details Paid out Paid in Balance
- Date format
- DD/MM/YYYY
- Decimal separator
- period (1,234.56)
- Running balance
- Yes
- Multi-line labels
- Yes
HSBC UK PDF statements use a 'Payment type and details' column that combines a short transaction-type code (e.g. DD for Direct Debit, SO for Standing Order, BP for bill payment, VIS for Visa debit, CR for credit, ATM, TFR) with the merchant or payee detail underneath. The Balance column only prints on the closing line of each day rather than on every single row, and a single transaction's details frequently wrap across two or three lines.
Download your HSBC statement as PDF
- 1 Log in to HSBC UK Online Banking on a desktop browser (the full statement archive is easier to reach than in the app).
- 2 Select the relevant current or savings account from your account list.
- 3 Open the 'Statements' or 'View/Download statements' section for that account.
- 4 Choose the statement period you need — HSBC UK keeps statements going back up to 7 years.
- 5 Download the statement 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 HSBC statement.
- The 'Payment type and details' column packs the type code and the payee into one cell over multiple lines, so naive parsers split a single transaction into several rows.
- Balance is shown only on the last transaction of each day, not per row, so a running balance has to be reconstructed for the intermediate transactions.
- Type codes (DD, SO, BP, VIS, CR, ATM, DR) sit at the start of the details and can be mistaken for part of the merchant name during categorisation.
- Paid out and Paid in are separate columns rather than one signed amount, so debits and credits must be merged correctly to avoid sign errors.
Export formats
CSV Excel (XLSX) OFX
Works with
QuickBooks Xero Sage FreeAgent
How to convert your HSBC statement
01
📤
Download your HSBC statement
Log into your HSBC online banking, download your statement as PDF, then upload it to BankStatementLab.
02
⚙️
Automatic extraction
Our engine analyzes your HSBC statement and automatically extracts all transactions: dates, descriptions, amounts.
03
💾
Export to Excel, CSV, or OFX
Download your structured file and import it into Excel, Google Sheets, or your accounting software.
Why convert your HSBC statements with us?
🏦
HSBC 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 - HSBC Statement Conversion
Related guides
Go further with converting and importing your statements.
How to convert an HSBC PDF statement to Excel or CSV Why HSBC PDF layouts break naive statement parsers Import HSBC statements into accounting software without a bank feed Best Bank Statement Converter Software in 2026 (Compared) Convert a Bank Statement PDF for Xero (CSV, Not PDF) How to Prepare Bank Statements for Your Accountant
Ready to convert your HSBC statements?
Create your account. 5 credits are included on signup, then 5/month. 1 credit = 1 page.
Get Started TLS Encrypted
Data-protection controls
Auto-Delete