'%3e%3c/rect%3e%3crect%20x='0.5'%20y='0.5'%20width='31'%20height='31'%20rx='7.5'%20stroke='oklch(1%200%200%20/%200.08)'%3e%3c/rect%3e%3crect%20x='9'%20y='9'%20width='14'%20height='2.4'%20rx='1.2'%20fill='oklch(0.995%200.003%2095%20/%200.85)'%3e%3c/rect%3e%3crect%20x='13'%20y='14.8'%20width='10'%20height='2.4'%20rx='1.2'%20fill='oklch(0.995%200.003%2095%20/%200.55)'%3e%3c/rect%3e%3crect%20x='6'%20y='20.6'%20width='17'%20height='2.4'%20rx='1.2'%20fill='oklch(0.52%200.120%20250)'%3e%3c/rect%3e%3c/svg%3e){kind=small}
Bank statement to Excel
Get a workbook you can rely on: real date and amount cell types, a Validation Summary worksheet, and a source-page reference on every row — reviewed before you download.
The sample is a synthetic statement — no real bank, person, or account — generated by the same export writer that builds your download.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 1 May 2026 | BACS SALARY ACME LTD MAY PAY | £3,250.00 | £4,500.75 | |
| 2 May 2026 | CARD PURCHASE TESCO STORES 4381 | £46.82 | £4,453.93 | |
| 5 May 2026 | FASTER PAYMENT RENT 22 KING STREET | £1,450.00 | £2,799.53 | |
| 29 May 2026 | INTEREST PAID | £2.41 | £2,431.53 | |
| +11 more rows · opening 1250.75 · closing 2431.53 | ||||
One workbook, two worksheets: Transactions holds the reviewed rows; Validation Summary records what was checked, what was flagged, and how the balances reconciled.
Convert a PDF bank statement to Excel — after you've seen every row.
The workbook is built from the rows as you reviewed them, not from a first-pass guess. Every row carries the statement page it came from and its review status — the review trail travels with the file.
| Date | Description | Amount | Source page | Review status |
|---|---|---|---|---|
| 1 May 2026 | BACS SALARY ACME LTD MAY PAY | +£3,250.00 | 1 | valid |
| 6 May 2026 | CARD PURCHASE PRET A MANGER | (£6.75) | 1 | valid |
| 6 May 2026 | CARD PURCHASE PRET A MANGER | (£6.75) | 1 | needs_review |
| 14 May 2026 | FASTER PAYMENT FROM ALEX MORGAN | +£75.00 | 2 | valid |
| +11 more rows · opening 1250.75 · closing 2431.53 | ||||
Where bank-statement spreadsheets usually go wrong in Excel.
- Dates become text
- Pasted statement data often lands as text that won’t sort. The export writes real date cells, so date columns behave from the first open.
- Amounts won’t sum
- Currency symbols and thousands separators turn pasted amounts into text. Exported amounts are numeric cells; SUM and pivots work directly.
- Signs get flipped
- Debit and credit stay in separate columns, plus a signed amount column with the convention stated — nothing needs guessing.
- A column shows #####
- That’s only column width, not data loss — widen the column.
- What this export is not
- It’s a spreadsheet of your reviewed statement — not an accounting import file and not a connection to any accounting tool. Prefer CSV? The same review flow writes a documented, formula-safe file: bank statement to CSV.
About the Excel output
What’s inside the Excel file?
Two worksheets: Transactions (the reviewed rows) and Validation Summary (the checks, warnings, and the reconciliation outcome for the exported revision).
Are dates and amounts real Excel types?
Yes, where safe — proper date and money cell types, so sorting and formulas work without re-typing anything.
Can I convert a bank statement to Excel online free?
Yes — free during beta, within the stated limits (one digital PDF, up to 10 MiB and 20 pages), with no sign-up.
Why do some rows carry notes in the export?
Rows keep their review status and source-page reference, so you can see in the workbook which rows were flagged and where they came from.
Do you produce XLS or XLSX?
XLSX — the current Excel format. It opens in Excel and in independent spreadsheet tools.
Can I get CSV instead?
Yes — the same review flow produces a documented CSV output. See the bank statement to CSV page.