How to Convert a PDF Bank Statement to Excel or CSV
This guide shows how to turn the PDF statement your bank gives you into a spreadsheet, and how to make sure every number in it is right. It is useful for bookkeepers, accountants, freelancers doing their taxes, and anyone who must send their transactions as a spreadsheet for a loan, a mortgage or a visa.
Download the statement from your bank
Use the PDF from your online banking, not a scan or a photo. A downloaded PDF contains real text that can be read exactly. A scan is only a picture of text, and this tool will tell you it cannot read it rather than guess.
Open the converter
Go to the Bank Statement to Excel Converter and drop in your statement. You can add up to twelve statements at once, for example a full year of monthly statements. Nothing is uploaded: the files are read in your browser.
Enter the password if the PDF is locked
Many banks protect statements with a password, often your date of birth or part of your account number. The email from your bank usually says which. Type it when the tool asks. It is used only in your browser tab to open the file.
Preview the transactions for free
Press Preview & Convert. You will see the opening balance, money in, money out and the closing balance, and below them every transaction in a table. Previewing costs nothing.
Check the balance verdict
The tool recalculates each running balance from the one before it. If everything adds up, you will see that the balances add up to the cent. If a row is shown in red, its balance does not follow from the rows above it. Click the figure that looks wrong and correct it, or remove a row that is not a real transaction. The check runs again as you type.
Choose your format and download
Pick how dates should look and whether you want separate money-out and money-in columns or one signed amount column. Choose XLSX for Excel, or CSV for other software. If your Excel uses a comma for decimals (French, German or Spanish settings), choose the semicolon CSV, or simply use the XLSX. One payment covers both formats from the same conversion.
Before you send a converted statement to anyone, look for the green "balances add up" message. It is your proof that no figure was misread.
Tools for this
Bank Statement to Excel Converter
NewConvert PDF bank statements to Excel and CSV, with every running Balance checked to the cent, even Password-protected ones.
- Sensitive Info RemoverAutomatically find and permanently remove sensitive data in PDFs, scans and images — card numbers, bank and routing numbers, SSNs, Canadian SINs, UK NI and NHS numbers, Australian TFNs, medical IDs, dates of birth and faces — by overwriting the raw pixels, not just masking them. Local OCR reads scans, the redacted PDF stays searchable, presets cover HIPAA, UK GDPR, PIPEDA and FRCP 5.2, and up to 20 files run at once.
- AI Document AnonymizerAnonymize documents before you paste them into ChatGPT, Claude or Gemini: names, companies, addresses, account numbers and IDs become consistent placeholders like [PERSON_01] across Word, Excel, PDF and pasted text, with formatting kept. Review every hit, use HIPAA, GDPR or legal presets, then Restore the AI's answer with your key. Nothing is uploaded.
