HSBC UK Killed Its CSV Download. Here's How to Get It Back.

HSBC is one of the largest banks in the world, with around 39 million customers across the UK, United States, Hong Kong, and dozens of other markets. Its statements are also among the most frustrating to work with in a spreadsheet, because HSBC has quietly narrowed its CSV and Excel export options over the last few years and pushed customers toward PDF-only statements. This guide walks through every reliable method for getting HSBC transaction data into CSV, Excel, or QBO, whether you bank with HSBC UK, HSBC USA, HSBC Premier, or HSBC Kinetic.

Can You Download CSV Directly from HSBC?

Not really, and this is the single biggest frustration HSBC customers report. Over the last few years HSBC UK has removed the CSV and Excel export option from most retail online banking screens, and what remains is a short transaction list download rather than a structured statement export. HSBC USA offers a slightly different experience with Quicken (QFX) and QuickBooks (QBO) download options, but monthly statements themselves are still PDF documents.

If you search UK personal finance communities and forums for HSBC CSV export, you will see the same complaints repeated by accountants, landlords, and small business owners who used to reconcile transactions in Excel in a few minutes and now spend half an hour rekeying data from a PDF. Here is why the built-in options fall short for most use cases:

• Short rolling window: HSBC UK retail banking typically exposes a transaction list covering only around six weeks at a time. Anything older is only available as a PDF statement.
• No true CSV on many account types: UK retail customers have repeatedly flagged on community forums that HSBC removed the "download as CSV or Excel" option from standard current accounts, leaving only PDF e-statements for historical data.
• Transaction list is not the statement: Even where a download exists, it reflects a live activity feed rather than the official monthly statement, so running balances, categorisation, and interest postings can differ from what your accountant actually needs.
• No scanned paper statement support: If you have older paper statements that you have scanned, HSBC's online banking cannot help you extract the data at all.

For a full year of HSBC history, a self-assessment tax return, a mortgage application, or a clean accounting export, you will almost always need to work from the PDF statements themselves. That is where a PDF-to-CSV converter saves real time.

HSBC Statement Formats and Quirks

HSBC statements are not one format - they vary by region and product. Understanding the differences before you convert makes the output dramatically cleaner.

The UK versus US format trap: The biggest single mistake people make when working with HSBC statements is assuming the date format. UK statements use a day-first format (for example, 05 Apr 26 means the fifth of April), while HSBC USA statements use a month-first format (04/05/2026 means April the fifth). If you convert and import the wrong way around, your accounting software will silently shuffle transactions into the wrong months. CapyParse detects the correct region automatically based on the statement layout and outputs an ISO date in the CSV so your import tool cannot misinterpret it.

Money in and Money out columns: HSBC UK personal statements split debits and credits across two separate columns rather than using a single signed amount. If you need a single signed column for QuickBooks or a pivot table, CapyParse exports both the original two-column layout and a normalised amount column in the same file.

Convert HSBC PDF to CSV with CapyParse (Step-by-Step)

Here is how to turn any HSBC PDF statement, from any region or account type, into a clean CSV, Excel, or QBO file in under a minute.

HSBC Credit Card and Business Accounts

HSBC runs several distinct product lines, and each one has its own statement quirks. CapyParse handles all of them.

HSBC Credit Cards

HSBC credit card statements, including HSBC Premier Mastercard, HSBC Rewards, and HSBC Balance Transfer cards, group transactions into clearly labelled sections: purchases, payments, refunds, cash advances, interest charges, and fees. CapyParse recognises each section and tags the transaction type in your export so you can categorise spend without manual rework. Foreign currency transactions are preserved alongside their sterling or dollar equivalent.

HSBC Kinetic and Business Banking

HSBC Kinetic is HSBC UK's app-based business account for sole traders and small limited companies, and HSBC Business Banking covers larger SMEs. Both produce monthly PDF statements with the familiar Money in / Money out layout, and business statements often include direct debit and standing order references that are critical for bookkeeping. CapyParse preserves the full narrative field so your Xero or QuickBooks import keeps merchant names, reference numbers, and transaction notes intact.

If your business statement includes cheque images or paying-in book thumbnails, CapyParse ignores the images and extracts only the transaction data: cheque number, date, payee, and amount.

Import Into QuickBooks, Excel, or Google Sheets

QuickBooks

Export your HSBC statement as a QBO file from CapyParse and import it directly into QuickBooks via Banking > Upload transactions. The QBO format skips CSV column mapping entirely, which is particularly useful for UK users who would otherwise have to juggle Money in and Money out columns manually. For a full walkthrough, see our guide on importing bank statement CSVs into QuickBooks.

Excel and Google Sheets

The CSV export opens directly in Excel or Google Sheets. All transaction fields - date, description, Money in, Money out, running balance, and a normalised signed amount - appear in separate columns, ready for sorting, filtering, pivot tables, and VLOOKUP-style reconciliation against a supplier list. The Excel (.xlsx) export preserves a second sheet with a running balance check if you prefer native spreadsheet formatting.

Already have a QBO or OFX file from HSBC USA? See our QBO to CSV conversion guide to flatten it into a spreadsheet.

Tips for HSBC Conversions

Frequently Asked Questions

Related Articles