HSBC Statement PDF to CSV, Excel & QBO (UK & US)

HSBC is one of the largest banks in the world, and its statements are awkward to work with in a spreadsheet. Official HSBC statements are PDF only. HSBC UK online banking does offer a CSV or Excel download, but it comes from the transactions list, covers recent activity, and HSBC does not publish how far back it reaches. This guide covers what HSBC lets you export and how to turn the PDF statements into CSV, Excel, or QBO, whether you bank with HSBC UK, HSBC USA, HSBC Premier, or HSBC UK Business Banking.

Can You Download CSV Directly from HSBC?

Partly. HSBC UK says its digital statements download as PDF, and that other formats such as Excel (xls) or CSV come from the transactions list instead. In online banking, choose the account, select Search and filter, set the date range, select Search, then scroll to the bottom of the list and select Download. HSBC USA lets you download transaction history as CSV, OFX, or QFX, and its monthly statements are PDF documents too.

Threads on UK personal finance forums describe customers who needed a full year of data and got far less from the download. Here is why the built-in option falls short for many use cases:

• Recent activity only: The download is built on the transactions list, and HSBC does not publish how far back it reaches. Older history is available as PDF statements, up to 6 years back.
• Online banking only: HSBC documents the CSV and Excel download for online banking. Its mobile app instructions cover viewing and sharing PDF statements.
• Transaction list is not the statement: The download is a list of transactions for the dates you searched. It is not the official statement for a statement period, which HSBC issues as a PDF.
• 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 put the day first, while HSBC USA statements put the month first. The same digits, 04/05, mean 4 May in the UK and April 5 in the US. 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 current account statements list money in and money out in 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 mix purchases, payments, refunds, cash advances, interest charges, and fees. CapyParse tags the transaction type in your export so you can categorise spend without manual rework.

HSBC UK Business Banking and Former Kinetic Accounts

HSBC Kinetic was HSBC UK's app-based business account. It closed on 2 July 2026, and HSBC has been moving Kinetic customers to HSBC UK Business Banking. Business Internet Banking keeps at least 6 years of statements for business current and savings accounts, and it can download transactions in formats for spreadsheet and accounting programs. If you hold Kinetic or Business Banking statements as PDFs, CapyParse converts them and 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 an OFX or QFX 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