How to Convert ICICI Bank Statements to CSV & Excel (Step-by-Step)

Step-by-step guide to converting ICICI bank statement PDFs to CSV or Excel. Works with savings and current accounts. Free converter, no signup needed.

Converting an ICICI bank statement from PDF to CSV or Excel shouldn't require an hour of copy-pasting transaction data into a spreadsheet. Whether you're a chartered accountant reconciling client books, a small business owner preparing GST returns, or a freelancer tracking income, you need that transaction data in a usable format — not locked inside a PDF.

This tutorial walks you through converting your ICICI bank statement PDF into a clean CSV or Excel file in under a minute, using BankConv's free PDF-to-CSV converter.

To convert an ICICI bank statement to CSV, download your statement PDF from ICICI Internet Banking or iMobile Pay, upload it to a bank statement converter like BankConv, choose CSV or Excel as the output format, and download the converted file. The process takes under 30 seconds and works with both savings and current account statements.


What You'll Need

Before you start, make sure you have:

  • Your ICICI bank statement in PDF format, downloaded from ICICI Internet Banking or the iMobile Pay app
  • A bank statement converter — this guide uses BankConv's free tool, which requires no signup
  • If your statement is password-protected, you'll need the password (usually your account number or a combination of your date of birth and account number)

Step 1: Download Your ICICI Bank Statement PDF

If you already have your statement PDF saved, skip ahead to Step 2. Otherwise, here's how to download it from ICICI's platforms.

From ICICI Internet Banking

Log in to your ICICI Internet Banking account at infinityerp.icicibank.com (corporate) or infinity.icicibank.com (retail). Navigate to Accounts & Deposits, then select your savings or current account. Look for the Statement or e-Statement option — you can usually choose a date range up to 6 months. Select PDF as the download format and save the file.

From iMobile Pay App

Open the iMobile Pay app and tap on your account. Go to View Statement or Passbook, select the date range you need, then tap the download or share icon to save the PDF to your phone. You can email it to yourself or save to Google Drive if you want to convert it on a computer.

Tip: ICICI typically lets you download statements for the last 2 years through Internet Banking. For older statements, you may need to visit a branch or request via customer support.


Step 2: Upload to BankConv

Go to BankConv's free bank statement PDF-to-CSV converter. You can also use the PDF-to-Excel converter if you prefer a formatted spreadsheet.

Drag and drop your ICICI statement PDF onto the upload area, or click to browse and select the file. If your statement is password-protected, BankConv will prompt you to enter the password — type it in and the tool handles the rest. The password is used only to unlock the file during processing and is never stored.

Choose your output format:

  • CSV — best for importing into Tally, Excel, or Google Sheets for custom analysis
  • Excel (.xlsx) — gives you a formatted spreadsheet with column headers ready to use
  • Google Sheets — exports directly to a Google Sheets spreadsheet

BankConv reads the transaction dates, descriptions, debits, credits, and running balance from your ICICI statement — even from multi-page statements with dozens of transactions.


Step 3: Download Your Converted File

Once the conversion is complete, you'll see a preview of the extracted data. Take a quick look to verify that the transactions, amounts, and dates match your original statement.

Click Download to save your CSV or Excel file. That's it — what would have taken 30-45 minutes of manual data entry is done in seconds.

Quick checks to verify accuracy:

  • Compare the first and last transaction dates with your original statement
  • Check that the opening and closing balances match
  • Verify a few transaction amounts at random

Tips for Converting ICICI Statements

Password-protected PDFs: ICICI often password-protects downloaded statements. The password is typically your account number, your date of birth in DDMMYYYY format, or a combination. BankConv handles password-protected files — just enter the password when prompted.

Multi-page statements: If your statement spans multiple pages, BankConv processes all pages automatically. You don't need to split or combine anything beforehand.

Savings vs. current account: Both account types work. ICICI formats them slightly differently, but BankConv recognizes both layouts and extracts the transaction data accurately.

Joint accounts: Joint account statements from ICICI convert the same way. The format is identical to individual account statements — the converter picks up all the same fields.

Date ranges: For best results, download statements in monthly or quarterly chunks rather than a full year at once. Shorter statements convert faster and are easier to verify.


What You Can Do with Your Converted ICICI Data

Once you have your ICICI transactions in CSV or Excel format, here's what you can do with them:

Import into Tally: Tally is the most widely used accounting software in India. With your ICICI statement in CSV, you can import transactions directly into Tally ERP 9 or TallyPrime — no manual voucher entry required.

GST reconciliation: Match your bank transactions against GST invoices. Having the data in a spreadsheet makes it far easier to identify mismatches and reconcile your GST returns.

Tax preparation: Share clean spreadsheet data with your CA or tax preparer instead of handing them a PDF. It saves them time and reduces the chance of manual entry errors in your ITR filing.

Excel analysis and budgeting: Sort, filter, and categorize your transactions. Build pivot tables to see spending by category, track monthly cash flow, or identify recurring charges.

Import to QuickBooks or Zoho Books: If you use QuickBooks or Zoho Books instead of Tally, CSV files import cleanly into both platforms for bank reconciliation.

You can also convert your ICICI statements to OFX format for direct QuickBooks import — no reformatting needed.


(Frequently Asked Questions)