Bank Statement Converter – PDF to Excel Free
Turn a bank statement PDF into one clean Excel sheet: the account details once at the top, then every transaction from every page in one table, with real dates, amounts you can add up and a check of every balance.
How to convert a bank statement PDF to Excel
Choose the statement
Select or drop the bank statement PDF. If it has a password, type it when asked.
Pick the layout
Statement format keeps the account details once at the top; Transactions only gives one plain table for accounting software.
Convert and check
Press Convert statement, open the .xlsx and compare the totals on the Summary sheet with your statement.
Everyday uses
- Income tax returns – add up interest, salary credits and large payments for the year.
- Loan and visa applications – show six or twelve months of transactions in one sheet.
- Accounts and GST – save the transactions as CSV for your accounting software.
- Budgeting – sort and filter spending by month, shop or UPI ID.
- Business payments – match money received against your invoices.
Good to know
The tool finds the table of transactions from its column headings – Date, Narration or Description, Cheque/Ref No., Withdrawal or Debit, Deposit or Credit, Balance – and follows it across every page. The account details printed again at the top of each page, repeated headings and page footers are left out, so the details appear once and the transactions run on in one table.
Narrations that run over two or three lines are joined into one cell. Dates become real Excel dates and amounts become numbers, so sorting, filters and SUM work. A totals row follows the transactions, and the Summary sheet shows the opening balance, total withdrawals and deposits, the closing balance and a check of every balance (previous balance − withdrawal + deposit). When the statement prints its own summary, the figures are compared with it.
It is built for the layouts used by Indian banks such as HDFC Bank, SBI, ICICI Bank, Axis Bank and Kotak: with or without lines between the columns, details repeated on every page or not, oldest or newest transaction first. iLoveDocuments is not affiliated with any bank.
Private by design. Bank Statement Converter works inside your browser. Your statement is processed on your device and is not uploaded to our server.
Bank Statement Converter or PDF to Excel?
| Bank Statement Converter | PDF to Excel | |
|---|---|---|
| Account details | Once, at the top, as field and value | On every page, as printed |
| Transactions | One continuous table with one heading row | Page after page, as printed |
| Narrations over several lines | Joined into one cell | Joined into one cell |
| Dates | Real dates (dd/mm/yyyy) | Text, exactly as printed |
| Totals and balance check | Yes, with a Summary sheet | No |
| Best for | Bank statements | Any table in any PDF |
Limits to know before you start
- Needs a PDF with selectable text. A scanned or photographed statement must go through OCR PDF first, and OCR can misread digits, so check the totals.
- The transaction table must have column headings (a date and a balance, debit/credit or amount column). Statements without headings, credit card bills and passbook photos may not be recognised; use PDF to Excel for those.
- Account details are read from the first page as printed. An unusual layout can put a value next to the wrong field, so glance over them.
- If one PDF holds several accounts, their transactions end up in one table. Split the PDF first with Split PDF.
- In CSV files, text that starts with =, + or @ gets a leading apostrophe so spreadsheet apps show it as text instead of running it as a formula.
- Always compare the totals and the closing balance with the PDF before you use the file for tax, an audit or a loan application.
If something goes wrong
Some balances are marked in red. At those rows the running balance does not follow from the one before it. A row was probably read wrongly or skipped; compare those rows with the PDF.
No table of transactions was found. The PDF may be a scan – run OCR PDF first – or the statement has no column headings. Try PDF to Excel.
The tool asks for a password. Bank statements are often protected (the bank’s email says what the password is, often based on your name, date of birth or customer ID). Type it; it is used only in your browser, and the Excel file is not locked.
Dates show as numbers. Format the column as a date in your spreadsheet app, or turn off “Turn dates into real dates” to keep them as printed.
Bank Statement Converter – questions
How do I convert a bank statement PDF to Excel?
Select the statement, keep “Statement format” and press Convert statement. You get an .xlsx file with the account details once at the top and every transaction from every page in one table.
Why do the account details appear only once?
Banks print the account holder, address and account number again on every page. The converter keeps them once, at the top, and leaves out the copies, the repeated column headings and the page footers, so the transactions follow one another without gaps.
Which banks does it work with?
It reads the transaction table from its column headings, so it works with statements that have selectable text and headings such as Date, Narration, Withdrawal, Deposit and Balance – the layout used by most Indian banks, including HDFC Bank, SBI, ICICI Bank, Axis Bank and Kotak. If a statement is not recognised, PDF to Excel still extracts its tables.
Does it check the balances?
Yes. Every running balance is checked against the balance before it and the withdrawal or deposit on that row. Rows that do not add up are marked in red, and the Summary sheet says how many balances were checked.
Is my bank statement uploaded?
No. The PDF is read inside your browser on your own device and is not sent to our server.
Can I get a CSV for accounting software?
Yes. Under “Save as”, choose CSV (.csv). The CSV holds one heading row and the transactions, with dates as dd/mm/yyyy and amounts as plain numbers.
Does it work with password-protected statements?
Yes. Type the password when asked; it is used only in your browser to open the file.
What about scanned statements?
Run OCR PDF first to add a text layer, then convert the searchable PDF. Check the totals afterwards, because OCR can misread digits.
This page describes Bank Statement Converter as it works today. If you notice a difference, tell us and we will correct it. See our editorial standards.
Related tools
- PDF to ExcelPull tables from PDFs (bank statements, invoices) into Excel.
- Unlock PDFRemove the password from a PDF you can open.
- OCR PDFTurn scans into searchable, copyable text (English, Hindi, Gujarati).
- Redact PDFPermanently black out sensitive text, numbers and images.
Step-by-step guide: How to remove a PDF password (bank statement, e-Aadhaar)