How to extract a bank statement to Excel
Start with the bank's own export when it has what you need. If you only have a PDF, compare Excel Power Query with a reviewed conversion workflow before choosing a file to use.
Which method should you use?
The best route depends on the files available and how cleanly the transactions come through. Each route still needs a source check.
| Method | Best fit | Check before use |
|---|---|---|
| Bank CSV/XLSX | The bank provides a complete export for the period | Dates, signs, currency, and required fields |
| Excel Power Query | A digital PDF exposes a table Power Query can detect | Wrapped rows, page breaks, and missing values |
| ExtractMint | A PDF needs reviewable spreadsheet rows | Every extracted row against the source; balance checks are not proof of completeness |
1. Prefer a complete bank CSV or XLSX export
If your bank offers CSV or XLSX covering the statement period and all required fields, use that export first. Open it in Excel and check the dates, debit and credit signs, currency, balances, and any reference fields against the original statement. A bank export can still omit a field your workflow needs or cover a different period.
2. Try Excel Power Query for a readable digital PDF
For a digital PDF with readable text, Excel Power Query's PDF connector can detect tables and show them in Navigator. Select the relevant table, then load or transform it in Excel. Multi-line transaction descriptions, page breaks, and wrapped rows may need cleanup before the result is useful.
See Microsoft's PDF connector documentation and Microsoft's Excel import instructions for the current steps and availability in your Excel version.
3. Use ExtractMint when a PDF needs reviewable rows
For a flat transaction table, follow the PDF-to-CSV workflow and column review checklist before using the exported file.
- Upload the statement PDF to ExtractMint.
- Review each extracted row against the source PDF, including descriptions and debit or credit direction.
- Choose the statement's date format when DD/MM/YYYY and MM/DD/YYYY are ambiguous.
- Check opening, running, and closing balances, then export Excel XLSX or CSV only after review.
ExtractMint is in beta. No bank-specific format has been independently validated against real statements. Balance checks are not proof of completeness: missing and extra rows can offset one another. Read privacy and data-flow details before uploading sensitive material.
Synthetic worked example
The built-in synthetic sample uses invented transactions and figures, not a real bank statement. Its opening balance is $1,000.00; a $300.00 deposit and withdrawals of $125.50 and $62.00 lead to a $1,112.50 closing balance.
Net change +$112.50 ($300.00 − $125.50 − $62.00). The arithmetic gives zero discrepancy against that closing balance. Even so, check each extracted amount against its source row and confirm date order from the statement before export. A matching balance does not prove every transaction is present. This synthetic example does not validate performance on real-bank formats.
Review checklist before using the spreadsheet
- Confirm the first and last dates match the statement period.
- Check every transaction row, including wrapped descriptions and rows near page breaks.
- Verify debit and credit direction, negative signs, currency, and required fields.
- Compare opening, running, and closing balances with the source; investigate mismatches.
- Open the exported file and spot-check the same rows again before import or handoff.