How to convert a bank statement PDF to Excel
From a statement you can only read to a sheet you can sort, total and budget with — without handing it to a stranger's server
By Metin Ersoy · Updated November 3, 2026
Why a statement is worth having in Excel
A bank statement PDF is fine for reading, but it cannot answer the questions people actually have: how much went on groceries last month, which subscriptions keep renewing, what the rent and bills add up to over a year. In a spreadsheet those are a few clicks. Statements are also what landlords, accountants and visa or loan applications ask about, and having the lines in Excel makes it easy to pick out the payments they want to see.
Copying from the PDF rarely works: every line lands in one cell, or the date, description and amount end up on separate rows. The PDF to Excel tool reads where each value sits on the page and puts every column into its own cell, with the amounts as real numbers.
Step by step
- Download the statement as PDF from your online banking. Choose the PDF that the bank generates, not a photo or a printout that was scanned — a generated PDF contains real text.
- Remove the password if there is one. Many banks lock e-statements. Open the file with its password in Unlock PDF and save the unlocked copy.
- Open PDF to Excel and choose the file.
- Pick the layout. For one month, "Put each page on its own sheet" is fine. To analyse the whole statement in one go, untick it so every page lands on a single sheet. Tick "Tables only" if you do not want the bank's address, notices and small print in column A.
- Convert and download the .xlsx file, then open it in Excel, LibreOffice Calc, Google Sheets or Numbers.
Tidying the sheet in five minutes
Repeated headers. Each page of a statement starts with its own "Date · Description · Amount · Balance" row. On a single sheet they appear every few dozen lines. Turn on a filter (Data → Filter), filter the date column for the header text, delete those rows, and clear the filter.
Descriptions on two lines. A long payment description often wraps onto a second line in the PDF. The converter recognises such a line — date and amount empty, text right under the description above — and adds it to that cell. If a statement prints the date and amount next to the second line instead of the first, a half-empty row can still slip through: sort a copy of the sheet by the amount column to gather these rows, move their text up if you need it, and delete them.
Debit and credit in separate columns. Some banks show money out and money in as two columns; others use one column with a minus sign. If you have two columns, add a new column with =C2-D2 (credit minus debit, adjusted to your column letters) so every line has one signed amount you can total.
Amounts that stay as text. Values written like 125.00 DR or 1,250.00 CR keep their letters and therefore stay text. Use Find & Replace to remove DR and CR (after noting which is which), and the cells turn into numbers. The tool already converts brackets and minus signs into negative numbers.
Check the result against the statement. Add up the money in and the money out and compare them with the totals printed on the statement, or check that the last balance on the sheet matches the closing balance. If they agree, nothing was lost.
Totalling spending by category
- Add a column called Category next to the description.
- Fill it in for each line — groceries, rent, transport, subscriptions. Sorting by description first groups repeated payees, so you can fill several rows at once.
- Select the table and insert a PivotTable (in Google Sheets: Insert → Pivot table). Put Category in rows and the amount in values.
You now have a monthly budget built from real payments. For a whole year, merge the monthly statements first (see below) and add a Month column with =TEXT(A2,"yyyy-mm") if the dates came through as dates, or by typing the month if they stayed as text.
A year of statements in one sheet
Banks usually send one PDF per month. Combine them into one file with Merge PDF in date order, then convert the merged file with "Put each page on its own sheet" unticked. Remove the repeated headers as described above and you have the whole year in one table, ready for a pivot.
Sharing a statement with someone else
Landlords and accountants sometimes need to see a statement but not every payment on it. Before you send the PDF, black out the lines they do not need with Redact PDF — it removes the text itself, not just covers it. If they only need a few months, send just those pages with Extract PDF pages.
Why converting in the browser matters here
A bank statement holds your full name, address, account number and a record of where you spend money. Most PDF to Excel sites upload the file to process it, so all of that sits on a server you know nothing about. PDFVela converts the statement on your own device: the file is not sent anywhere, and it is cleared from memory when you close the tab. For other kinds of tables, see how to copy a table from a PDF to Excel.
Ready to try it? It is free and your file stays on your device.
Open PDF to Excel