How to Convert a Bank Statement PDF to Excel (and Check the Numbers)
Turn a downloaded bank e-statement into an Excel sheet you can sort, total and budget with. Which statements convert well, how to handle password-protected PDFs, clean-up formulas for amounts and dates, and a running-balance check that catches any mis-read row.
By PDFEditPoint Editorial Team Published Last updated 7 min read
To convert a bank statement PDF to Excel, download the e-statement from your internet banking, open PDF to Excel, convert it and open the XLSX file. Then fix any amounts or dates stored as text and verify the rows with a running-balance formula. This works for text-based e-statements; scanned or photographed statements need OCR, which this method does not cover.
Step 0: check whether your statement can be converted
Two kinds of "bank statement PDF" exist, and they behave very differently:
- Text-based e-statements, downloaded from internet banking or a banking app, or received by email. The numbers are real text. These convert well.
- Scanned or photographed statements, such as a stamped paper copy you scanned. Each page is a picture. A converter cannot read numbers from a picture without OCR.
The quick test: open the PDF and try to select an amount with your mouse, or press Ctrl+F and search for a figure you can see. If it highlights, the statement is text-based. If nothing highlights, it is an image.
If the statement is password-protected
Banks often email statements as password-protected PDFs, with the password based on details such as your CNIC or date of birth. Converters cannot open an encrypted file; ours will ask you to use an unlocked copy. Because it is your own statement and you know the password, you can make an unlocked copy yourself:
- Open the PDF in Chrome or Edge and enter the password.
- Press
Ctrl+P(or Print), choose Save as PDF as the printer, and save. - Convert the saved copy, then delete it when you are done.
If the bank has restricted printing, this will not work; use the bank's CSV export instead. PDFEditPoint does not have an "unlock PDF" tool, and you should never try to remove protection from a document that is not yours.
How to convert the statement with PDFEditPoint
- Remove pages you do not need (optional). Cover letters, terms and promotional pages produce stray rows. Drop them with Delete PDF pages, which works in your browser. For a very long statement, Split PDF lets you convert a few months at a time.
- Open PDF to Excel and choose your statement. This tool runs on our server: the file travels over HTTPS and is deleted right after conversion. Statements up to 300 pages are accepted.
- Download the workbook (XLSX) and open it in Excel, Google Sheets or LibreOffice Calc.
What the converted file looks like
- Each page with a detected table becomes its own sheet, named Page 1, Page 2 and so on. If a page holds several tables, they are split into sheets such as Page 3 Table 2.
- Plain amounts such as
12,500.00or(1,200.00)become real numbers, with brackets turned into negatives. - Values with leading zeros, such as account or reference numbers, stay as text so the zeros are not lost.
- If a statement has no visible table lines, the converter falls back to reading each line of text and aligning it into columns. You may then need the clean-up steps below.
Put all pages into one table
For budgeting you want every transaction in one list. Two options:
- Any spreadsheet app: copy the rows from each page sheet and paste them under the first sheet's data. Then filter the date column and delete repeated header rows and "balance brought forward" lines.
- Excel 365 or Google Sheets: in a new sheet, stack the ranges with
=VSTACK('Page 1'!A2:F60, 'Page 2'!A2:F60, 'Page 3'!A2:F60), adjusting the ranges to your data. Wrap it inFILTERto drop blank rows if needed.
Clean up amounts and dates
Statements format numbers in many ways. The formulas below assume the value is in cell A2; adapt the cell references to your sheet. Note that SUBSTITUTE is case-sensitive, so match the exact text your bank uses.
| Problem | Example | Formula |
|---|---|---|
| Currency text attached | Rs 12,500.00 | =VALUE(SUBSTITUTE(SUBSTITUTE(A2,"Rs",""),",","")) |
| Dr/Cr suffix in one column | 1,250.00 Dr | =IF(RIGHT(TRIM(A2),2)="Dr",-1,1)*VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"Dr",""),"Cr",""),",","")) |
| Date stored as text (day first) | 05/11/2026 | =DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2)) |
| Spaces around numbers | " 3,000.00 " | =VALUE(SUBSTITUTE(TRIM(A2),",","")) |
For dates, Excel's Data → Text to Columns → Date: DMY is also quick, and it avoids the month and day being swapped, which is common when a Pakistani or UK statement is opened with US date settings.
Long descriptions sometimes wrap onto a second row with empty amount cells. Join the text into the row above, or delete the extra row once you have read it.
Check the numbers (do not skip this)
Any automatic conversion can occasionally put a value in the neighbouring column, especially around merged cells or page breaks. A running-balance check catches every such row in seconds.
Assume your combined table has these columns: A date, B description, C debit (withdrawal), D credit (deposit), E balance as printed on the statement.
- In F3 calculate the expected balance:
=E2-C3+D3 - In G3 compare it with the printed balance:
=ROUND(F3-E3,2) - Fill both formulas down to the last row.
Every row in column G should show 0. A non-zero value points to the exact row that was mis-read, so you can fix it against the PDF. Then confirm the totals:
=SUM(C:C)and=SUM(D:D)should match the statement summary's total debits and credits.- Opening balance minus total debits plus total credits should equal the closing balance.
Make the spreadsheet useful: categorise your spending
Once the numbers check out, add a column H called Category and label each row: groceries, fuel, utilities, school fees, transfers, salary and so on. Descriptions repeat every month, so filtering by a word such as an electricity company's name and filling the category for all matching rows takes seconds.
Then total each category with =SUMIFS(C:C, H:H, "Groceries"), or select the table and insert a PivotTable with Category as rows and Debit as values. To see a single month, add a month column with =TEXT(A2,"yyyy-mm") and use it as a pivot filter. This is the part that makes converting worthwhile: a year of statements becomes a clear picture of where your money goes, ready for a household budget or your tax records.
Common problems and fixes
| What you see | Likely cause | Fix |
|---|---|---|
| "No text found" or an empty workbook | Scanned or photographed statement | Download the e-statement again from internet banking, or ask for CSV |
| Password error | Encrypted statement | Save an unlocked copy as described above |
| Whole lines in one column | No table lines on the statement | Data → Text to Columns, split by spaces or fixed width |
| SUM ignores some amounts | Numbers stored as text | Use the VALUE/SUBSTITUTE formulas |
| Non-zero values in the check column | Value shifted to the wrong column | Correct that row against the PDF |
| Day and month swapped | US date settings | Text to Columns with DMY, or the DATE formula |
Privacy: what happens to your statement
A bank statement is one of the most sensitive files you own, so here is exactly what happens. PDF to Excel is one of the few PDFEditPoint tools that needs our server. The PDF is uploaded over an encrypted connection, converted by our own software and deleted immediately after the conversion; if a conversion fails, an automatic clean-up removes leftovers within one hour. We do not read, keep or share it. Our guide are online PDF tools safe? explains how to verify claims like this yourself.
After converting:
- Delete the unlocked copy of the statement if you made one.
- Protect the spreadsheet in Excel with File → Info → Protect Workbook → Encrypt with Password before storing or sharing it.
- If you have to email a statement PDF, encrypt it first with Protect PDF and send the password separately; see how to password protect a PDF.
Remember that the spreadsheet is for your own analysis. When a visa office, landlord or lender asks for a statement, send the bank's original PDF, not the Excel file.
Frequently asked questions
Can I convert a scanned bank statement to Excel?
Not with PDF to Excel alone. A scanned or photographed statement is a picture of text, so there are no numbers for a converter to read; that needs OCR software, which PDFEditPoint does not offer. The better route is to download the e-statement again from internet banking, where it is usually a text PDF, or ask the bank for a CSV or Excel export.
Why are my amounts not adding up in Excel?
Usually because some amounts are stored as text, for example values with "Rs", "Dr" or "Cr" attached, so SUM ignores them. Select the column and look for left-aligned numbers or a green warning triangle. Convert them with a VALUE and SUBSTITUTE formula, then repeat the total. A running-balance check will show any row that was read into the wrong column.
Is it safe to upload my bank statement to convert it?
With PDFEditPoint, the statement is sent over HTTPS to our server, converted and deleted immediately afterwards; leftovers from a failed job are removed within one hour. We do not read or keep it. If you prefer that a statement never leaves your device, use your bank's own CSV or Excel export, or copy the table from the PDF manually.
Can I submit the Excel file instead of the PDF statement for a visa or loan?
No. Embassies, banks and lenders want the statement as issued by your bank, usually the original PDF or a stamped paper copy, because an Excel file can be edited by anyone. Use the spreadsheet for your own budgeting, tax records and checking, and submit the original statement wherever proof is required.
Does Google Sheets open the converted file?
Yes. The download is a standard XLSX workbook, so you can open it in Microsoft Excel, upload it to Google Drive and open it with Google Sheets, or use LibreOffice Calc. Formulas in this guide work in all three, except VSTACK, which needs a current version of Excel or Google Sheets.