Skip to content

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 Published Last updated 7 min read

Bank statement PDF next to the same transactions in an Excel spreadsheet with a balance check column

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.

Tools in this guide