To get a Punjab National Bank statement from PDF into Excel, first check whether the PDF is real text or a scan. Real text can be copied or converted into columns; a scan cannot. After the data is in, remove header and page-total rows and prove the result by checking that opening balance plus credits minus debits equals the closing balance. We have not assumed Punjab National Bank's exact column order, so adjust the column letters below to your file.
Is my PDF text or a picture?
Click into the PDF and try to select a single word. If you can highlight and copy individual lines, it is text. If the whole page highlights as a block, or nothing selects, it is an image and no spreadsheet trick will read it reliably. In that case, ask for a CSV or Excel download of the same period from your own net banking, or request a fresh e-statement.
Should I copy and paste, or convert?
- Copy and paste: quick for one or two pages. Paste into cell A1 of a blank sheet; each line usually lands in one cell and needs splitting.
- Excel's own import: newer Excel versions have Data, Get Data, From File, From PDF, which reads tables page by page. Check that your version has it; older ones do not.
- Bank-provided CSV or Excel: skips the whole problem and is the best option when it exists.
Avoid free online converters. A statement lists your balances and payees, and you do not need to hand that to a stranger's server.
How do I split pasted lines into columns?
- Select the pasted column of text.
- Go to Data, then Text to Columns.
- Choose Delimited if the fields are separated by spaces, tabs or commas, or Fixed width if they line up in neat columns.
- On the last screen, set the date column format to DMY so that 03/04/2026 means 3 April, not 4 March.
- Finish, then widen the columns and look at ten rows against the PDF.
What if the narration has spaces in it?
Splitting by space cuts a narration into many cells. Use Fixed width if the PDF is aligned, or split only on tabs. If a narration spills across several cells, join it again with a formula such as =B2&" "&C2&" "&D2 and then paste the result as values.
How do I remove the junk rows?
Statements repeat column headings on every page and may end each page with a subtotal. Add a helper column to flag what to keep. If column A holds real dates, this works:
=IF(ISNUMBER(A2),"keep","delete")
Filter the helper column for delete, select the visible rows, delete them, then clear the filter. If column A is still text, the formula flags every row, which tells you the dates need converting first.
How do I prove the sheet matches the statement?
Put the opening balance in H1, total debits in column D and total credits in column E, then calculate the expected closing balance in H2:
=H1+SUM($E$2:$E$500)-SUM($D$2:$D$500)
Say the opening balance is ₹36,000, credits total ₹70,000 and debits total ₹58,250. The formula gives 36,000 + 70,000 − 58,250 = ₹47,750. If the PDF's closing balance is ₹47,750 you are done. A difference means a missing or doubled row, and the difference itself is the number to search for.
When does the sheet stop being worth it?
A sheet is fine for one statement. Repeating this cleaning every month is where people give up. When that happens, an expense tracker such as SpendixAI can take the PDF, CSV or Excel statement directly, show the rows for review before saving, and keep the account on each transaction.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


