BankConv

How to Convert HDFC Bank Statement to CSV & Excel (Step-by-Step)

Convert HDFC bank statement PDFs to CSV or Excel in under 30 seconds. Handles password-protected files automatically. Free tool, no signup.

HDFC Bank is India's largest private sector bank, and one of the most commonly converted banks on BankConv. Like most Indian banks, HDFC sends statements as password-protected PDFs — which means you can't just open the file and copy the data into a spreadsheet. You need the password first, and then a way to extract the transactions cleanly.

This guide covers everything: downloading your HDFC statement, finding the right password, and converting it to CSV or Excel in under a minute using BankConv's free converter.

Converting HDFC bank statement PDF to CSV and Excel

What You'll Need

BankConv converts HDFC Bank statement PDFs to CSV, Excel, or Google Sheets in under 30 seconds — including automatic decryption of HDFC's password-protected files. All you need is your statement PDF and the password.

Before you start:

  • Your HDFC bank statement PDF — downloaded from HDFC NetBanking or the mobile app (instructions below)
  • The PDF password — HDFC uses a format based on your date of birth or Customer ID (details below)
  • A conversion tool — we'll use BankConv's free converter, which handles HDFC statements automatically

How to Download Your HDFC Statement PDF

HDFC Bank provides statement downloads through NetBanking and the HDFC Bank mobile app. BankConv supports HDFC statement PDFs from both platforms, in any date range, including multi-page statements.

From HDFC NetBanking

  1. Log in at netbanking.hdfcbank.com
  2. Go to Accounts → Savings Accounts → select your account
  3. Click Statement of Account
  4. Select the date range (up to 1 year)
  5. Click View and then Download as PDF
  6. Save the file to your computer

From HDFC Mobile App

  1. Open the HDFC Bank app and log in
  2. Tap your savings or current account
  3. Tap Statement or Download Statement
  4. Select the date range
  5. Choose PDF format
  6. The file saves to your phone's Downloads folder

Via Email (e-Statement)

HDFC also sends monthly e-statements by email. Check your inbox for emails from HDFC Bank with a PDF attachment. These are the same password-protected files and convert identically in BankConv.

HDFC Statement Password Format

HDFC Bank password-protects statement PDFs using your date of birth or Customer ID. BankConv handles HDFC's password-protected PDFs automatically — enter the password at upload and the file is decrypted and converted in one step.

The most common HDFC statement password format is:

Date of birth in DDMMYYYY format

For example, if your date of birth is 22nd July 1988:

  • Password: 22071988

If That Doesn't Work

HDFC has used different password formats depending on account type and when the statement was generated. Try these alternatives:

  • Customer ID — a 7-8 digit number found on your passbook, welcome letter, or NetBanking profile under "My Profile"
  • Date of birth in DDMMYY format — e.g., 220788
  • First 4 letters of your name (CAPS) + DOB (DDMMYYYY) — e.g., PREE22071988 (used on some older accounts)
  • PAN number (last 4 digits) — for some account types

If none of these work, contact HDFC Bank customer care (1800-202-6161) or check our HDFC statement password guide for updated format details.

Convert Your HDFC Statement With BankConv

BankConv's free converter handles HDFC Bank statements — including password-protected files, multi-page PDFs, and statements with NEFT/RTGS/UPI/IMPS transaction details — and exports clean output in under 30 seconds.

Step 1: Upload Your HDFC Statement

Go to BankConv's free PDF to CSV converter (or the Excel converter if you prefer .xlsx output).

Drag your HDFC statement PDF onto the upload area. BankConv will detect the password protection and prompt you to enter the password. Type it in — BankConv uses it only to decrypt the file during processing and never stores it.

Step 2: Choose Your Output Format

Select your preferred format:

  • CSV — best for importing into Tally, QuickBooks, or custom data workflows
  • Excel (.xlsx) — best for manual review, pivot tables, or sharing with clients and auditors
  • Google Sheets — for cloud-based collaborative editing
  • OFX/QFX — for direct import into QuickBooks or Quicken

Step 3: Download Your Converted File

Click download. Your file is ready — clean, structured transaction data from your HDFC statement with proper column headers and formatting.

You can also use BankConv's HDFC converter page for a direct link to the conversion tool.

What Your Converted HDFC Data Looks Like

BankConv extracts all transaction data from HDFC statements into 5 structured columns — Date, Narration, Debit, Credit, and Closing Balance — preserving HDFC's detailed transaction descriptions including NEFT/RTGS/UPI references, beneficiary names, and transaction IDs.

A typical converted HDFC statement looks like this:

DateNarrationDebitCreditClosing Balance
01/03/2026UPI-SWIGGY-HDFC-412876543-PAYMENT249.0035,751.00
03/03/2026NEFT/AXIR12345678/RENT MAR/AMIT SHAH18,000.0017,751.00
05/03/2026SALARY MAR 2026-INFOSYS LTD62,000.0079,751.00
06/03/2026BIL/TATA POWER/ELECTRICITY/0002341,480.0078,271.00
08/03/2026ATM/CASH WDL/HDFC-MUMBAI-BKC5,000.0073,271.00

HDFC-specific details to know:

  • Narration column — HDFC's descriptions are highly detailed. They include the transaction type (UPI, NEFT, RTGS, IMPS, BIL), reference numbers, counterparty names, and sometimes purpose codes. BankConv preserves all of this — nothing is stripped or truncated.
  • Transaction reference numbers — HDFC includes unique reference IDs for NEFT and RTGS transactions. These are useful for reconciliation and dispute resolution, and are preserved in the converted output.
  • Date format — HDFC uses DD/MM/YYYY. BankConv preserves this in the output. Reformat in Excel after download if you need a different format.
  • Closing Balance vs. Balance — HDFC labels the running total "Closing Balance" rather than just "Balance." The column header in the converted file matches the original statement.

Tips for HDFC Statement Conversion

BankConv supports HDFC statement conversion for all account types — savings, current, salary, demat-linked, and NRI accounts — with consistent output across single-page and multi-page statements.

Multi-page statements: HDFC quarterly or yearly statements can run 20-100+ pages. BankConv handles these automatically — every transaction across all pages is extracted into a single output file.

NEFT/RTGS reconciliation: If you're a CA or bookkeeper reconciling HDFC transactions, the preserved reference numbers in the Narration column make it easy to match individual NEFT/RTGS transfers against your client's records. Export as CSV, import into Tally, and map the columns: Date, Narration, Debit, Credit.

Credit card statements: HDFC credit card statements have a different format than savings/current account statements. BankConv supports both — upload the credit card statement PDF the same way and the transactions will be extracted correctly.

Batch conversion: Processing HDFC statements for multiple clients? Use BankConv's batch upload to convert multiple PDFs at once. Drop all your client statements onto the upload area and download them all together.

e-Statements from email: The HDFC e-statements you receive monthly by email are identical in format to the statements downloaded from NetBanking. Save the PDF attachment and upload it to BankConv — same password, same conversion process.

(Frequently Asked Questions)

Convert Your HDFC Statement Now — Free

Upload your HDFC bank statement PDF and get clean CSV or Excel data in under 30 seconds. Password-protected files handled automatically. No signup required.

Convert Your HDFC Statement →

Converting statements regularly for clients? See pricing for batch upload, API access, and all 6 output formats.