Bank statements

Indian Bank statement PDF to Excel: convert and tidy it

Indian Bank statement PDF to Excel: practical steps to convert, correct dates and amounts, drop extra rows and tie the result to the closing balance.

Editorial illustration for Indian Bank statement PDF to Excel: convert and tidy it

Converting an Indian Bank statement from PDF to Excel is a three-part job: get the table out of the PDF, make dates and amounts into real numbers, and remove the rows that are not transactions. Do the last step carefully, then add the credits and debits and compare them with the closing balance on the statement. If you can get a CSV or Excel file from the bank instead, use that and skip the first part.

Should you copy or convert?

Copying text out of a PDF viewer is quick, but it often drops every field into a single column or loses the spacing between columns. Converting with a tool that reads tables keeps the grid more often, though it can still split one long narration over two lines. Try copy first for a short statement. For a long one, try a table-aware conversion.

  • Your Excel may have a Get Data option that can read PDF files. If it is present, it shows a preview of tables on each page; pick the one with the transactions.
  • Google Sheets has no built-in PDF reader, so people usually convert the file elsewhere and then upload the spreadsheet.
  • If the PDF has a password, open it with the password you were given for your own statement, then save an unlocked copy for yourself.

How do you fix the dates?

If a date arrives as text such as 14-06-2025, and your sheet does not read it as a date, split it yourself. With the text in A2, =DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2)) builds a proper date. It assumes day, month and year with two-character separators; look at your own file before using it. Copy the column and paste as values to remove the formulas.

How do you turn text amounts into numbers?

When amounts include commas they stay as text. In C2, =VALUE(SUBSTITUTE(B2,",","")) removes the commas and converts. If the bank prints separate Debit and Credit columns, empty cells can be treated as zero with =N(C2), which returns 0 for blank or text and the number otherwise.

Which rows do not belong?

  1. Repeated column headings at the top of every page.
  2. Page numbers and footers.
  3. Opening balance and closing balance lines. Write them down first.
  4. Any running-balance column, once it has helped you verify.

To find the junk, add =ISNUMBER(A2) beside the date column and filter for FALSE. Check the filtered rows by eye before deleting, because a long narration that wrapped to a second line can look like junk but belongs with the transaction above it. Join wrapped lines with =A2&" "&A3 if needed.

Make the columns ready for next time

Format the date column as DD-MMM-YYYY, the amounts with two decimals, and freeze the top row. Add an Account column and fill it with the same words down every row, such as Indian Bank savings. If you later combine several months or several accounts into one sheet, that column tells you where each row came from, and it matches how a tracker stores each transaction against its account.

Does the cleaned table add up?

Total the credits and debits and compare with the statement. With made-up numbers: opening balance ₹9,750, credits ₹30,000, debits ₹27,400. Then 9,750 + 30,000 - 27,400 = ₹12,350. If the closing balance is ₹12,350, the table is complete. If it is short, count the rows against the printed page count and look for a page that did not convert.

A quick formula for the net change is =SUM($D$2:$D$400)-SUM($E$2:$E$400), where D holds credits and E holds debits.

When should you stop doing this by hand?

If you do this for one account once, a sheet is perfect. If it becomes a monthly chore across several accounts, SpendixAI accepts PDF, CSV and Excel statements directly, shows the rows for review and keeps the account with each transaction. That removes the cleaning work, though you still verify the closing balance.

SPENDIXAI JOURNAL

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

Explore your reports