Excel "Get Data From PDF" Missing or Not Working? Why, and What to Do Instead

Who has the From PDF option

If you have a Microsoft 365 subscription on Windows and still cannot see it, Office is probably out of date: File → Account → Update Options → Update Now, then restart Excel. On a work computer, the update channel is set by your IT department, and a slow channel can be months behind.

When From PDF finds nothing, or the wrong thing

The import opens a Navigator window listing what it found: entries such as Table001 (Page 1) for tables it recognised, and Page001 for each whole page. What goes wrong usually shows up there.

• Only Page entries, no Table entries. It did not recognise a table. Pick the Page entry, Transform Data, and split the columns yourself in Power Query — or convert the PDF another way (below).
• Nothing useful at all. The PDF is almost certainly a scan: a picture of a page, with no text to read. No import can find cells in a picture. Run OCR PDF first to add a text layer, then check every cell by hand.
• One table per page. A long table that runs over several pages comes in as several tables. Select them and use Append Queries to stack them into one.
• Columns run together or a row is split in two. The PDF stores text at positions, not cells, so every importer has to guess where columns and rows are. Where a table has no lines and values sit close together, the guess goes wrong. Why PDF tables come out wrong goes through the fixes one by one.

Three ways without the From PDF option

1. Copy and paste, then Text to Columns

Select the table in your PDF reader, copy, and paste into Excel. For a simple table this is enough. Usually each row lands in a single cell: select the column, then Data → Text to Columns, and split on spaces or at fixed widths. It falls apart as soon as a description itself contains spaces.

2. Open the PDF in Word first (Windows)

Word for Windows can open a PDF directly — File → Open — and turns it into an editable document. Tables often come back as Word tables, which you can copy and paste into Excel with the columns intact. It is free if you already have Word, and slow for a long document.

3. Convert the PDF to an Excel file in your browser

PDF to Excel rebuilds the rows and columns from where the text sits on each page and gives you an .xlsx with one sheet per page, numbers stored as numbers. It works the same in Chrome, Edge, Safari and Firefox, so a Mac is no obstacle. The PDF is read inside the page: it is not uploaded, which matters when it is a bank statement or a payroll report.

How well that works is measured, not claimed: on the 158 tables of ICDAR 2013, the public benchmark for pulling tables out of PDFs, it scored 93.4%; on 14 test PDFs of our own with a known answer, all 176 rows came back exactly right. Like Excel's own import, it cannot read a scan. For bank statements there is a dedicated Bank statement to Excel, which also checks every row against the running balance.

Which one to use