Bank statements

Bandhan Bank statement PDF to Excel: convert and tidy it

Bandhan Bank statement PDF to Excel: handle locked and scanned PDFs, move the table into a sheet and run four quick checks before you trust it.

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

To turn a Bandhan Bank statement PDF into an Excel sheet, first work out what kind of PDF you have. A text PDF can be pasted or imported, a locked PDF must be opened in your own viewer, and a scanned image of a statement cannot be converted reliably at all. Ask for CSV or Excel from the bank whenever possible.

What kind of PDF is it?

TypeHow to tellWhat to do
Text PDFYou can select and copy a line of wordsPaste or import into a sheet
Locked PDFIt asks for a password before openingOpen it in your own viewer first, then continue
Scanned PDFSelecting text does not work; it behaves like a pictureDownload a fresh CSV or Excel copy instead

What if it asks for a password?

The bank's email or download page normally explains how the lock is set, so read that note rather than guessing. Open the file in a PDF viewer on your own device. Be wary of websites that promise to unlock or convert statements, because your account history goes to their server. If you are not sure, leave it locked and request an unlocked CSV or Excel version of the same period from your own net banking.

What if it is a scanned picture?

A picture of a table has no cells to copy, so a converter must guess each character from the image. Small errors in an amount can pass unnoticed. We cannot say whether any Bandhan Bank file you hold is scanned, but if copy-paste gives you nothing, download CSV or Excel from the bank and avoid the guesswork.

How do you get a text PDF into a sheet?

  1. Select the table in the viewer, copy, and paste into cell A1 of a new sheet.
  2. If everything lands in one column, use Text to Columns in Excel, or Split text to columns in Google Sheets.
  3. In Excel 365 you can also use Data, Get Data, From File, From PDF.
  4. Keep a copy of the untouched PDF for reference.

We do not know the column order of Bandhan Bank's statements, so look at your own and adjust the columns in the checks below.

Which four checks tell you the sheet is complete?

Say debits are in D and credits in E, and the statement shows an opening balance of ₹26,300 and a closing balance of ₹31,050.

CheckFormulaResult in this example
Number of transactions=COUNTA($A$2:$A$500)Matches the count you expect
Total debits=SUM($D$2:$D$500)₹19,250
Total credits=SUM($E$2:$E$500)₹24,000
Closing balance=26300+SUM($E$2:$E$500)-SUM($D$2:$D$500)₹31,050

Check the arithmetic: 26,300 plus 24,000 is 50,300, minus 19,250 is 31,050. If the formula result matches the statement's closing balance, all rows are present.

Is there anything to fix in the dates?

Often, yes. If 08/12/2025 shows as the twelfth of August when you meant the eighth of December, the sheet's locale is reading month first. For text dates, =DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2)) builds the correct date. Sort the column and confirm that the dates run in order.

When does it make sense to stop using the sheet?

If you repeat this each month, a tool built for the job saves time. SpendixAI accepts PDF, CSV and Excel, shows the rows for review before saving, and keeps a history of each import. The sheet remains useful for questions the app does not answer.

Last steps

  • Delete helper columns after pasting values.
  • Save the file with the bank and the month in its name.
  • Store the original PDF alongside it.
SPENDIXAI JOURNAL

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

Explore your reports