To convert an HDFC Bank statement from PDF to Excel, first look for a CSV or Excel download of the same period, because that skips conversion altogether. If only a PDF is available, use Data, Get Data, From File, From PDF in Excel for Microsoft 365 or a recent desktop version, load the transaction table, and then clean dates, amounts and repeated header rows before trusting any total.
Should I copy from the PDF or convert it?
Copy and paste from a PDF usually drops everything into one column, with narration, date and amount glued together. A proper conversion keeps columns apart. In Excel, the From PDF connector shows you each table it finds on each page; pick the one that holds the transactions and choose Transform Data so you can tidy it before loading. Google Sheets has no built-in PDF table import, so for Sheets start from a CSV or Excel file.
Why do my dates look wrong after converting?
Dates often arrive as text, which means they will not sort or filter as dates. Check by clicking a date cell: if it is left-aligned and the formula bar shows something like 05/04/2026 as plain text, it needs fixing. Say the date text is in A2 in day/month/year form. This converts it regardless of your computer's regional setting:
- =DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2))
- Fill it down, then copy the results and use Paste Special, Values.
- Format the new column as a date, such as dd-mmm-yyyy, so a swap of day and month is obvious.
If your statement uses two-digit years, check the first lines of the file and change RIGHT(A2,4) to 2000+RIGHT(A2,2). We cannot say which style your statement uses, so look at your own file.
How do I get debit and credit into separate columns?
Some statements already have two money columns. Others have one amount and a marker. Work out which yours is before choosing a formula. With the amount in C2 stored as text such as 1,250.00 and a Dr or Cr marker in D2:
- Debit: =IF(D2="Dr", VALUE(SUBSTITUTE(C2,",","")), "")
- Credit: =IF(D2="Cr", VALUE(SUBSTITUTE(C2,",","")), "")
- If your file has two numeric columns already, skip this step and make sure empty cells are truly empty, not a dash or a space.
How do I remove the rows that are not transactions?
PDF conversions often repeat the column headings on each page and add opening balance, page totals or a closing line. Add a helper column that flags real rows: =ISNUMBER(A2) is TRUE only when A2 holds a real date. Filter the helper column for FALSE, review those rows once, and delete them. Keep the running-balance column until the check below is done, then delete it if you do not need it.
How do I confirm the table is complete?
Tally it. Say a month shows an opening balance of ₹18,400, credits of ₹62,000 and debits of ₹49,750. Then ₹18,400 plus ₹62,000 minus ₹49,750 is ₹30,650. Compare that with the closing balance on the statement. In the sheet, the totals are:
- =SUM(F2:F500) for the debit column
- =SUM(G2:G500) for the credit column
- =B1+SUM(G2:G500)-SUM(F2:F500) with the opening balance in B1
If the result differs from the printed closing balance, a row was lost or duplicated in conversion. Sort by date and check the gap where the running balance stops making sense.
Keep the converted sheet and the original PDF together in one folder, with the month in both file names. When a number looks odd in six months, the PDF is the document to check against, and the sheet shows what you did to it. Add a short note in a spare cell saying which steps you took, such as dates converted and header rows removed.
When does a sheet stop being enough?
A cleaned sheet is fine for one month. When you have a dozen of them and want categories and reports, uploading the original statement to a tracker such as SpendixAI saves the repeated clean-up, because it lets you review rows before they are saved.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


