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?
| Type | How to tell | What to do |
|---|---|---|
| Text PDF | You can select and copy a line of words | Paste or import into a sheet |
| Locked PDF | It asks for a password before opening | Open it in your own viewer first, then continue |
| Scanned PDF | Selecting text does not work; it behaves like a picture | Download 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?
- Select the table in the viewer, copy, and paste into cell A1 of a new sheet.
- If everything lands in one column, use Text to Columns in Excel, or Split text to columns in Google Sheets.
- In Excel 365 you can also use Data, Get Data, From File, From PDF.
- 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.
| Check | Formula | Result 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

