Bank Statement to Excel Converter
Turn a bank or credit-card statement PDF into a tidy Excel spreadsheet with one click. Instead of dumping every line into rows, this converter finds the statement's column header — Date, Description, Withdrawal, Deposit, Balance and the like — anchors every transaction across every page to those same columns, and removes the header and page numbers that repeat on each page. You get a single, clean table with a bold, frozen header row and right-aligned amount columns, ready to sort and total. Scanned statements are recognized with built-in OCR first, and your file never leaves your device.
What does this tool do?
The bank statement to Excel converter reads the text of a statement PDF and reconstructs it as a structured worksheet. It scores each line against common statement column keywords to locate the header row, then uses the horizontal position of each header label to define column boundaries. Every transaction line on every page is assigned to those columns by position rather than guesswork, so values line up consistently from the first page to the last. Repeated headers and page-number footers are dropped so the header appears only once at the top. Columns that are mostly amounts are detected and right-aligned, and the header is made bold and frozen so it stays visible as you scroll. The output is a native Office Open XML .xlsx workbook with real, editable cells.
How it works
For text-based statements the embedded words and their positions are read directly; image-only scans are rasterized and recognized with a Tesseract LSTM OCR engine in your browser. Recognized words are grouped into visual lines by vertical alignment and ordered left to right. The line that best matches statement keywords (date, description/particulars/narration, cheque/reference, withdrawal/debit, deposit/credit, balance) becomes the header, and the x-centre of each header cell defines a column anchor. Each data line's words are routed to the nearest column anchor, producing the same columns on every page. Lines identical to the header, and simple page-number footers, are skipped. A column is flagged right-aligned when most of its cells look like amounts. The rows, alignment, frozen pane, and column widths are serialized into worksheet and style XML and zipped into a valid .xlsx file.
Features
- Detects the statement header row and uses it to anchor all columns
- Aligns transactions to the same columns across every page
- Removes headers and page footers that repeat on each page
- Styled workbook: bold + frozen header row, right-aligned amount columns
- Sensible automatic column widths
- Automatic OCR for scanned, image-only statements
- 100% in-browser — your statement never leaves your device
- Falls back to a plain line dump when no header is found
How to use
- 1
Upload your statement
Drag your bank or card statement PDF onto the drop zone. Text-based statements are read directly; scanned or photographed pages are detected and OCR'd automatically.
- 2
Let it find the columns
The tool locates the statement's header row and uses each label's position to define the columns that every page's transactions are aligned to.
- 3
Convert to Excel
Click Convert statement to Excel. Repeated headers and page numbers are removed, amount columns are right-aligned, and the header is made bold and frozen.
- 4
Open and reconcile
Download the .xlsx file and open it in Microsoft Excel, Google Sheets, or LibreOffice Calc to sort, total, and categorize your transactions.
Common use cases
Reconcile transactions
Pull every transaction into aligned columns so you can sort by date, total debits and credits, and reconcile against your records without retyping.
Expense and tax prep
Get statement lines into a clean sheet to categorize spending, build expense reports, or prepare figures for tax filing.
Multi-page statements
Combine many statement pages into one continuous table with a single header, instead of repeated headers breaking up the data on each page.
Scanned or photographed statements
Recognize text from scanned statements with built-in OCR and turn them into a usable, structured spreadsheet.
Tips & best practices
- Column detection relies on a recognizable header row — statements with an unusual or missing header fall back to a plain line-by-line dump
- Amounts are kept as text to preserve exact formatting like 1,234.56 Cr; convert them to numbers in your spreadsheet app if you need to sum them
- Higher-quality scans produce more accurate OCR and cleaner column alignment
- Use the 'Bank statement (smart table)' toggle on the PDF to Excel tool for the same result with extra column options