Bank statements in Excel, privately
Most banks send statements as PDFs that look like tables but cannot be sorted, filtered or added up. This converter reads the statement in your browser and lays each transaction out as one spreadsheet row, with the date, narration, cheque or reference number, debit, credit and balance in their own columns. Amounts written the Indian way (1,23,456.50) or the Western way (123,456.50), with or without a โน sign, are stored as real numbers, so totals and filters work straight away; account and reference numbers that start with a zero stay as text. On this page all statement pages go into one sheet by default, so a year of transactions becomes one continuous list. A bank statement is about as private as a document gets, and here it never leaves your device.
How to convert a bank statement to Excel
- Download the statement PDF from your net banking. If it is password-protected, see the note below.
- Choose the PDF here. All pages are put into one sheet unless you change the Sheets option.
- Delete the repeated page headers, opening lines or summary boxes you do not need โ select the rows and press โ Row.
- Download the Excel file, then sort, filter or add up the Debit and Credit columns.
Features
- One row per transaction with separate debit, credit and balance columns.
- Indian and Western number grouping, โน signs and minus signs understood; amounts saved as numbers.
- All pages in one sheet, so a long statement becomes one list.
- Scanned or photographed statements are read with OCR.
- Edit before download: remove header rows, fix a cell, merge or split columns.
- Your statement is not uploaded anywhere.
Made for a particular job
- SBI Statement PDF to Excel โ SBI statements, with the password tip.
- HDFC Statement PDF to Excel โ HDFC Bank statements.
Password-protected statements
Many banks lock the statement PDF with a password (often a part of your name and date of birth). This page cannot open a locked file. Open it with the password in your PDF reader or browser, choose Print and then Save as PDF: the new copy has no password and converts normally. Keep the unlocked copy somewhere safe, or delete it when you are done.
After converting: useful next steps in Excel
- Monthly totals: insert a PivotTable with the date grouped by month and Debit and Credit as sums.
- Find a payment: filter the description column by a name or UPI ID.
- Check the balance: opening balance + credits โ debits should equal the closing balance; a mismatch points to a row that needs a look.
Your privacy
Your file is opened and converted inside your own browser tab. It is not uploaded to UltraTool360 or to any other server, and nothing is kept once you close the page. The page does download program code from public CDNs: the PDF library and, only when a page is a scan or a photo, the open-source Tesseract OCR engine with the language file you selected. Those are ordinary downloads to your device; the contents of your document are not sent with them.
Frequently asked questions
Which banks does it work with?
It does not depend on the bank: any statement PDF with columns of dates and amounts can be converted, from SBI, HDFC, ICICI, Axis, PNB, Bank of Baroda, a gramin bank or any other. Unusual layouts may need a column merged or split in the preview.
Are the amounts real numbers in Excel?
Yes, as long as "Save amounts as real numbers" is ticked. 1,23,456.50 and โน1,500 are stored as numbers, so SUM and filters work.
My statement has a password. What do I do?
Open it with the password in your PDF reader, print it to a new PDF (Save as PDF), and convert that copy.
Is it safe to convert a bank statement here?
The statement is read by your own browser and is not uploaded to UltraTool360 or to any other server. Nothing is kept after you close the page.
Can I convert a scanned or photographed statement?
Yes. Pages without text are read with OCR. Check the yellow cells, especially amounts, against the original.