Convert ICICI Bank statements to Excel or CSV
To convert an ICICI Bank statement PDF to Excel, download the statement from ICICI Internet Banking or iMobile, or save the emailed e-statement, then upload it to BankConv, enter the PDF password if asked and download Excel, CSV or Google Sheets. ICICI's stated rule for the emailed account e-statement is the first four letters of your name in lowercase plus your day and month of birth as DDMM, for example suji0501.
Updated
Download your ICICI Bank statement
- 1.Log in to ICICI Bank Internet Banking or the iMobile app.
- 2.Look under My Accounts (or Accounts & Deposits) for Bank Accounts, then Account Statement or Detailed Statement.
- 3.Choose the account and the date range, then download the statement as PDF.
- 4.Or save the PDF attached to the monthly ICICI e-statement email.
- 5.Upload the PDF to BankConv. You can convert up to 10 statements in one batch.
Do you need to convert at all?
ICICI Internet Banking can show the transactions for a date range and usually lets you download them as PDF or Excel (XLS). For a recent period from your own login, that XLS may be all you need.
Emailed e-statements are password-protected PDFs only, and the online date range per download is limited. Statements a client sends you, or older ones you saved, need converting.
ICICI Bank export formats: PDF, XLS
What to know about ICICI Bank PDFs
- Deposits can come before withdrawals
- Many emailed ICICI e-statements print Date, Mode, Particulars, Deposits, Withdrawals, Balance, with deposits first. If you copy columns into a template built for another bank, check which column is money in before you map it.
- Two different layouts
- The emailed e-statement and the statement you download from Internet Banking look different. The downloaded one usually has Value Date, Transaction Date, Cheque Number and Transaction Remarks. Both convert, but don't mix them in one sheet without lining up the columns.
- The first row is the opening balance
- ICICI statements usually start with a B/F (brought forward) line that has a balance but no amount. Keep it for the balance check, then delete it before importing, or your software may treat it as a transaction.
- Particulars hold the UPI and NEFT detail
- Lines such as UPI/123456789012/name/bank or NEFT-ref-name wrap over several lines in the PDF. They come through in one cell, so you can filter on UPI or NEFT in Excel.
ICICI bank statement password
For the emailed account e-statement, ICICI’s stated rule is the first four letters of your name in lowercase, followed by your day and month of birth as DDMM.
- Use your name as it appears in the bank’s records, without spaces, special characters or salutations such as Mr or Ms.
- Example: Sujit, born 5 January, uses suji0501.
- For a joint account, use the first account holder’s name and date of birth.
- For a current account, use the date of incorporation instead of a date of birth.
For a statement you download from Internet Banking or iMobile, the password rule is shown on the download screen. ICICI Bank customer care can confirm it if you’re unsure.
ICICI bank statement PDF to Excel in four steps
Upload the PDF, enter the password, check the rows and download. Each transaction becomes one row with date, particulars, amount and balance.
- Open the converter on this page or go to bank statement to Excel.
- Drop in the ICICI PDF, or up to 10 at once.
- Enter the PDF password when asked.
- Download Excel, CSV or Google Sheets.
Check the result before you use it
Spend two minutes checking the totals yourself.
- Take the B/F opening balance, add all deposits and subtract all withdrawals. The answer should match the closing balance on the last page.
- Pick three UPI rows at random and compare amount and date with the PDF.
- Make sure the date column reads 05/03 as 5 March, not 3 May. ICICI prints dates day first.
ICICI statements in Tally, Zoho Books and GST work
BankConv gives you Excel, CSV or Google Sheets. It does not create Tally XML, but the sheet is the usual starting point.
- TallyPrime: look for the import option on the bank reconciliation screen, or use an Excel-to-Tally utility that maps Date, Particulars, Withdrawals and Deposits to vouchers.
- Zoho Books: go to Banking, open the account and choose Import Statement, then upload the CSV.
- GST and ITR work: filter Particulars for a GSTIN, a vendor name or “NEFT” to match payments against invoices.
Other Indian banks: HDFC Bank, SBI, Axis Bank, or all Indian banks.
Sources: ICICI Bank: Statements
Columns you get
| Date | Particulars | Amount | Balance |
|---|---|---|---|
| 01-09-2026 | UPI/123456789012/ZOMATO/zomato@hdfcbank/Payment | -386.00 | 45,614.00 |
| 03-09-2026 | NEFT-ACME INDIA PVT LTD-SALARY | 72,500.00 | 1,18,114.00 |
| 04-09-2026 | UPI/234567890123/BIGBASKET/bigbasket@ybl/Groceries | -2,140.50 | 1,15,973.50 |
| 06-09-2026 | ATM/CASH WDL/ANDHERI MUMBAI | -5,000.00 | 1,10,973.50 |
Sample rows in ICICI Bank's layout, fictional data. First 5 pages free to check.
Deleted after 24 hours
Your PDF and its converted files are deleted automatically. Account owners can choose 48 or 72 hours instead.
Read only to extract transactions
Your statement is read (with OCR for scans) to pull out the transaction rows you download.
Encrypted in transit
Uploads and downloads use HTTPS (TLS).
Passwords never stored
The password of a protected PDF is used once to open the file.
No bank login
BankConv works from the PDF you download, never from a connection to your bank.
ICICI Bank statement questions
What is the password for my ICICI Bank statement PDF?
For the emailed account e-statement, ICICI's stated rule is the first four letters of your name in lowercase, as in the bank's records, followed by your day and month of birth as DDMM. For Sujit, born 5 January, that is suji0501. Joint accounts use the first holder's details, and current accounts use the date of incorporation. For a statement downloaded from Internet Banking or iMobile, follow the password instructions on the download screen, or ask ICICI Bank customer care.
How do I convert an ICICI bank statement PDF to Excel for free?
Upload it to BankConv. Your first 5 pages convert free with no signup, and a free account (needed to download) gives you 5 pages a day. Longer statements are priced per document, or covered by a monthly plan; the pricing page has the rates.
Can I convert several months of ICICI statements at once?
Yes. Upload up to 10 PDFs in one batch, up to 30 MB each. Each statement becomes its own set of rows that you can combine in Excel.
Do I need my ICICI Internet Banking login?
No. You download the PDF yourself and upload it. BankConv never connects to your bank account, and the PDF password is used once and never stored.
Other India banks
- HDFC Bank
- State Bank of India
- Axis Bank
- Kotak Mahindra Bank
- Bank of Baroda
- Canara Bank
- Punjab National Bank
- Union Bank of India