HSBC UK Bank Statement Converter:
PDF to Excel & CSV

Check what HSBC UK gives you first

A file straight from your bank will always be more accurate than one reconstructed from a PDF, so it is worth two minutes to check before converting anything. HSBC UK offers largely withdrawn from retail online banking in recent years, covering the on-screen transaction list typically shows only about six weeks at a time. If the period you need sits inside that, use it and skip this page.

HSBC UK is the strongest case for a converter of any British bank right now. Over the last few years the CSV and Excel export options were removed from most retail online banking screens, and the transaction list you can see shows only around six weeks at a time. The PDF statements are still there and still go back years, so for HSBC customers the PDF is not a fallback, it is the only complete record you can get hold of.

Downloading the statement from HSBC UK

Statements live in the Statements area of HSBC Online Banking or the HSBC UK mobile app, and the online archive runs to five to seven years at the time of writing. Pick the period you need and download the PDF rather than printing to PDF from a screen, because a printed screen loses the transaction table structure the converter reads.

If the account has been closed, or the statement was forwarded to you by someone else, you will not have online banking access at all. That is the most common reason people end up converting a PDF: it is the only copy that exists.

Converting it to Excel or CSV

1. Upload the HSBC UK PDF to the converter above. Several months in one file is fine, and so is a JPG or PNG if all you have is a scan or a photo. Password-protected PDFs work; enter the password when prompted and it is not stored.
2. The pages are read, with OCR where the statement is a scan rather than text.
3. Check the transactions on screen against the statement before you download anything.HSBC UK statements typically carry Date, Payment type, Details, Paid out, Paid in and Balance.
4. Download the CSV and open it in Excel, Google Sheets, Numbers or LibreOffice, or import it into QuickBooks, Xero, FreshBooks or Sage.

Your first conversion runs without an account. A free account adds 7 free pages, and the monthly plans are priced by page count if you are working through years of statements or several clients.

What happens to your HSBC UK statement

Uploads travel over a 256-bit encrypted connection. There is no long-term file storage: the statement sits on the server only long enough to be read and is deleted 24 hours after upload. Conversion is fully automated, so no member of staff opens it, and nothing goes to a third party. The full privacy policy sets out the detail.

Reading a HSBC UK statement once it is in columns

HSBC UK statements use separate Paid out and Paid in columns with a balance, and a payment type column carrying the usual VIS, DD, SO, BP and ATM markers. VIS in particular confuses people, because it marks a Visa debit card payment rather than anything to do with a visa. With a six-week on-screen window, the payment type column is often the only way to reconstruct what a payment was, and getting it into a spreadsheet is the difference between filtering all card spending in a second and reading down a PDF.

Who converts HSBC UK statements, and why

HSBC UK customers are, right now, the people with the least alternative. The CSV export is gone from most retail screens and the visible transaction list covers about six weeks, so anyone who needs more than the last month and a half is working from PDFs whether they want to be or not. That covers mortgage applications, self-assessment, visa and settlement applications where HSBC's large expatriate customer base needs long continuous histories, and any dispute reaching back more than a couple of months.

HSBC UK statement converter FAQs