Guide
How to convert a bank statement to Excel
Bank statements arrive as PDFs or paper, but bookkeeping happens in spreadsheets. Here is the shortest reliable path from statement to a spreadsheet you can trust.
1. Collect the statement file
Download the statement PDF from your bank, or scan the printed copy at 300 DPI or higher. Clear, straight pages give the most accurate extraction.
2. Upload it for extraction
Sign in and upload the file. Each page is read and split into labelled blocks: headers, summary fields, tables and totals.
3. Review the extracted tables
The account summary, transaction ledger and fee lines appear beside the original page. Page through the document and confirm dates, descriptions, debits, credits and balances.
4. Preview the workbook
Open the Excel preview to see exactly how the sheets will be laid out — one sheet per section, with headers frozen and amounts formatted as numbers.
5. Export the .xlsx file
Download the workbook and open it in Excel, Google Sheets or Numbers. The extraction stays in your history if you need to export it again.
Common pitfalls
- Copy-pasting from a PDF viewer merges columns — always parse the layout instead of pasting raw text.
- Amounts imported as text break formulas. Confirm debits and credits are numeric before you reconcile.
- Multi-page statements often repeat headers. Make sure repeated header rows are not treated as transactions.