Bank statements

HDFC card statement PDF to Excel for a student on a small limit

A student on an HDFC credit card can turn the statement PDF into a simple sheet, spot subscriptions and see where pocket money disappears before the bill is due.

Editorial illustration for HDFC card statement PDF to Excel for a student on a small limit

A quick look at where the money went before the due date matters more than a perfect spreadsheet on a student credit card with a modest limit. Copy the text from the PDF into a sheet, split it into date, description and amount, and add one category column. Ten minutes gives you enough to change next month.

Why bother converting a PDF at all?

A statement PDF is built to be read once and filed. You cannot sort it, add it up by category or see that four small subscriptions cost more than one big dinner. In a spreadsheet you can. For a student, the first useful finding is usually small and slightly embarrassing, and it is usually food delivery and streaming.

A quick method that needs only a phone and a laptop

  1. Download the statement and open it on a computer. Confirm you can select text.
  2. Copy the table of transactions and paste it into a new sheet in Google Sheets or Excel.
  3. Split the pasted text into columns. In Sheets use Data, then Split text to columns. In Excel use Data, then Text to Columns.
  4. Keep three columns: date, description, amount. Add a fourth called Category.
  5. Fill the Category column with a short list: Food, Travel, Subscriptions, Books, Fun, Other.

Keep your own category list short. Six categories you will actually use beat twenty you abandon.

What does one month on a small limit look like?

Say the card limit is ₹25,000 and the statement shows ₹14,600 of spending. A quick category total might read: Food delivery ₹4,800, Subscriptions ₹1,350, Travel ₹3,100, Books and course fees ₹2,650, Fun ₹2,700. Add them and you get ₹14,600, which confirms nothing is missing. The card used up 58 percent of its limit, because 14,600 divided by 25,000 is 0.584. That ratio matters because a card used near its limit leaves no room for an emergency.

CategoryAmountShare of ₹14,600
Food delivery₹4,800about 33 percent
Travel₹3,100about 21 percent
Fun₹2,700about 18 percent
Books and course fees₹2,650about 18 percent
Subscriptions₹1,350about 9 percent

Use =SUMIF(D2:D50,"Subscriptions",C2:C50) to get each total from the sheet.

How do you spot the leaks?

  • Sort by description and look for the same merchant on several dates.
  • Look for a charge that repeats on the same day each month; it is probably a subscription.
  • Look for a free trial that quietly became a paid plan.
  • Look for a fee line you do not recognise and check it against your card terms rather than guessing.

Can an app take the typing out?

SpendixAI imports a card statement PDF, CSV or Excel file, parses the rows and lets you review them before saving. You pick the card as the account first, and the default categories are applied, which you can change. The Free plan covers statement import, default categories and the dashboard, so a student can try it before paying for anything. It does not read SMS or connect to the bank, so each month's statement still has to be uploaded.

Next steps for next month

  • Set a personal ceiling below the card's limit, such as ₹10,000, and see how close the statement gets.
  • Cancel one subscription you have not used.
  • Pay the full statement amount if you can, rather than carrying a balance, and check your card terms for what a carried balance costs.
SPENDIXAI JOURNAL

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

Explore your reports