How to Convert HSBC Bank Statements to CSV (2026)

HSBC is one of the UK's largest banks, but its approach to statement exports has frustrated customers and accountants for years. Official monthly statements come only as PDFs. There is a limited CSV-style export for recent transactions, but it doesn't replace a proper statement and isn't available through the mobile app. If you need your HSBC data in a spreadsheet — for bookkeeping, tax prep, or financial analysis — this guide covers every practical option.

What HSBC Offers Natively

HSBC UK provides two main ways to access your transaction data: formal PDF statements and a transaction list export.

PDF Statements

HSBC stores up to six years of monthly statements in online banking. To download them:

1. Log into HSBC Online Banking
2. Navigate to Statements using the quick links
3. Select your account from the dropdown
4. Choose Regular Statement as the statement type
5. Select the year, then click the specific month
6. The PDF will download automatically

These are your official bank statements — the documents HMRC, mortgage lenders, and visa offices recognise. However, they're locked in PDF format and can't be directly imported into accounting software.

Transaction List Export (Limited CSV)

For recent transactions (not full monthly statements), HSBC offers a download feature through desktop online banking:

1. Log into HSBC Online Banking on a desktop browser
2. Go to your account overview and select the account
3. Navigate to the Transactions section
4. Look for a Download or Export button
5. Choose your date range and select Excel or CSV as the format
6. Click Download

This export is useful for recent activity, but it has significant limitations. It only covers short transaction periods — not full statement histories. It's not available through the HSBC mobile app. And the file may require formatting cleanup before it imports cleanly into accounting software, particularly around date formats (some HSBC statements don't include the year in date columns).

Business Banking (HSBCnet)

HSBC's business platform, HSBCnet, offers more robust export options including CSV, Excel, BAI2, and SWIFT MT940 formats. If you have a business account, the desktop platform's reporting tools are substantially more capable than the personal banking interface.

The Fastest Method: Convert PDFs with BankToFile

For most HSBC personal banking customers, the most reliable path to a clean CSV is converting the PDF statement you already have.

BankToFile handles HSBC UK PDF statements and extracts every transaction into properly structured CSV or Excel files:

1. Download your statement PDF from HSBC's online banking (Statements section — available for up to 6 years)
2. Upload to BankToFile — works in your browser, no installation needed
3. Choose CSV or Excel as your output
4. Download your file — dates, descriptions, and amounts in clean, separate columns

This is particularly valuable for HSBC customers because the bank's PDF statements are the most complete record available, covering full monthly periods with opening and closing balances. Converting them gives you the best of both worlds: the completeness of the official statement and the flexibility of a spreadsheet.

The Missing Year Problem

One of the most common issues with HSBC statement data is that some PDF formats don't include the year in their date columns — you'll see "15 Jan" rather than "15 Jan 2026." This creates problems when importing into accounting software because the system can't determine which year a transaction belongs to.

If you're adding the year manually in a spreadsheet, use the statement's printed date range (shown at the top of each page) to determine the correct year. For transactions spanning December to January, pay attention to which side of the year boundary each transaction falls on.

BankToFile handles this automatically by using the statement metadata to assign the correct year to every transaction, which saves a tedious manual step.

Importing into Accounting Software

With a properly formatted CSV, importing into your accounting tool is straightforward.

Xero: Accounting > Bank Accounts > Import a Statement. Map columns on first import. Xero saves your settings.

QuickBooks: Banking > Upload transactions. QuickBooks previews data before committing.

FreeAgent: Banking > Bank Accounts > Import. Guided column mapping on first use.

Sage: Use the bank statement import feature. Sage handles custom column mapping for non-standard layouts.

If you're using HSBC's native transaction export, check that dates include the full year before importing. Missing year data will cause the import to fail or assign transactions to the wrong period.

Tips for HSBC Customers

Download from desktop, not mobile. HSBC's CSV/Excel export is only available through desktop online banking. The mobile app only offers PDF statement access.

Use the 6-year statement archive. HSBC stores statements going back six years in online banking. If you need historical data for a tax enquiry or financial review, the PDFs are there — and BankToFile can convert them regardless of age.

Watch for the missing year in dates. Always verify that your CSV includes full dates (day, month, and year) before importing into accounting software. If the year is missing, add it based on the statement period shown on the PDF.

Align to the UK tax year. Download statements covering 6 April to 5 April for self-assessment purposes. You may need to download April and March as individual months and combine them with the intervening months.

Keep original PDFs. HSBC's PDF statements are your official records. HMRC requires you to retain financial records for at least five years after the relevant tax year — the six-year online archive covers this nicely.

Common Issues and Fixes

No export option visible. Make sure you're using desktop online banking, not the mobile app. The export/download button appears in the transactions view, not the statements section.

Dates missing the year. Add the year manually based on the statement period, or use BankToFile to convert the PDF — it handles year assignment automatically.

File won't import into accounting software. Check the date format and column structure. HSBC exports sometimes need the date column reformatted to DD/MM/YYYY or YYYY-MM-DD before your accounting platform will accept them.

Amounts showing as text. Select the amount column, go to Data > Text to Columns in Excel, choose Delimited, and reparse to force numeric values.

Statement not available online. If your account is older or has been migrated between HSBC platforms, some historical statements may not appear in online banking. Contact HSBC directly to request archived statements.

Conclusion

HSBC's statement export situation is more limited than most customers expect from such a large bank. PDF-only monthly statements, a restricted CSV export for recent transactions, and the missing-year date issue all create friction for anyone who needs their data in a spreadsheet.

The most reliable approach is to download the PDF statements — which are comprehensive and available for six years — and convert them. Try BankToFile's free converter to turn your HSBC PDFs into clean, accounting-ready CSV files in seconds.