Convert a PDF bank statement to Excel without uploading

---

You have twelve months of statements and you need the transactions in a spreadsheet. Search for how to get a PDF bank statement to Excel and the first thing you are offered is an upload box.

Stop there for a second. A bank statement carries your account number, your sort code, your address, your balance and a list of everywhere you spent money. It is close to the most sensitive single document most people own, and the question of where the conversion runs matters more here than for any other file you will convert this year.

Why "just upload it" is the wrong default here

Online converters are not automatically villains. They are, however, a third party receiving a document you would not email to a stranger, and three things follow from that:

• Retention. Many free services keep uploaded files for a period after conversion. Some say so in the privacy policy, some do not say much at all.
• Policy. If you are a bookkeeper or an accountant, your client's data agreement may simply forbid it. "I used a free website" is not a defence.
• Scale. One statement is one exposure. Twelve months for four accounts is forty-eight.

We wrote about the general version of this in is it safe to upload a PDF to an online converter. Statements are the case where the answer stops being a judgement call.

First, work out which kind of PDF you have

This one check decides which method will work, and skipping it is why people end up with an empty spreadsheet and no idea why.

1. Open the statement in any PDF reader

   Edge, Acrobat Reader, whatever you already have.

2. Press Ctrl+F and search for a number you can see

   Pick an amount from the middle of the page — say 24.99.

3. Read the result

   Found it? The PDF contains real text and converts directly. Nothing found? Your statement is a picture of a statement, and no converter can read it until OCR gives it a text layer.

Statements downloaded from online banking are almost always real text. Statements that arrived by post and went through a scanner, or that you photographed, are images.

The free route: Excel's own PDF import

Excel can do this itself, offline, with no extra software:

Data → Get Data → From File → From PDF, choose the statement, and Power Query shows you the tables it found. Pick one, click Load.

It is genuinely good on simple, single-column statements. Where it struggles:

• Statements where a transaction description wraps onto a second line — Power Query often treats the wrap as a new row.
• Multi-column layouts, or a running balance in a narrow column.
• Anything scanned, since there is no text to find.
• Statements where each page repeats the header, which arrives as data.

If your bank's layout is simple, stop here. You do not need anything else.

Converting a PDF bank statement to Excel locally

The layouts that defeat Power Query are the ones a dedicated converter is built for. That is one of the jobs DoC Toolbox does, and the reason it is worth mentioning in an article about bank statements specifically is where the work happens: the file is read on your PC, converted on your PC, and never sent anywhere. There is no server to trust and nothing to delete afterwards.

PDF to Excel is part of the Pro tier, which is a $9.99 one-time purchase rather than a subscription — worth knowing before you start, because a monthly fee for a job you do four times a year is the thing most of these tools are counting on.

If your statement turned out to be a scan, the order matters: OCR first to add a text layer, then convert. Both are Pro, and the OCR side is covered separately in how to make a scanned PDF searchable.

A straight comparison

What no converter gets right

Taking a PDF bank statement to Excel is extraction, not translation, and a few things go wrong the same way in every tool. Check these before the numbers go anywhere near a tax return or an expense claim:

• The total. Sum the amount column and compare it against the closing balance on the statement. This single check catches almost every structural error.
• Negative numbers. Many statements print debits in parentheses, as (24.99). Excel may import that as text, not as -24.99.
• Dates. 03/04 is the third of April or the fourth of March depending on the bank. Set the column format explicitly rather than letting Excel guess.
• Wrapped descriptions. A long merchant name split over two lines can become two rows, one of which has no amount.
• Repeated headers. Page two onwards often re-prints the column titles, which arrive as data rows in the middle of your sheet.

Common questions

Can I convert a PDF bank statement to Excel for free?

Yes, if the statement is text-based and the layout is simple: Excel's own Data → Get Data → From PDF costs nothing and runs offline. Scanned statements need OCR first, which is where free options mostly run out.

Is it safe to use an online PDF to Excel converter for statements?

It depends entirely on the service, and you generally cannot verify the claims. The safer answer for a document containing account numbers and a spending history is to convert it locally, so the question never arises.

Why is my converted spreadsheet empty?

Almost always because the PDF is a scan rather than text. Run the Ctrl+F check above — if searching for a visible number finds nothing, there is no text to extract and you need OCR first.

Can I convert several months at once?

With a desktop tool, yes — batch processing runs the same conversion across a folder. Doing twelve statements one at a time through a web form is where most of the hour goes.

Will the formatting survive?

The numbers will. The layout mostly will not, and that is fine — you want rows and columns you can filter and sum, not a picture of a statement. The same trade-off applies when converting a PDF to Word.

What about CSV instead of Excel?

CSV is often the better target if the data is going into accounting software, because it has no formatting to lose. Check what your software expects to import before you pick a format.

Does my bank offer this already?

Check before converting anything. Many banks let you download the same statement as CSV or OFX directly from online banking, which skips the problem entirely and is always more accurate than any conversion. It is worth two minutes in your account settings.