StatementBear

PricingAPIDocsAbout
Log In

Convert HSBC statements to Excel or CSV

HSBC statements are dense: short payment codes, dates printed once per day, and three columns of figures. Upload one here and get a plain list of transactions you can open in Excel.

Drop your bank statement PDF here or click to upload

PDF files only, up to 10MB. Your file is processed securely and never stored.

Where to find your HSBC statement PDF

  1. Log on to HSBC Online Banking or the HSBC UK app.
  2. Open the account and go to Statements.
  3. Pick the statement and download the PDF.

How HSBC statements are read

One date for many rows

HSBC prints the date only on the first transaction of each day and leaves it blank on the rest. Every row in the export carries its own date.

Short payment codes

Rows start with a code such as VIS for a debit card payment, DD for a direct debit, SO for a standing order, CR for a credit or ))) for contactless, and the amount sits under Paid out or Paid in. The column sets the direction and the code is left in the description.

Parse HSBC statements in your own app

Send the PDF to the StatementBear API and get JSON back: every transaction with its direction and category, the account it belongs to, and a check that the totals reconcile. No bank login, no template per bank. The first 25 documents are free, then $0.49 each.

curl -X POST https://statementbear.com/api/v1/documents \
  -H "Authorization: Bearer $STATEMENTBEAR_KEY" \
  -H "Content-Type: application/pdf" \
  -H "Idempotency-Key: $(uuidgen)" \
  --data-binary @statement.pdf
Get an API keyRead the quickstart

Statements from other banks

Chase

Bank of America

Wells Fargo

Citi

Capital One

Amex

Barclays

Lloyds

Halifax

Nationwide

Monzo

Starling

N26

Your bank is not listed? Upload it anyway: the converter reads any bank, in any currency. All banks

Three simple steps

01

Download your HSBC PDF

Log on to HSBC Online Banking or the HSBC UK app. Open the account and go to Statements. Pick the statement and download the PDF.

02

Upload it here

Drop the PDF on the box at the top of this page. It is read in a few seconds and nothing is stored.

03

Download the CSV

One row per transaction with date, description, amount, direction and category. Opens in Excel, Google Sheets and Numbers.

Frequently asked questions

Want a complete spending analysis?

Upload your bank statement to StatementBear for AI-powered spending insights, scores, category breakdowns, and honest financial feedback.

Get Started Free

First analysis free

New to this? How to analyze a bank statement

Free Bank Statement Tools

Bank Statement to CSV Converter

Convert your bank statement PDF into a clean, structured CSV file that opens in Excel, Google Sheets, or any spreadsheet app.

Use tool

Bank Statement Redactor

Automatically remove sensitive information like account numbers, sort codes, and personal details from your bank statement before sharing.

Use tool

Subscription Finder

Scan your bank statement to find all recurring charges and subscriptions. See exactly what you pay for each month.

Use tool

Tax Deduction Finder

Identify potential tax-deductible expenses in your bank statement. Find deductions you might be missing at tax time.

Use tool

BNPL Tracker

Find all Buy Now, Pay Later payments in your bank statement. Track spending across Klarna, Afterpay, Clearpay, and other BNPL providers.

Use tool