HSBC UK statement PDF to Excel: DD/MM dates and multi-currency
HSBC UK sends statements as PDFs only. If you need the transactions in a spreadsheet for bookkeeping, a tax return, or a mortgage application, the PDF has to be converted. Here is the workflow that handles the UK date format, multi-currency lines, and Premier sub-accounts.
Why this is annoying (the manual way)
Open an HSBC PDF, select a few rows, paste into Excel. Columns drift. The date "05/04/2026" auto-converts to "5 April 2026" on a UK locale and "May 4" on a US one, depending on which colleague opens the file. The IBAN line at the top lands in the data area. Money In and Money Out merge into one blob, and you end up retyping to split debits from credits. For a 12-month set during self-assessment season, an afternoon vanishes.
The 30-second method with Bank2XL
Bank2XL is a Chrome extension. One drag, one click.
- Install Bank2XL from the Chrome Web Store at bank2xl.app
- Download the PDF from HSBC Online Banking or the HSBC UK app
- Click the toolbar icon to open the popup
- Drag the statement onto the drop zone
- Click "Convert to Excel" and download the .xlsx or .csv
Free during beta: 10 statements a day, no signup. A typical HSBC current-account PDF converts in 25 to 45 seconds.
What about HSBC format quirks
HSBC UK statements have a few details that catch US-built tools out:
- Dates are DD/MM/YYYY. A US-built tool reads 03/12/2026 as 12 March instead of 3 December. Bank2XL detects the UK locale from the sort code and IBAN and parses dates correctly.
- Money In and Money Out are separate columns, not a single signed Amount. Bank2XL maps these to debit and credit so the same template works across UK and US output.
- HSBC currency accounts list GBP, USD, EUR, and JPY transactions on the same statement. Each row keeps its original currency in the Currency column.
- The header carries IBAN, SWIFT/BIC, sort code, and account number. Those land in account metadata, not in transaction rows.
- HSBC Premier and Advance bundles can include current account, savings, and a credit card in one PDF. Bank2XL splits these into one sheet per linked account so each balance reconciles on its own.
When to use the alternatives
- Manual copy-paste. Worth it for one statement, painful for a year.
- Adobe Acrobat Pro Export to Excel. Usable for current accounts. The currency-account layout confuses it, and the IBAN block ends up in the data range.
- Template-based converters. Accurate when their HSBC template is current. HSBC tweaked the Premier layout in 2024 and template tools needed weeks to catch up. We work without per-bank rules, so layout changes do not break extraction.
FAQ
Is this secure? My statement has my account number and IBAN. The PDF goes to the extraction backend over HTTPS. We process files in memory, auto-delete within 24 hours, and you can opt out in Settings. Details at /data-retention.html. Account numbers are masked in the output by default, and we do not train AI on your content or share it.
What about a Global Money or currency account PDF? Each row keeps its original currency. A statement with GBP, USD, and EUR transactions comes out with the right currency per line instead of one converted figure.
What if the PDF has linked savings or a credit card? The output workbook gets one sheet per linked account, and each sheet reconciles to its own opening and closing balance.
Get started
Install Bank2XL from the Chrome Web Store at bank2xl.app. Free during beta: 10 statements a day, no signup. Drop an HSBC UK PDF, click Convert, get a clean Excel file with DD/MM dates and Money In/Money Out preserved.
Skip the manual cleanup — try Bank2XL free
Drop a PDF, get a clean Excel back. 10 statements per day during beta, no signup, no credit card.