How to Convert an HSBC PDF Bank Statement to CSV or Excel
HSBC provides statements as PDF files. Here's how to convert them into clean, structured CSV that opens straight in Excel, for free, in a few seconds.
The Problem With HSBC PDF Statements
HSBC's online banking lets you download statements as PDFs. That's fine for reading — but useless if you need the data in your accounting software, a spreadsheet, or a reconciliation tool.
Copy-pasting from a PDF into Excel produces garbled formatting. Dates end up in the wrong columns, amounts lose their negative signs, and multi-line descriptions merge into nonsense. For a three-month statement with 200+ transactions, manual entry isn't an option.
Quick answer: Use MatchIQ's free PDF converter. Upload your HSBC PDF and download clean CSV, which opens directly in Excel. Your first statement of up to 10 pages converts free on a new account.
How to Convert Your HSBC Statement (4 Steps)
- Download the statement from HSBC
Sign in to HSBC online banking and download the PDF statement for each period you need. One PDF per statement period. - Create a free account
Register from the converter page, then open MatchIQ and open the PDF converter inside it. There is no bank to pick from a list — the extraction reads whatever layout is in front of it, which is why statements from banks we have never seen convert just as well. - Upload your PDF
Drag and drop or click to browse. The file is uploaded over an encrypted connection and read on our servers, which is what lets scans and photos work as well as native PDFs. - Download your CSV file
Review the extracted transactions on screen, then download the CSV. It imports into accounting software and opens directly in Excel or Google Sheets for analysis.
Privacy note: Your statement is uploaded over an encrypted connection and read on our servers rather than in the browser. That is a deliberate trade: it is what allows scanned and photographed statements to convert, not just native PDFs.
What the Converter Extracts
The HSBC parser extracts these fields from your PDF statement:
- Date — transaction date in a clean, sortable format
- Description — payee name and transaction reference
- Type — payment type (DD, FPI, BP, etc.)
- Amount — correctly signed (negative for debits, positive for credits)
- Balance — running balance where available
Multi-line descriptions are merged correctly. Amounts with commas and currency symbols are normalised. Dates are parsed into a consistent format regardless of which HSBC statement layout you have.
Can I Download HSBC Statements as CSV Directly?
HSBC's statements themselves are PDF only. Online banking does let you download your recent transactions list in other formats, such as CSV, but only for a limited window, and that download is not the statement itself. Business banking export tools have similar limits on how far back they go.
If you need structured data from HSBC statements — whether for bookkeeping, reconciliation, tax filing, or analysis — converting the PDF is typically the most practical route.
Alternative: HSBC Open Banking
HSBC supports Open Banking, which means you can connect your account to third-party tools that pull transaction data via API. However, how much history you can pull depends on the bank and the app, and connections need renewing from time to time. For historical statements or a full year's data, PDF conversion remains the most reliable option.
Common HSBC Statement Formats
HSBC uses several statement layouts depending on account type and when the statement was generated:
- HSBC UK Personal — standard layout with date, description, money out, money in, balance columns
- HSBC UK Business — similar layout with additional reference fields
- HSBC Premier — premium account statements with slightly different formatting
- HSBC Credit Card — transaction date, posting date, description, amount format
The converter handles all common HSBC UK formats. If you encounter a statement format that isn't parsed correctly, the tool falls back to a generic PDF parser that works with any bank.
What to Do With Your CSV Data
Once you have clean CSV data from your HSBC statement, you can:
- Import into accounting software — Xero, QuickBooks, Sage, FreeAgent, and Pandle all accept CSV bank imports
- Reconcile in MatchIQ: upload it alongside your accounting data and MatchIQ matches it automatically, showing what is matched, missing and extra
- Analyse in Excel — pivot tables, spending analysis, cash flow tracking
- Code in CodeIQ — if you're a bookkeeper, CodeIQ can automatically code transactions to your chart of accounts, classify VAT, and post back to your platform
- File with HMRC — structured data for tax return preparation or MTD submissions
Convert Your HSBC Statement Now
Fast, accurate, and checked on screen before you download. Your first statement of up to 10 pages converts free on a new account.
Convert your PDF now for freeFrequently Asked Questions
HSBC statements are PDF only. Online banking lets you export recent transactions from your transactions list (for example as CSV), but only for a limited window. For statements, upload the PDF to MatchIQ’s free PDF to CSV converter and it extracts clean, structured data automatically.
Use the free PDF converter at reconcileiq.com/bank-statement-converter. Upload your HSBC PDF and download the extracted data as CSV, which opens directly in Excel.
Your first statement of up to 10 pages converts free on a new account. After that it uses 2 credits per transaction (minimum 10 per file), and the cost is shown before anything is processed. It handles HSBC personal and business account statements.
Yes. The converter handles both HSBC personal and HSBC business account PDF statements, as well as HSBC Premier and credit card statements.