How to export your bank statement as a CSV — HDFC, ICICI, SBI, Axis, Kotak, Zerodha

If you want to see where a month of money went — in a spreadsheet, in a tracker like TheMoneyMitra, or just for your own records — the fastest way is to export your transactions as a CSV from net banking and work from that file.

Every Indian bank puts this feature in a slightly different place and renames it every redesign, so instead of exact click paths (which go stale), here's the reliable pattern, then bank-specific notes.

The general pattern

In almost every bank's net banking or app:

1. Open Accounts and pick the account you want.
2. Find Statement, Account Statement, Transaction History, or e-Statement.
3. Choose a custom date range rather than "last 10 transactions." A full calendar month is the useful unit.
4. Choose the download format. You want CSV, Excel / XLS, or delimited / text — not PDF. PDF is for printing; CSV is for software.
5. Download, and note where the file went (usually your Downloads folder or, on mobile, Files).

That's it. The rest is bank-specific quirks.

HDFC Bank

• NetBanking (web): Accounts → Enquire → A/C Statement (or Statement of accounts). Pick the date range, then choose "Delimited" as the format — that's HDFC's name for CSV. "Statement in Excel" also works.
• HDFC app: Accounts → your account → Statement → email or download. The emailed statement is usually a PDF, so prefer the web flow for CSV.
• HDFC's CSV puts opening/closing balance rows and some header lines above the transactions — a good importer skips those automatically.

ICICI Bank

• iMobile / net banking: Services / Accounts → Bank Statement → select account and period → Download → choose Excel or CSV.
• ICICI also offers "Statement on email" — that's a password-protected PDF, not what you want here.
• The narration column is long and contains the UPI/IMPS reference strings — that's normal, and it's what lets a tracker recognise the merchant.

State Bank of India (SBI)

• OnlineSBI (web): Account Statement → pick account → date range → select "CSV file" as the delivery option (the choices are usually View / Download in PDF / Download in CSV / Download in Excel).
• YONO app: Accounts → Account Statement → the app leans toward PDF; use OnlineSBI on the web for a clean CSV.
• SBI's CSV sometimes uses Txn Date and Value Date as separate columns — the transaction date is the one you care about.

Axis Bank

• Internet banking: Accounts → Account Statement / Detailed Statement → date range → Download as Excel (Axis's Excel export opens fine as a spreadsheet and imports like a CSV).
• Axis Mobile: Accounts → Statement → Download. Choose Excel where offered.

Kotak Mahindra Bank

• Net banking: Accounts → Statements / Account Statement → custom period → Download → Excel / CSV.
• Kotak app: Service Requests / Accounts → Account Statement → email or download; the web flow is more reliable for CSV.

Zerodha (Coin / Console)

Not a bank, but people track investments alongside spending:

• Console (console.zerodha.com): Reports → Tradebook, P&L, or Ledger → set the date range → CSV download.
• The Ledger export is the closest thing to a bank statement — every debit and credit to your trading account.

Before you import it anywhere

A quick check saves a messy import:

• Open the file in a spreadsheet first. Confirm you can see rows of transactions with a date, a description/narration, and an amount (either one signed column or separate debit/credit columns).
• Delete nothing. Header rows, balance rows, and footer disclaimers are fine — a decent importer ignores them. Editing the file by hand is how imports break.
• Check the date range is the month you meant to export. Overlapping exports create duplicates; most importers de-duplicate, but it's easier to not overlap.
• Password-protected files (common with emailed statements) can't be imported until you remove the password — which is another reason to use the direct web download instead of the emailed version.

Then what

Once you have the file, you can pivot it in a spreadsheet, or import it into a tracker that categorises the rows for you.

That second part is what TheMoneyMitra does — you import the CSV, it turns the cryptic UPI narrations into plain merchant names and categories, and you get a monthly summary without a bank login anywhere in the process. It's in private beta on iOS and Android now; leave your email for a launch invite.