Free online tool

Turn a bank statement PDF into a clean Excel sheet

Choose a bank statement PDF and this free tool turns it into a clean Excel sheet in your browser: every transaction becomes one row with its date, description, debit, credit and running balance, plus a totals row — downloadable as a real .xlsx file or a .csv. Nothing is uploaded and nothing is stored. The tool reads the text layer your bank already embedded in the PDF, so a scanned (image-only) statement has nothing to convert, and the tool says so plainly instead of inventing rows.

Quick answer

Quick answer

Choose a bank statement PDF and this free tool turns it into a clean Excel sheet in your browser: one row per transaction with date, description, debit, credit and balance, plus a totals row — downloadable as a real .xlsx or .csv. Nothing is uploaded, and a scanned statement is reported as having no readable text instead of inventing rows.

Open the interactive Bank Statement PDF to Excel Converter

The interactive tool loads in the page. Enable JavaScript to enter data, process content, and download results.

Worked example — the built-in sample statement

The built-in sample: a fictional Example Bank statement, January 2026, opening balance $5,000.00, 12 transactions.

Opening balance$5,000.00
Credits (4)$3,608.42 — salary $2,450.00, freelance $650.00, savings transfer $500.00, interest $8.42
Debits (8)$1,820.29 — rent $1,200.00, groceries $184.35, utility $96.40, ATM $200.00, coffee $12.75, subscription $15.99, pharmacy $42.60, restaurant $68.20
Closing balance$6,788.13
Reconciliation$5,000.00 + $3,608.42 − $1,820.29 = $6,788.13 — reconciles
Rows converted12 transactions, 0 skipped
Downloadsbank-statement.xlsx and bank-statement.csv, both built in the browser

The sample statement — 12 transactions

DateDescriptionDebitCreditBalance
02 Jan 2026Salary - ACME Corp$2,450.00$7,450.00
03 Jan 2026Rent - Maple Court Apt 4B$1,200.00$6,250.00
05 Jan 2026Grocery - Fresh Mart$184.35$6,065.65
07 Jan 2026Utility bill - City Power$96.40$5,969.25
09 Jan 2026ATM withdrawal - Main St$200.00$5,769.25
12 Jan 2026Freelance payment - Design work$650.00$6,419.25
14 Jan 2026Coffee shop - Daily Grind$12.75$6,406.50
16 Jan 2026Subscription - StreamPlus$15.99$6,390.51
19 Jan 2026Transfer from savings$500.00$6,890.51
21 Jan 2026Pharmacy - HealthPlus$42.60$6,847.91
24 Jan 2026Restaurant - Bella Italia$68.20$6,779.71
27 Jan 2026Interest credit$8.42$6,788.13

How each PDF column becomes an Excel column

PDF columnExcel columnHow it is read
DateDateMatched at the start of the row; copied exactly as printed
DescriptionDescriptionText between the date and the first amount
DebitDebitAmount printed in the debit column, or negative, parenthesised, or marked Dr
CreditCreditAmount printed in the credit column, or marked Cr
BalanceBalanceLast amount on the row — the running balance
Opening / Closing BalanceTotals checkRead separately; opening + credits − debits should equal closing

About this tool

About the Bank Statement PDF to Excel Converter

Choose a bank statement PDF and this free tool turns it into a clean Excel sheet in your browser: every transaction becomes one row with its date, description, debit, credit and running balance, plus a totals row — downloadable as a real .xlsx file or a .csv. Nothing is uploaded and nothing is stored. The tool reads the text layer your bank already embedded in the PDF, so a scanned (image-only) statement has nothing to convert, and the tool says so plainly instead of inventing rows.

Detailed guide

How to get useful results from Bank Statement PDF to Excel Converter

How the converter reads your statement

A bank statement PDF from your bank's website or app is not a picture — it carries a text layer, the same words you could select and copy. The converter reads that layer with pdf.js, groups the words into printed rows by their position on the page, and then reads each row from left to right: the date at the start, the description in the middle, and the amounts at the end.

The last amount on a row is the running balance. The amount before it is the movement for that transaction — a debit or a credit. Opening and closing balance lines are read separately, so the totals can be checked against them: opening balance plus credits minus debits should equal the closing balance, and the tool tells you whether they reconcile.

How debit and credit columns are found

Statements print debit and credit in separate columns, and the converter finds those columns by position: it collects the right-hand edge of every amount on the page and clusters them. The rightmost cluster is the balance column; the two clusters to its left are the debit and credit columns, debit first. A movement amount is placed by the column it was printed in.

When a statement uses a single amount column instead, position cannot decide, so the tool falls back to the markers banks print: a negative amount, an amount in parentheses, or a Dr marker means a debit; a Cr marker or a plain positive amount means a credit. If your statement marks amounts some other way, check the converted table against the PDF before relying on it.

Dates are kept exactly as printed

The converter never reformats a date. It copies the date exactly as printed — "02 Jan 2026" stays "02 Jan 2026", and "02/01/2026" stays "02/01/2026". That is deliberate: banks mix day-first and month-first formats, and 02/01 could be 2 January or 1 February depending on the bank.

Guessing wrong would silently corrupt the data, so the tool refuses to guess. If you need one consistent format in Excel, sort or reformat the date column yourself after downloading — you know which convention your bank uses, and the tool does not pretend to.

The sample statement, line by line

The built-in sample is a 12-transaction January statement for a fictional Example Bank account, generated in your browser as a real PDF. It opens with a balance of $5,000.00, then a salary credit of $2,450.00, rent of $1,200.00, groceries of $184.35, a utility bill of $96.40, an ATM withdrawal of $200.00, a freelance payment of $650.00, coffee of $12.75, a subscription of $15.99, a transfer from savings of $500.00, a pharmacy bill of $42.60, a restaurant bill of $68.20, and interest of $8.42.

The arithmetic checks out: credits add up to $3,608.42 and debits to $1,820.29, so $5,000.00 + $3,608.42 − $1,820.29 = $6,788.13, which is exactly the closing balance printed on the statement. The tool reports "Balances reconcile" for the sample — the same check it runs on your own statement.

What the Excel file contains

The .xlsx download is a real spreadsheet file, built in your browser: one sheet named "Statement" with five columns — Date, Description, Debit, Credit, Balance — one row per transaction, and a Totals row at the bottom with the summed debits and credits and the final balance. Amounts are plain numbers formatted to two decimals, so you can sort, filter, and add formulas in Excel, Google Sheets, or LibreOffice.

The .csv download is the same table in comma-separated form: a header row of Date, Description, Debit, Credit, Balance, then one line per transaction. It opens in any spreadsheet app and imports into budgeting tools that accept CSV. Neither file carries any bank formatting, logos, or account numbers beyond what was printed on the statement itself.

Scanned statements and other limits

A scanned statement is a photo of a page: it has no text layer, so there are no words for the converter to read. The tool detects that — zero text items on every page — and says so plainly: "no readable text found — scanned statements need OCR, not supported yet." It never invents rows to fill the gap. Download the statement from your bank's website or app instead; those PDFs usually carry a text layer.

Other layouts can also trip the reader. Statements that merge several transactions onto one printed row, that put the amount before the description, or that use unusual column orders may parse wrongly — a debit can land in the credit column, or a description can be cut short. Always check the converted table against the PDF before using it for anything that matters, and use the reconciliation check as a first warning: if the balances do not reconcile, something was misread.

Your statement never leaves the browser

A bank statement is about as private as a document gets, so the tool is built to never see it anywhere but your own tab. The PDF is read with the File API, the text is extracted with pdf.js running locally, the table is assembled in memory, and the .xlsx and .csv files are generated on your device. Nothing is sent to a server, nothing is stored, and closing the tab leaves no copy behind.

That also means there is no account, no queue, and no file-size limit imposed by a server — the only limit is your browser, and the tool caps files at 10 MB to keep the tab responsive. Multi-page statements are read page by page, so a year of statements in one PDF still converts in one go.

Quick guide

How to use this tool

  1. 01Choose a bank statement PDF, or press Load sample to try the built-in 12-transaction statement.
  2. 02The tool reads the PDF's text layer and builds the transaction table right away — date, description, debit, credit, balance.
  3. 03Check the totals: total debit, total credit, and whether the opening and closing balances reconcile.
  4. 04Press Download .xlsx for a real Excel file, or Download .csv for a comma-separated file.
  5. 05If the PDF is a scan, the tool says so plainly instead of inventing rows — download a text-layer PDF from your bank instead.

Capabilities

Features and supported formats

  • Reads a bank statement PDF's text layer with pdf.js — date, description, debit, credit and balance columns, in your browser.
  • Column detection by printed position, with Dr/Cr markers and negative amounts as fallback for single-column statements.
  • Opening and closing balance lines read separately, with a reconciliation check: opening + credits − debits should equal closing.
  • Real .xlsx export built in the browser (no server), plus a .csv export of the same table.
  • One-click sample statement — a real generated PDF with 12 transactions — that converts to 12 correct rows.
  • Scanned (image-only) PDFs detected honestly: no readable text found, no rows invented, OCR named as not supported yet.

Supported formats

Input: a bank statement PDF with a text layer, up to 10 MB, any number of pages. Output: a transaction table (Date, Description, Debit, Credit, Balance) with totals and a reconciliation check, downloadable as a real .xlsx file or a .csv file. Scanned image-only PDFs are detected and reported, not converted.

Answers

Frequently asked questions

What is a bank statement PDF to Excel converter?

It is a tool that reads a bank statement PDF and turns it into a spreadsheet: each transaction becomes one row with its date, description, debit, credit and running balance. This one runs entirely in your browser — the PDF is read with pdf.js, the table is assembled locally, and the .xlsx or .csv file is generated on your device, with nothing uploaded.

Can I convert a bank statement PDF to Excel free?

Yes. This converter is free with no sign-up and no upload: choose a PDF (up to 10 MB) or load the sample, and download the .xlsx or .csv right away. There is no per-file limit and no account — the only cost is your browser doing the work.

Is there a bank statement to Excel converter for 2027?

Yes — this converter works on statements from any year, including 2027 statements, because it reads the printed date, description and amounts rather than assuming a format or a year. Dates are kept exactly as printed, so a 2027 statement converts the same way a 2026 one does.

Does the converter upload my bank statement?

No. The PDF is read with the File API and processed only in your browser tab: pdf.js extracts the text, the table is built in memory, and the .xlsx and .csv files are generated on your device. Nothing is sent to a server, nothing is stored, and closing the tab leaves no copy behind.

What if my statement is a scanned PDF?

A scanned statement has no text layer — it is a photo of a page — so there are no words to convert. The tool detects that and says so plainly: no readable text found, scanned statements need OCR, not supported yet. It never invents rows. Download the statement from your bank's website or app instead; those PDFs usually carry a text layer.

How accurate is the conversion?

For a standard layout — date, description, debit, credit, balance in separate columns — the sample converts to 12 correct rows with totals that reconcile. Unusual layouts can misread: merged rows, amounts before descriptions, or odd column orders may put a debit in the credit column. Always check the table against the PDF, and use the reconciliation check as a first warning.

What does the Excel file look like?

One sheet named "Statement" with five columns — Date, Description, Debit, Credit, Balance — one row per transaction, and a Totals row with summed debits and credits and the final balance. Amounts are plain numbers formatted to two decimals, so you can sort, filter, and add formulas in Excel, Google Sheets, or LibreOffice.

Can I get a CSV instead of Excel?

Yes. The Download .csv button gives you the same table as a comma-separated file: a header row of Date, Description, Debit, Credit, Balance, then one line per transaction. It opens in any spreadsheet app and imports into budgeting tools that accept CSV.

Does it work on multi-page statements?

Yes. The tool reads the text layer page by page, so a statement that runs to several pages converts in one go, with all transactions in one table in page order.

What about password-protected PDFs?

Password-protected PDFs cannot be opened by the tool — it has no way to ask for or store your password. Remove the password first: most banks let you download an unprotected copy, or you can open the PDF in a reader, enter the password, and save an unprotected copy, then convert that.

Why are the dates not reformatted?

Because banks mix day-first and month-first formats, and 02/01 could be 2 January or 1 February depending on the bank. Guessing wrong would silently corrupt the data, so the tool copies each date exactly as printed. Reformat the date column in Excel yourself if you need one consistent format — you know your bank's convention.

Can I use it on my phone?

Yes. The file picker works in mobile browsers, and the whole conversion runs in the tab. Download the statement PDF from your banking app, open this tool, choose the file, and download the .xlsx or .csv to your phone.