Bank statements

HDFC credit card statement PDF to Excel: fastest methods for salaried people

Got an HDFC credit card PDF you cannot sort in Excel? Four routes from PDF to rows, with a month-end routine built for a salaried employee in a metro city.

Editorial illustration for HDFC credit card statement PDF to Excel: fastest methods for salaried people

What kind of PDF the HDFC credit card statement is decides the quickest route into Excel. If you can select the text with your cursor, Excel's own PDF import or a simple copy and Text to Columns will work. If the PDF is a scanned image, none of them will, and you need to download a fresh copy from your account instead.

Which kind of PDF do you actually have?

Open the file and try to highlight a transaction line. If it highlights word by word, it has a text layer and can be read by software. If it highlights as one block or not at all, it is an image. Statements downloaded from the bank are normally text. A photo or a scan sent by a family member is not. Your bank's statement may also be locked, and the file will ask you to enter a code your bank told you how to form. Open it yourself on your own device; do not feed it into an online converter just to save a minute.

What are the fastest routes, in order?

  1. Excel's built-in PDF import. In recent versions of Excel for Windows, the Data tab has a Get Data option under From File that can read a PDF and list the tables it finds. Check whether your version has it, because older versions and some Mac builds do not.
  2. Copy and paste. Select the transaction area in the PDF, paste into a blank sheet and use Data, then Text to Columns, to split the date, narration and amount apart.
  3. Google Sheets. Paste into a sheet and use Split text to columns. It copes with pasted text but not with images.
  4. A statement importer, where you upload the PDF, CSV or Excel file and review the parsed rows before saving.

Pick the first route that works. If rows arrive jumbled, the second route gives you more control.

How do you clean the result for a salaried month?

Take a typical office-goer's month. Say the statement has 38 rows, and four of them are really your company's costs: a client lunch of ₹2,400, a cab of ₹850, a work-trip hotel of ₹6,200 and a data card of ₹1,200. That ₹10,650 is reimbursable, so it should not drag down your personal totals. Add a column called Type, mark those four rows Office, and total personal spending with SUMIF.

  • Total of all rows: =SUM(D2:D40)
  • Reimbursable rows only: =SUMIF(E2:E40,"Office",D2:D40)
  • Personal spending: =SUM(D2:D40)-SUMIF(E2:E40,"Office",D2:D40)

If the statement total is ₹48,300, the personal figure is ₹48,300 minus ₹10,650, which is ₹37,650. Keep the claim form, receipts and the Office rows together so your finance team's questions take a minute, not an afternoon.

Why does the sheet show the wrong total?

  • Amounts imported as text. A number stuck to the left of the cell is text; use Text to Columns or multiply by 1 to convert.
  • Commas inside the figure. Remove them with Find and Replace if Excel keeps treating the value as text.
  • Credit entries read as debits. Payments and refunds should reduce spending, not add to it.
  • Page headers repeated. Delete the heading rows that the PDF prints at the top of each page.
  • Dates stored as text. Convert them before you filter by month.

Where does SpendixAI help, and where does it not?

SpendixAI takes the card PDF, CSV or Excel file, parses the rows and shows them to you before saving. You choose the card as the account first, and corrections become history, so next month's rows come in already categorised more often. It will not read your SMS and it does not connect to the bank, so you still download the statement each cycle. Do not assume every layout parses perfectly; the review step is there for that reason.

A five-minute routine after your statement is generated

  1. Download the PDF and save it as card-month-year.
  2. Convert it by the route that works for you.
  3. Mark office expenses.
  4. Check the total against the statement.
  5. Note any charge you do not recognise and look at it before the due date.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports