How to Import HSBC Bank Statement into Microsoft Excel

To import your HSBC statement into Microsoft Excel: download your PDF from uk.hsbc.com → My Banking → Accounts → Statements & Documents, convert it to Excel (.xlsx) using Bank Statement Converter (free, under 20 seconds), then upload via Double-click to open — no import steps needed. No manual re-keying — all transactions transfer automatically.

Step 1: Download Your HSBC Statement

  1. 1. Log in at uk.hsbc.com and select your account from the Accounts overview
  2. 2. Click 'Statements & Documents' in the left-hand account menu
  3. 3. Select the statement period (month and year) you need
  4. 4. Click 'View statement' to open the PDF in your browser
  5. 5. Click the download icon or use your browser's Save option to save the PDF

Step 2: Convert PDF with Bank Statement Converter

Upload your PDF to Bank Statement Converter — select Excel (.xlsx) output — download in under 20 seconds.

Step 3: Import into Microsoft Excel

  1. 1. Download the Excel (.xlsx) file from Bank Statement Converter
  2. 2. Double-click the file to open it in Microsoft Excel
  3. 3. All columns are pre-formatted: Date, Description, Debit, Credit, Balance
  4. 4. Use Excel's AutoFilter (Data → Filter) to sort and search transactions
  5. 5. Add formulas or pivot tables for monthly summary analysis

Frequently Asked Questions

How do I download my HSBC bank statement?
Log in at uk.hsbc.com and select your account from the Accounts overview → Click 'Statements & Documents' in the left-hand account menu → Select the statement period (month and year) you need → Click 'View statement' to open the PDF in your browser → Click the download icon or use your browser's Save option to save the PDF
Do I need to do anything to the Excel file after downloading?
No. The .xlsx file opens directly in Excel with properly formatted columns. Date, Description, Debit, Credit, and Balance are pre-formatted — dates as Date type, amounts as Number with 2 decimal places.
How do I create a monthly spending summary?
Select any cell in the data → Insert → PivotTable → OK. Drag 'Description' or 'Category' to Rows and 'Debit' to Values. This creates a spending-by-merchant breakdown instantly.
Can I open the Excel file in Google Sheets?
Yes. Go to Google Sheets → File → Import → Upload and select the .xlsx file. All formatting and values transfer correctly.
Is my HSBC data safe to upload?
Yes. Bank Statement Converter processes files in-memory and deletes them immediately after conversion. No data is stored, logged, or used for model training. No account is required.
Convert Free — No Signup