Bank statements

IDBI Bank statement PDF to Excel: convert and tidy it

IDBI Bank statement PDF to Excel: how to convert it, split debits and credits, remove stray rows and check the result against the closing balance.

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

To turn an IDBI Bank statement PDF into an Excel table, first see whether the bank offers a CSV or Excel download, because that skips conversion altogether. If you only have the PDF, convert it, then clean the result: fix the dates, split money out from money in, delete header and balance rows, and finally compare the totals with the closing balance on the statement.

Is a CSV or Excel download available first?

Check the statement or e-statement area of your own net banking for a file format choice before you touch the PDF. A native file avoids the broken columns that PDF conversion sometimes creates. I cannot say what columns IDBI Bank puts in a file or in what order, so look at the header row yourself before writing any formula.

How do you convert the PDF?

  • If it asks for a password when opened, use the one given by the bank for your own statement; the instructions that came with the file usually say what it is. Do not share the file or the password with a stranger offering conversion.
  • In recent Excel for Windows, Data, Get Data, From File, From PDF can read tables if your version has it. Check what your version offers.
  • Copy and paste from the PDF viewer is the fallback. It often lands everything in one column, so plan to split it.
  • Online converters upload your statement to somebody else's server; think before using one for a document full of personal transactions.

Whichever route you take, paste the result into a fresh sheet and leave the original untouched, so you can always start again.

How do you fix dates and amounts?

Dates often arrive as text. If A2 holds text like 05/04/2025 in day/month/year order and your sheet reads it the wrong way round, build a real date with =DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2)). Fill it down, copy, and paste as values.

Amounts with commas are text too. =VALUE(SUBSTITUTE(C2,",","")) turns 1,250.50 into a number. If a single column holds figures followed by Dr or Cr, use =VALUE(SUBSTITUTE(TRIM(LEFT(D2,LEN(D2)-2)),",","")) for the number and =RIGHT(D2,2) for the marker.

How do you split debit and credit?

Many trackers prefer one signed amount, others want two columns. If you hold the number in E2 and the Dr or Cr marker in F2, then =IF(F2="Dr",E2,0) gives the debit and =IF(F2="Cr",E2,0) gives the credit. For a signed amount use =IF(F2="Dr",-E2,E2).

What rows should you delete?

  • Repeated header rows at the top of every PDF page.
  • Page footers and totals printed on each page.
  • Opening and closing balance lines, which you note separately.
  • Running balance column, once you have used it to check the result.

A helper column helps. In G2 type =ISNUMBER(A2) after the dates are real dates, then filter for FALSE and delete those rows. Delete only after you have noted the opening and closing balances.

What about Google Sheets?

The same formulas work in Google Sheets. Sheets also has SPLIT, so =SPLIT(A2," ") breaks a pasted line into pieces at each space, and Excel 365 has a similar TEXTSPLIT. Neither is available in older Excel versions, so check yours before relying on it. In either app, keep a copy of the raw paste on a separate tab and do your cleaning on a second tab.

How do you verify the clean table?

Add up the credits and debits and compare. With invented numbers, opening balance ₹18,400, credits ₹46,000 and debits ₹39,250 give 18,400 + 46,000 - 39,250 = ₹25,150. If your statement's closing balance is the same, nothing was lost. With a table of a few hundred rows, =SUM($G$2:$G$500) and =SUM($H$2:$H$500) give the totals.

SPENDIXAI JOURNAL

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

Explore your reports