Why Excel's "Get Data From PDF" Fails on Bank Statements

Excel has a built-in PDF importer. Here's the specific reason it struggles with bank statements, and what to do instead.

Excel 2019 and later can import PDFs directly: Data → Get Data → From File → From PDF. It's free, it's built in, and on bank statements it usually disappoints. The reason is worth understanding, because it explains what any converter has to do differently.

Power Query looks for grids

Under the hood, Excel's importer uses Power Query's table detection, which identifies tables primarily by their ruling lines — it looks for a closed rectangular grid and treats the cells inside it as data.

Most banks don't draw one. Some draw vertical column separators but no horizontal row lines. Others draw a box around the table with nothing inside. Many draw nothing at all and rely purely on whitespace alignment, which is invisible to a line-detection algorithm.

With no grid to find, Power Query falls back to treating the page as unstructured text, and you get a single column containing everything.

It also has no domain knowledge

Even when Power Query does find a table, it doesn't know what it's looking at. It has no concept of:

A subtotal row that must be excluded rather than counted
A continuation line that belongs to the transaction above it
A reference number that must not be parsed as an amount
A daily-balance summary block that isn't transaction data
A running balance that could be used to check the whole extraction

That last one is the real gap. Excel will give you a result, but nothing about whether it's right.

What to try before giving up on it

Check the preview pane The import dialog lists every table and page it found. If your transactions appear under a Table entry rather than a Page entry, you're in luck.
Try the Page view instead of the Table view Sometimes the page-level extraction preserves more structure than the detected table.
Use Split Column by whitespace If everything landed in one column, splitting by consecutive spaces can recover the columns on simple layouts.
Verify the totals afterwards Whatever comes out, sum the debits and credits and compare against the statement's printed totals before using the file.

Frequently asked questions

Does this work on Excel for Mac?

The From PDF connector is Windows-only in most versions. Mac users generally need a different route.

Why does my import show pages but no tables?

That's the no-grid case — Power Query found the pages but couldn't detect table structure on them.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.