BR
BankStatementReader

How to Get an HSBC Statement and Convert It

By BankStatementReader Team ·

When you need to set a budget, file a tax return, or send figures to an accountant, a paper-style PDF is rarely enough on its own — you need the transactions in a spreadsheet you can actually work with. This guide covers how to get an HSBC statement as a PDF from Online Banking or the mobile app, then convert that PDF into Excel or CSV. (Menu labels are updated from time to time, so treat the steps below as the typical route rather than exact wording.)

Get an HSBC statement via Online Banking

Online Banking on a desktop browser is one way; the mobile app is another.

  1. Log in to Online Banking.
  2. Select the current account (or credit card) you want a statement for.
  3. Look for a Statements or documents area of the account. The exact menu and wording can vary depending on which version of Online Banking you are using.
  4. Choose the statement period you need.
  5. Download the file as a PDF and save it somewhere you can find it again.

If you hold both a personal and a business account, double-check you have selected the right one before you download — sort codes and account numbers look alike at a glance, and it is easy to pull the wrong statement.

Get an HSBC statement in the mobile app

The app is useful when you only need a single month, or when you are away from your computer.

  1. Open the app and log in.
  2. Tap the account you want, then look for a Statements or Documents option.
  3. Pick the statement period.
  4. Use the view, share, or download option to save the PDF to your phone.

From the app you can usually email the PDF to yourself or save it to your phone's files, which lets you move it onto a computer for the conversion step.

Choosing the right statement period

  • HSBC statements are normally organised by monthly cycle, so select the month or months you actually need rather than downloading the lot.
  • For a Self Assessment tax return you may need a full tax year, which runs 6 April to 5 April. Download each consecutive month so there are no gaps. You can check the dates and deadlines on GOV.UK.
  • For a mortgage or loan application you are often asked for the last three to six months — download each period separately.
  • Keep the original PDF even after you convert it. It stays your source document if anyone needs to verify the figures, including a cheque you paid in or a direct debit that bounced.

Why convert the PDF to Excel or CSV?

A PDF is fine for reading, but it is awkward for anything analytical. You cannot sort it, total a column, or filter by payee. Once the transactions sit in a spreadsheet you can:

  • Categorise spending and build a monthly budget.
  • Total expenses for an expense claim or tax return.
  • Import the rows into accounting software for bank reconciliation.
  • Spot duplicate or unexpected payments, such as a forgotten subscription or an old standing order you meant to cancel.

How to convert an HSBC PDF to a spreadsheet

There are three common approaches, and the right one depends on how many statements you have.

Type it in by hand

For one short statement, you can open the PDF next to a blank workbook and key in each row. It needs no tools, but it is slow, and a single mistyped figure in a balance column is easy to make and hard to find afterwards.

Copy and paste

If the PDF has a real text layer (rather than being a scan), you can sometimes select the transaction table and paste it into Excel. Expect to tidy up afterwards: columns often collapse together, and longer payment descriptions can break the row alignment. Excel's Data → Text to Columns helps split the pasted text back into separate fields.

Use an automated converter

A dedicated converter reads the statement, detects the transaction table, and exports clean rows straight to Excel or CSV — including scanned or image-only pages that copy-paste cannot handle. This suits anyone who processes statements every month, or who has several to get through in one go. Drop your file into the free bank statement converter to export tidy rows to Excel or CSV.

For a fuller walkthrough of all three methods and the trade-offs of each, see how to convert a bank statement to Excel.

Pick a format: XLSX or CSV

Export to XLSX when you want formatting, formulas, or several sheets in one file. Choose CSV when you need to import the data into accounting or bookkeeping software, which usually expects a plain comma-separated file. Either way, once the data is structured you can move on to budgeting, reconciling, or filing with confidence.

A quick recap

  1. Log in to HSBC Online Banking or the mobile app.
  2. Open the Statements or Documents area, select the account and period, and download the PDF.
  3. Convert the PDF to Excel or CSV — by hand, by copy-paste, or with an automated bank statement converter.
  4. Keep the original PDF as your source document.

Related reading