How to convert a bank statement to Excel
- Download your statement as a PDF from your bank’s website or app (not a photo or scan).
- Drop it into the converter above. If the PDF is password-protected, enter the password when asked.
- Check the summary: Balance check ✓ means every row reconciles with the running balance.
- Fix any highlighted rows directly in the table, then click Excel (Pro) or CSV (free; opens in Excel too).
What the spreadsheet contains
| Column | Contents |
|---|---|
| Date | ISO date (YYYY-MM-DD). Excel recognises it as a real date. |
| Description | Merchant / narration, including wrapped second lines |
| Reference | Cheque or reference number when the statement has that column |
| Debit / Credit | Money out / money in as positive numbers |
| Amount | Signed amount (negative = money out), best for formulas |
| Balance | Running balance as printed on the statement |
Why not just copy and paste from the PDF?
Copying from a PDF usually produces one long column, merges amounts into descriptions, and loses which numbers are debits. StatementSheet reads the position of every word on the page to rebuild the columns, joins descriptions that wrap onto a second line, works out the statement year for dates like “Jan 05”, and verifies the result against the balance column.
Why not an online converter that uploads the file?
A bank statement contains your account number, address, salary, rent and spending history. Most converters upload it to their servers for processing. StatementSheet does the whole job inside your browser tab, so there is nothing to store, leak or sell.