PDFVela — pdfvela.com

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 · 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

  1. 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.
  2. 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.
  3. Open PDF to Excel and choose the file.
  4. 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.
  5. 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

  1. Add a column called Category next to the description.
  2. 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.
  3. 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

Questions about bank statements and Excel

Is it safe to convert a bank statement online?

It depends on where the file goes. Most converters upload it to their servers, which means your name, account number and every payment you made sit on someone else's computer for a while. PDFVela's PDF to Excel runs inside your browser, so the statement never leaves your device.

My statement PDF asks for a password. What do I do?

Many banks protect e-statements with a password such as part of your ID or date of birth. Open it once with that password in Unlock PDF to save a copy without the lock, then convert the copy. Unlock only works when you know the password.

Can I put twelve monthly statements into one sheet?

Yes. Merge the twelve PDFs into one with Merge PDF, then convert it with "Put each page on its own sheet" unticked. All pages are written one under another; delete the repeated header rows afterwards.

Why are some amounts not adding up?

Amounts that stayed as text are usually ones with an extra letter, such as CR or DR after the number, or an unusual symbol. Remove the letters with Find & Replace and Excel will treat them as numbers again.

My bank sent a scanned or photographed statement. Will it work?

Only after OCR. A scan contains no text, just a picture. Run it through OCR PDF first, then convert the searchable copy, and check the totals against the statement because OCR can misread a digit.

Can my bank give me the statement as Excel or CSV directly?

Often, yes — many online banking apps offer a CSV or Excel export for the account history. If yours does, that is the cleanest source. The PDF route is for when you only have the PDF, for older periods, or for statements from a bank that does not offer an export.