How to Convert ICICI Bank Statement PDF to Excel or CSV

Quick Answer: To convert an ICICI Bank statement PDF to Excel or CSV, log in to ICICI Internet Banking or iMobile Pay, navigate to Accounts → e-Statements, download your statement as a PDF, then use [QuickBankConvert](/) to convert it instantly in your browser — no upload, no account required, results in seconds.

Why ICICI Bank Customers Need Statement Conversion

ICICI Bank is one of India's largest private sector banks, with over 100 million customers across personal banking, NRI accounts, business banking, and credit cards. Whether you're reconciling business expenses, preparing ITR documentation, or analyzing household spending in a spreadsheet, you'll quickly run into a familiar frustration: ICICI Bank's default statement download is a PDF — not a ready-to-use Excel or CSV file.

That gap has real consequences. Indian financial workflows are increasingly digital, with chartered accountants, GST consultants, and business owners all expecting importable data rather than printable documents. If you're running a small business in India, handing a stack of bank statement PDFs to your CA wastes time for everyone. If you're tracking expenses in Google Sheets or Tally, manual data entry from a PDF is error-prone and slow.

This guide covers everything you need to know: how to download statements from ICICI Internet Banking and iMobile Pay, how to convert them to Excel or CSV using a free tool, and how to handle the unique formatting challenges in ICICI statement PDFs — including lakh notation, DD/MM/YYYY date formats, INR currency symbols, and multi-page transaction tables.

How to Download Your ICICI Bank Statement

Before converting anything, you need the PDF. ICICI Bank provides statements through two main channels: Internet Banking on the web and iMobile Pay on mobile.

Downloading via ICICI Internet Banking (Desktop)

1. Go to icicibank.com and log in to your Internet Banking account using your user ID and password.
2. From the dashboard, click on Accounts in the top navigation, then select your account (savings, current, salary, etc.).
3. Look for e-Statement or Account Statement in the left sidebar or the account overview panel.
4. Select your desired date range. ICICI Internet Banking typically allows up to 10 years of statement history for most account types.
5. Choose PDF as the format and click Download or Send to Email (some accounts email the statement with a password).

Callout — Password-Protected PDFs: ICICI Bank frequently sends e-Statements as password-protected PDFs. The default password is usually a combination of your PAN number (first 5 characters, uppercase) followed by your date of birth in DDMMYYYY format — for example, if your PAN is ABCDE1234F and your DOB is 15 March 1990, the password would be ABCDE15031990. Check the email instructions for your specific account type.

Downloading via iMobile Pay (Mobile App)

ICICI's mobile banking app — iMobile Pay — is one of the most feature-rich banking apps in India and supports statement downloads directly:

1. Open iMobile Pay on your iOS or Android device.
2. Tap Accounts & Deposits from the home screen.
3. Select your account and tap Account Statement.
4. Choose the statement period. iMobile allows custom date ranges as well as preset periods (last 1 month, 3 months, 6 months, 1 year).
5. Tap Download PDF to save the statement to your phone, or Email Statement to receive it in your inbox.

iMobile Pay vs. Internet Banking: Which Is Better for Downloads?

For statement downloads intended for conversion to Excel or CSV, Internet Banking on desktop gives you more control over date ranges and is easier to handle large multi-page statement files. iMobile Pay is more convenient for quick one-tap downloads for recent periods, but sharing the file from mobile to your computer adds an extra step.

For NRI (Non-Resident Indian) accounts, ICICI also provides statements via ICICI Bank's NRI Portal, which works similarly to the main Internet Banking flow.

How to Convert ICICI Bank Statement PDF to Excel or CSV

Once you have your ICICI Bank PDF, converting it is fast using [QuickBankConvert](/).

Step 1: Open QuickBankConvert

Go to [QuickBankConvert.com](/) in any modern browser — Chrome, Firefox, Safari, or Edge all work. No account is required, no registration, no subscription.

Step 2: Upload Your ICICI Bank PDF

Drag and drop your downloaded ICICI Bank PDF onto the upload area, or click to browse for the file. If your PDF is password-protected (common with ICICI e-Statements), you'll be prompted to enter the password before processing. QuickBankConvert processes your file entirely in your browser — the PDF is never transmitted to a server, which is critical when your statement contains your full transaction history and balance information.

Step 3: Preview the Extracted Data

QuickBankConvert displays a preview of extracted transactions before you download anything. Verify that the dates (DD/MM/YYYY format), transaction descriptions, and INR amounts have been parsed correctly. Check a few rows against the original PDF to confirm accuracy.

Step 4: Choose Your Output Format

Select Excel (XLSX) or CSV depending on your use case:

• Excel (XLSX) — Ideal if you're working in Microsoft Excel or Google Sheets, want formatted cells, or plan to add formulas and pivot tables directly
• CSV — Ideal if you're importing into Tally, QuickBooks, Zoho Books, or any other accounting software that accepts CSV imports

Step 5: Download and Open

Click download. Your converted file saves to your device. Open it in Excel, Google Sheets, or import it into your accounting tool of choice.

Callout — INR Currency Display: After importing into Excel, INR amounts may display without the ₹ symbol in some regional settings. To add it: select the amount column, press Ctrl+1 to open Format Cells, choose Currency, and select ₹ Hindi from the symbol dropdown. This is a formatting preference only and doesn't affect the underlying numbers.

ICICI Bank-Specific Format Challenges

ICICI Bank statement PDFs come with several Indian banking-specific formatting patterns that can cause problems with generic PDF converters. Here's what to expect and how QuickBankConvert handles each:

1. DD/MM/YYYY Date Format

Indian banks including ICICI use DD/MM/YYYY date formatting — the opposite of the US convention (MM/DD/YYYY). A transaction dated 05/08/2024 is August 5, 2024, not May 8. Generic converters sometimes misinterpret these dates, swapping months and days and silently corrupting your data.

QuickBankConvert detects Indian date formats correctly. After conversion, verify a few known transactions to confirm dates are intact before using the data in a report.

2. Indian Numbering System (Lakh Notation)

ICICI Bank statements format large amounts using the Indian numbering system, where groups are separated differently than in the Western system. Instead of ₹1,000,000 (one million), you'll see ₹10,00,000 (ten lakhs). Amounts in the tens of thousands appear as ₹1,00,000 (one lakh), not ₹100,000.

This grouping pattern — with commas after the last three digits and then every two digits — can confuse parsers expecting Western number formatting. QuickBankConvert normalizes these values into plain numeric format so your spreadsheet formulas and SUM calculations work correctly.

3. INR Currency Symbol Handling

ICICI statements may include the ₹ symbol (Unicode ₹, U+20B9) or the older "Rs." prefix, depending on the statement generation date and account type. Older statements from before 2010 may use "Rs." while newer statements use ₹. Both should be stripped during conversion so amounts are stored as clean numbers.

4. Debit/Credit Column Layout

ICICI Bank savings and current account statements present debits and credits in separate columns rather than a single signed amount. The typical layout is:

Date | Transaction Remarks | Reference No. | Value Date | Withdrawal (Dr) | Deposit (Cr) | Balance

When converting to Excel, a good converter merges these into either two separate columns (Debit and Credit) or a single signed Amount column (with negative values for withdrawals). QuickBankConvert outputs both debit and credit columns by default, preserving the original ICICI structure.

5. Multi-Page Transaction Tables and Page Headers

ICICI Bank statement PDFs repeat column headers at the top of each page, and some pages include running balance summaries mid-page. These repeated headers and summary rows can pollute extracted data if the converter isn't designed to filter them out. QuickBankConvert identifies and excludes these non-transaction rows automatically.

6. Value Date vs. Transaction Date

ICICI statements include both a Transaction Date and a Value Date for each entry. The transaction date is when the transaction occurred; the value date is when it was credited or debited to your account for interest calculation purposes. Both dates are included in the conversion output. For most personal and business reconciliation purposes, use the Transaction Date column.

ICICI Bank Statement Download: Format Options Compared

Does ICICI Bank Offer Direct Excel or CSV Export?

For personal accounts, ICICI Bank does not offer a direct CSV or Excel download from Internet Banking or iMobile Pay. The only self-service download format is PDF.

Corporate/business accounts accessed through ICICI's CIB (Corporate Internet Banking) portal may have access to structured data exports in CSV or XML format for use with ERP systems. If you have a business account, check with your relationship manager about CIB data export options.

For all personal, salary, NRI, and most business accounts, the PDF-to-Excel conversion workflow is the standard approach.

Converting ICICI Statements to Google Sheets

Google Sheets is widely used for personal budgeting and light business tracking in India. Here's how to get your ICICI transactions into Google Sheets:

1. Convert your ICICI Bank PDF to CSV using [QuickBankConvert](/).
2. Open Google Sheets (sheets.google.com) and create a new spreadsheet.
3. Go to File → Import.
4. Upload your CSV file.
5. In the import dialog, set the separator to Comma and click Import Data.

Your ICICI transactions will appear with date, transaction remarks, reference number, and amount columns. From here you can:

• Add a SUMIF formula to total debits or credits by category
• Create a pivot table to analyze monthly spending
• Use conditional formatting to highlight large transactions
• Build a simple budget tracker by mapping transaction descriptions to expense categories

Importing ICICI Bank Data into Accounting Software

Indian businesses commonly use Tally, Zoho Books, or QuickBooks for accounting. Here's how to import your converted ICICI data into each:

Tally Prime

Tally Prime supports importing transactions via XML or through third-party migration tools. After converting your ICICI statement to CSV with QuickBankConvert, you can use Tally's built-in Data Import feature or a tool like TallyPrime Data Export/Import Utility to map CSV columns to Tally ledger entries.

Zoho Books

Zoho Books has excellent CSV import support. After converting, go to Banking → [Your Bank Account] → Import Statement, upload your CSV, and map the Date, Description, Debit, and Credit columns. Zoho Books handles INR by default for Indian accounts.

QuickBooks (Indian Edition)

QuickBooks Online India supports bank statement CSV imports under Banking → Upload from File. Map the date (use DD/MM/YYYY if QuickBooks asks for the format), description, and amount columns. QuickBooks will auto-categorize transactions you've seen before.

NRI Account Considerations

ICICI Bank is one of the most popular banks for Non-Resident Indians, offering NRE (Non-Resident External), NRO (Non-Resident Ordinary), and FCNR (Foreign Currency Non-Resident) accounts. Statement conversion for NRI accounts works the same way as standard accounts, but with a few additional considerations:

• NRE accounts hold INR and the statement format matches standard ICICI savings statements.
• FCNR accounts may list amounts in foreign currencies (USD, GBP, EUR, etc.) rather than INR. QuickBankConvert will preserve the currency as-is from the PDF.
• NRO accounts may include TDS (Tax Deducted at Source) entries as separate line items — these convert normally.

For NRI customers filing taxes in both India and their country of residence, having ICICI statements in Excel or CSV format is particularly valuable for running dual-currency reconciliation.

Related International Bank Statement Converters

ICICI Bank is one of many international banks whose PDF statements can be converted with QuickBankConvert. If you manage accounts at multiple banks — common for NRI customers or international businesses — you can convert statements from all of them using the same tool.

See our guide on converting international bank statements to Excel or CSV for a broader overview of how PDF conversion works across different countries and banking formats.

You can convert statements from banks in India, the UK, Canada, Australia, Singapore, and many other countries — all using [QuickBankConvert](/), which handles regional number formats, date conventions, and currency symbols automatically.

Bottom Line

Converting ICICI Bank statement PDFs to Excel or CSV is a two-step process: download the PDF from ICICI Internet Banking or iMobile Pay, then run it through [QuickBankConvert](/) to get clean, structured spreadsheet data. The whole workflow takes under two minutes.

ICICI statement PDFs have several India-specific formatting quirks — DD/MM/YYYY dates, lakh-notation numbers, INR currency symbols, and separate debit/credit columns — that can trip up generic converters. QuickBankConvert handles all of these correctly, outputting properly structured data that works in Excel, Google Sheets, Tally, Zoho Books, and QuickBooks.

Whether you're a salaried professional tracking household budgets, a small business owner reconciling accounts, a CA processing client statements, or an NRI managing accounts across geographies, converting your ICICI Bank PDF to Excel or CSV puts your financial data to work instead of leaving it locked in a printable document.