To get an HDFC bank statement into CSV, first look at what formats your own net-banking or app statement download offers, because banks change layouts. If a spreadsheet-friendly format is offered, use it; if you only get a PDF, open it in a spreadsheet or a statement importer and clean the columns. Then check that the totals match the statement.
Which format should we try first?
Prefer the most structured option your account offers. A downloadable spreadsheet or text-based file is easier to work with than a PDF. If only a PDF is available, make sure it is the digital file from the bank, not a scan or a photo, because scans need text recognition and often misread digits. we are not describing menus or layouts here, because they differ by account type and change over time; check your own screen.
How do we clean the columns?
Whatever you get, aim for one row per transaction with these columns: date, description, amount and (optionally) balance. Many statements show money out and money in in two separate columns. Merge them into one signed amount. If withdrawals are in column D and deposits are in column E, then in F2 use =E2-D2 and fill down. A blank cell counts as zero, so that works when one is empty. Money out becomes negative and money in positive.
- Dates: if they arrive as text such as 05/04/26, select the column and convert with Data, Text to Columns, choosing the right day-month-year order, in Excel; in Google Sheets use DATEVALUE only after checking the pattern.
- Extra spaces in descriptions: =TRIM(B2) removes them.
- Header rows repeated on every page of a PDF import: filter and delete them.
- Opening and closing balance rows: keep them in a separate sheet, not mixed into the data.
How do we check the result is right?
Use arithmetic, not eyeballing. With made-up numbers: suppose the statement shows an opening balance of ₹42,500, total withdrawals of ₹31,200 and total deposits of ₹38,000. The closing balance should be 42,500 - 31,200 + 38,000 = ₹49,300. In your sheet, =SUM($F$2:$F$500) should equal 38,000 - 31,200 = 6,800, which is the difference between closing and opening balances (49,300 - 42,500). If the two disagree, a row was dropped or duplicated during the conversion.
| Check | Working | Expected (₹) |
|---|---|---|
| Net movement from the statement | 49,300 - 42,500 | 6,800 |
| Sum of signed amounts in sheet | =SUM($F$2:$F$500) | 6,800 |
| Row count | Compare with the statement | Same |
What if the PDF will not convert cleanly?
- Try opening the PDF directly in the spreadsheet's import feature, where available, rather than copying and pasting.
- Check whether lines wrap onto a second row, which splits one transaction into two.
- Fix the pattern once, then fill down, rather than correcting rows one by one.
- Never use an online converter that asks you to share your net-banking login. A statement file does not need one, and your login must stay with you alone.
- Delete the converted copy when done if it was processed on a service you do not trust.
Do we need a CSV at all?
Not necessarily. SpendixAI accepts bank and card statements as PDF, CSV or Excel, lets you review the rows before saving, and keeps each transaction against the account you chose. It does not promise every layout will parse perfectly, so review the preview. It does not need your net-banking details. If your goal is categorised spending rather than a perfect CSV, uploading the statement directly can skip the cleanup altogether.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

