Skip to content

Home › Guides

How to convert a bank statement PDF to Excel: 4 methods compared

Published 19 November 2026 · by Relevé Clair

There are four ways to turn a bank statement PDF into an Excel table: copy and paste, Excel’s built-in PDF import, an online converter, or a tool that works inside your browser without uploading the file. The first two are free but need cleaning up; the last two are fast, and only the in-browser one keeps the statement on your computer.

Convert a statement without uploading it

Method 1: copy and paste

Select the table in the PDF, paste it into Excel. It is free and instant, but the result is rarely usable as it is: depending on the PDF, a whole line lands in a single cell, the money-out and money-in columns get mixed up, and descriptions split over two lines create extra rows.

Amounts are the second problem. Pasted figures often arrive as text, with stray spaces or currency signs, so SUM returns zero. You then need SUBSTITUTE to remove the extra characters and VALUE to turn the text into numbers — on every statement.

Method 2: Excel’s PDF import

Recent versions of Excel for Windows (Microsoft 365) can read a PDF: Data tab, Get Data, From File, From PDF. Excel lists the tables it found, page by page, and loads them through Power Query.

It is the best free method if you are comfortable with Power Query. Its limits on a bank statement: each page is a separate table to combine, repeated headers and balance lines stay in the data, and descriptions split across lines remain split.

Method 3: an online converter

You upload the PDF to a website and get an Excel file back. It is quick, and some services also read scanned statements. The point to look at is not the quality, it is where the file goes: your statement — or your client’s — is copied to someone else’s server. Before using one, read where files are stored, for how long, and who can access them. Our guide on online converter safety lists the questions to ask.

Method 4: a tool that works in the browser

This is how Relevé Clair works: the conversion program loads with the page, then the PDF is read on your computer. Nothing is uploaded. You can check by cutting your connection before dropping the file: the conversion still works.

Current limit: only original PDFs (downloaded from online banking) are read. A scanned paper statement is an image, and that case is not supported yet.

Which one to choose

MethodCostDoes the file leave your computer?Work left to do
Copy and pasteFreeNoA lot: columns, amounts, dates
Excel PDF importIncluded in Excel 365NoMedium: combine pages, clean up
Online converterFree to paidYesLow to medium
In-browser toolFree during the betaNoLow: check the balance banner

Whatever the method: check the balances

A conversion is only useful if nothing was lost on the way. The simple test: opening balance + total money in − total money out must equal the closing balance printed on the statement. In Excel, with money in in column F and money out in column E: =opening + SUM(F:F) - SUM(E:E). If the result differs from the statement’s closing balance, a line was dropped or misread.

Watch out for dates

UK and Irish statements write day/month, US statements month/day. If your Excel is set to the other convention, 03/04 silently becomes the wrong date and sorting breaks. Two safe options: keep real Excel dates (not text), or use ISO dates (2026-04-03) in CSV files, which no software can misread.

Frequently asked questions

Can Excel open a PDF bank statement directly?

Excel for Microsoft 365 on Windows can import tables from a PDF (Data › Get Data › From File › From PDF). Each page comes in as a separate table, so you still need to combine pages and remove balance lines and repeated headers.

Why does SUM return 0 on my pasted statement?

The amounts were pasted as text, often because of spaces, currency signs or a different decimal separator. Clean them with SUBSTITUTE, then convert with VALUE, or use a converter that outputs real numbers.

Is it safe to upload a bank statement to a converter?

It depends on the service: the file is copied to its server. Check where it is stored, for how long and who can access it, or use a tool that converts in your browser without uploading.

Read next

Try Relevé Clair for free   For accountants