ICICI Bank PDF into Excel. In a sheet you can actually use.
Copy an ICICI statement out of a PDF and you get one jumbled column. Upload it here instead and get a real table — proper columns, amounts that add up.
Why copy-paste never works
Everything landing in one jumbled column
A real table, one row per transaction.
Totals showing zero because amounts are text
Debit, credit and balance are real numbers.
Dates Excel refuses to sort properly
Dates are real dates. Sorting and filters work.
Long UPI remarks splitting one entry into two rows
Split lines are joined back into one row.
Free tools rejecting your password-locked PDF
Type the password here. No other website needed.
No way to tell if any rows were missed
Every row is checked against the balance column.
How to convert an ICICI PDF statement to Excel
Three steps from PDF to a spreadsheet that opens clean.
Upload the ICICI PDF
Drag it in. If ICICI locked it, type the password — usually your date of birth as ddmmyyyy, or your customer ID.
We rebuild the table
Each page is read column by column, not line by line. Wrapped remarks are joined back together, opening balance and summary rows are left out, and every row is checked against the balance column.
Download the Excel file
You get proper date, remarks, reference, withdrawal, deposit and balance columns, plus the ledger name we detected for each row.
What is in the file you download
The sheet mirrors your statement, so it still looks familiar next to the PDF.
| ICICI PDF column | Excel column you get |
|---|---|
| Value Date | Value Date — a real date cell |
| Transaction Date | Transaction Date — a real date cell |
| Cheque Number | Cheque / Reference No. — kept as printed |
| Transaction Remarks | Narration — joined into one cell |
| Withdrawal Amount (INR) | Withdrawal — a number you can total |
| Deposit Amount (INR) | Deposit — a number you can total |
| Balance (INR) | Balance — also used to check each row |
| Not in the PDF | Detected Ledger Name — added by us |
Want to skip Excel? The same statement can go straight into Tally as entries.
Common questions
How do I convert an ICICI statement PDF to Excel?
Upload the PDF to SmartXtract and download the Excel file. It comes with proper date, remarks, reference, withdrawal, deposit and balance columns, and amounts as numbers rather than text.
Why can I not just copy the table out of the PDF?
A PDF does not really contain a table — it contains letters placed on a page. Copying it into Excel usually collapses everything into one column. The columns have to be worked out from the layout, which is what we do.
Does it work with password-protected ICICI statements?
Yes. Type the password when you upload. ICICI usually uses your date of birth as ddmmyyyy or your customer ID.
What about scanned ICICI statements?
Scanned pages are read too. Because scanning can misread digits, every row is still checked against the balance column before the Excel file is made.
Can I use the amounts in formulas?
Yes. Debit, credit and balance come out as numbers and dates as real dates, so SUM, filters and pivot tables work the moment you open the file.
Can I send it to Tally instead of Excel?
Yes. The same statement can be matched to Tally ledgers and posted as entries. Both start from the same upload.
Is my statement kept private?
Your statements stay in your own account and are not shared. Old documents are removed automatically once you pass the limit on your plan, and you can delete any document yourself at any time.