How to Convert an HSBC Statement PDF to CSV or Excel

HSBC serves 14 million customers in the UK across current accounts, Advance accounts, and savings products. Their PDF statements are well-structured but locked in a format that doesn't play well with spreadsheets or accounting software.

HSBC UK statements use a distinctive date format — DD MMM YYYY (e.g., 03 Jan 2026) — which differs from both the American MM/DD/YYYY and the standard European DD/MM/YYYY. Generic PDF extraction tools often misparse these dates. ConvertStatement has a dedicated HSBC parser that handles this format correctly.

Log in to HSBC UK online banking at hsbc.co.uk or through the HSBC UK Mobile Banking app. Navigate to your account and select "Statements" from the menu.

HSBC provides downloadable PDF statements going back several years. Select the month you need and download. The statement includes your sort code, account number, and all transactions with Paid out, Paid in, and Balance columns.

For HSBC Advance accounts, the statement layout is the same as standard current accounts. Both are supported by ConvertStatement.

Drag your HSBC PDF into the upload zone at convertstatement.com. The parser detects the HSBC-specific layout, including the DD MMM YYYY date format and the Paid out / Paid in column structure.

HSBC statements sometimes include multi-line transaction descriptions (e.g., standing order references, direct debit mandates). These are concatenated into a single description field in the export, so you don't lose any detail.

The preview table shows every transaction before you download. Verify the amounts and dates match your original statement.

ConvertStatement offers four export formats, all included on every plan:

- CSV — The universal format. Opens in Excel, Google Sheets, LibreOffice, or any data tool. Clean columns with no formatting artifacts. - Excel (XLSX) — Native Excel file. Dates are real Excel date values (not text), amounts are numbers, and the file is ready for formulas and pivot tables. - OFX — Open Financial Exchange format for Quicken, Sage, FreeAgent, and other UK-popular accounting tools. - QBO — QuickBooks Web Connect format for importing directly into QuickBooks Desktop or Online.

The OFX and QBO exports automatically set GBP as the currency, so your accounting software categorizes them correctly.

HSBC UK statements have a few characteristics that trip up generic converters:

1. Date format (DD MMM YYYY): "03 Jan 2026" is not the same as DD/MM/YYYY or MM/DD/YYYY. Our parser recognizes month abbreviations (Jan, Feb, Mar...) and converts correctly.

2. Paid out / Paid in columns: Instead of a single Amount column with positive/negative values, HSBC uses two separate columns. The parser combines them into a single amount: negative for paid out, positive for paid in.

3. Transaction types: HSBC codes transactions as DD (Direct Debit), SO (Standing Order), BGC (Bank Giro Credit), etc. These codes are preserved in the description field.

4. Multi-page statements: Transactions continue across pages without repeating headers. The parser follows the continuation seamlessly.

Does this work with HSBC Advance accounts? Yes. HSBC Advance account statements use the same layout as standard current accounts and are fully supported.

What about HSBC Premier or Jade accounts? Premier and Jade statements typically follow the same format as standard HSBC UK current accounts. If you encounter issues, let us know and we'll verify the format.

Can I convert HSBC savings statements? HSBC savings account statements are typically shorter (fewer transactions) but follow the same column format. They convert the same way.

Are GBP amounts handled correctly? Yes. The parser strips the pound sign and correctly interprets UK number formatting (comma thousands separator, dot decimal). Exported amounts are plain numbers ready for any spreadsheet or accounting tool.