How to Convert HSBC Bank Statements to CSV or Excel

Start with the right HSBC statement file

Use a statement PDF, not a screenshot

Use the original PDF downloaded from HSBC online banking, the HSBC app, or the official statement area whenever possible. Original PDFs often preserve cleaner text and table structure than screenshots or phone photos. If the file is password-protected, use only the PDF open password. Keep online banking passwords, OTPs, card PINs, and account credentials inside HSBC's official login flow.

Confirm the account and period

Before uploading, check the account suffix, currency, statement period, page count, opening balance, and closing balance. HSBC statements can include summaries, transaction tables, messages, and disclosure text. Build the converted CSV or Excel file around the transaction rows and keep the other statement details for validation.

How to convert an HSBC statement PDF

1. Upload the HSBC statement PDF. Add the document open password if the file is encrypted.
2. Preview the extracted rows. Check that each transaction page produced rows and that summaries or notes were not mixed in.
3. Review transaction fields. Confirm dates, descriptions, money out, money in, and balance columns before reshaping the file.
4. Export Excel for review. Use Excel when you need filters, formulas, notes, or a workbook for an accountant or reviewer.
5. Export CSV when the file is clean. Use CSV for accounting imports, reconciliation templates, or lightweight data handoff.

What to check in HSBC exports

A useful HSBC export should preserve transaction date, description, debit or money-out amount, credit or money-in amount, and balance where the statement provides it. Some statements may include transaction type, reference, cheque details, card suffixes, or transfer notes. Keep those details during review because they can explain how a transaction should be categorized later.

For accounting cleanup, create a separate working copy after the first export. The raw export should stay close to the source PDF. The working copy can simplify columns, add category notes, or convert debit and credit columns into one signed amount column if the destination workflow needs that format.

HSBC UK, Hong Kong, and other statement layouts

HSBC statement layouts can vary by country, account type, currency, and statement age. HSBC UK and HSBC Hong Kong statements may use different labels, date formats, transaction descriptions, and balance presentation. Treat those differences as review items rather than assuming one fixed template.

If the statement uses a regional date format, confirm how the exported spreadsheet interprets dates before sorting or importing. A date such as 04/05/2026 may be read differently depending on the workbook locale. For cross-border or multi-currency accounts, keep currency context with the source PDF and exported workbook.

Common HSBC conversion issues

Repeated page headers

Long HSBC PDFs may repeat table headers on each page. Remove repeated headings before using the file for accounting import or reconciliation. Header rows are useful for reading the PDF, but they should not become transactions in a CSV.

Wrapped descriptions

Descriptions can wrap onto another visual line in the PDF. After conversion, look for rows where the date or amount is blank but text continues. Those lines may need to be merged with the transaction above.

Summary and message sections

Opening balance, closing balance, statement messages, and account summaries are useful checks, but they should not usually be imported as transaction rows. Keep them in mind for validation and remove them from the final import copy.

CSV or Excel for HSBC statements?

Use CSV when the next step is import, reconciliation, automation, or a simple spreadsheet handoff. Use Excel when a person needs to review the conversion, add notes, apply filters, calculate totals, or prepare a workbook for an accountant.

For messy statements, Excel is usually the safer first export. Review the workbook, clean the structure, then save a simplified CSV only when another system needs a plain import file.

Questions about HSBC statements

Where do I download an HSBC statement?

Use HSBC's official online banking or app statement area for your account. The exact menu can vary by country and account type, so follow HSBC's current instructions inside your banking portal. After the PDF is downloaded, upload it to BsConv for CSV or Excel preparation.

Can I convert HSBC transaction history instead of a statement?

If HSBC provides a native CSV for the exact date range, that may be the cleanest source. PDF conversion is useful when the reliable file you have is a bank-issued statement PDF or an older statement where the PDF is the record you need to work from.

What if my HSBC statement is scanned?

Use the clearest scan available and review the OCR output carefully. If the scan is cropped, rotated, or faint, start with the scanned statement OCR guide before relying on the export.

About HSBC references

This guide is for converting HSBC statement PDFs that you already have permission to use. Use official HSBC channels for login, statement download, account questions, and bank support. After you have the PDF, use BsConv to prepare CSV or Excel rows for review.