You need your transactions in a spreadsheet: for a budget, your taxes, a loan application or your accountant. The bank gave you a PDF. Here is how to get the table out of it and make sure nothing got lost on the way.
What to do
- Look for an export in online banking. If your bank offers a CSV or Excel download of transactions, use it. It is exact and needs no conversion.
- Otherwise, download the PDF statement. Use the PDF from online banking rather than a photo of a paper statement. It has real text and converts cleanly.
- Convert it. Upload the PDF to the bank statement to Excel converter, click Extract Tables and then Export to Excel.
- Check the totals. See the check below. It takes two minutes.
Upload a PDF and download its tables as Excel or CSV.
Convert your statementConverting a PDF bank statement to Excel
Most statements have the same columns: date, description, amount (or separate debit and credit columns) and balance. When the converter can read the statement and the balances add up, you get one table with one row per transaction: date, description, signed amount and balance. Otherwise you get the tables as they are in the PDF.
Statements with several pages
A statement that reads cleanly comes out as one list, however many pages it has. If it does not, each page can land on its own sheet, so a 5-page statement gives you about 5 sheets in the Excel file. To get one list, copy the rows of each sheet under the first one and delete the repeated header rows. The CSV export puts all tables in one file one after another, which can be quicker to merge.
Scanned or photographed statements
A scan is a picture without text. The tool recognizes the text first (OCR) and then finds the table, but scans do not get the clean one-list result, so expect some cleanup. If the page is skewed or blurry, use deep extraction: it reads the page like a person does, and you see the result for one page before paying for the file.
Check that every transaction is there
A missing row is easy to overlook. This check finds it:
- Find the opening balance and the closing balance on the statement.
- In Excel, sum the amount column. With separate columns, sum credits and subtract debits.
- Opening balance plus that sum should equal the closing balance, to the cent.
If it does not match, compare the number of rows per page with the PDF. Lines that wrap onto two rows, like long descriptions, are the usual suspect.
When CSV is better than Excel
Bookkeeping and budgeting apps usually import CSV files. Export to CSV instead and import that file. Our CSV uses semicolons between columns; most import screens let you pick the separator. More on this in the PDF to CSV guide.
Keep your data private
- No account is needed, and uploaded files are deleted automatically after 24 hours.
- AI features send pages to Anthropic, and the free preview can send one page on its own. See the privacy policy.
- Delete the downloaded spreadsheet from shared folders when you are done.
Other tables to move? Read how to copy a table from PDF to Excel.
Extract tables from your Chrome toolbar
Click the extension icon, pick a PDF and get the tables without opening this site.
Questions and answers
How do I convert a bank statement PDF to Excel?+
Upload the PDF statement to our bank statement converter, click Extract Tables, then Export to Excel. Check that the opening balance plus all transactions equals the closing balance.
Can I download my bank statement as Excel instead of PDF?+
Many banks let you export transactions as CSV or Excel in online banking, often under Download or Export next to the transaction list. This export usually covers a limited time range, so older statements may only exist as PDF.
Can I convert a scanned bank statement to Excel?+
Yes. If the statement is a scan or a photo, Extract Table from PDF runs text recognition (OCR) before it looks for the table. For a photo taken at an angle, deep extraction gives cleaner results.
Why are my transactions split into several tables?+
This happens when the converter cannot read the statement as one list, for example with a scan or when the balances do not add up. You then get the tables as they are in the PDF. In Excel, copy the rows from each sheet under each other, or use the CSV export, which puts all tables in one file.
Is it safe to upload a bank statement?+
Extract Table from PDF needs no account and deletes uploaded files automatically after 24 hours. Files are uploaded to our servers, and AI features send pages to Anthropic, so upload only what you are allowed to share. The privacy policy has the details.