You have a PDF full of numbers and you want them in a spreadsheet, so the obvious move is to open the PDF in Excel. Try it and nothing useful happens: Excel does not list PDF as a file type it can open, and dragging the file in either does nothing or buries it as an embedded object. This is one of the most common spreadsheet questions, and the short answer is that Excel cannot open a PDF the way it opens an XLSX or CSV. It can, though, import the data inside one, and there are a few ways to get there.
This guide explains what really happens when you point Excel at a PDF, which built-in feature does pull the data in, where it falls short, and the quickest route to clean rows and columns. If you want to skip the workarounds, upload your file to the converter at the top of this page.
Can Excel open a PDF file?
No, Excel cannot open a PDF directly. PDF is a page-layout format, not a spreadsheet format, so it never appears in Excel's Open dialog as a file you can load into a grid. What Excel can do on recent Windows builds is import the tables inside a PDF through Power Query. The PDF stays a PDF; Excel reads its contents and copies the detected tables into a worksheet. To get a finished file in one step, a tool to import a PDF into Excel does the reading for you.
How do I open a PDF in Excel?
On Windows, go to Data, then Get Data, then From File, then From PDF, choose your file, and Excel opens a Navigator pane listing each table it detected. Pick the table you want and load it into a sheet. One thing worth knowing in the Navigator: each page shows up as both a Table item and a Page item, and choosing the Table version usually gives cleaner column breaks than the whole-page version. This works for clean, digital PDFs with simple tables. For dense statements, multi-page reports, or anything scanned, the result usually needs heavy cleanup, and the PDF table extractor approach gives you tidier columns without the manual fixing.
Why can't I import a PDF into Excel?
Usually one of four reasons. The From PDF option only ships with Microsoft 365 and recent Windows versions of Excel, so older or non-updated installs do not have it. The PDF might be scanned, which means there is no text layer for Excel to read. The file could be password protected. Or the layout is complex enough that Power Query returns columns split in the wrong places. We break the failure modes down in our guide to what to do when PDF to Excel is not working.
Can Excel for Mac open a PDF?
No, and it cannot import one either. The Get Data From PDF connector is a Windows-only feature, so Excel for Mac users have no built-in way to pull a PDF's tables into a sheet. Apple Numbers does not import PDFs at all. That leaves Mac users with lossy copy and paste or a browser-based converter that runs anywhere, which is why we put together a dedicated guide to converting PDF to Excel on a Mac.
How do I open a scanned PDF in Excel?
A scanned PDF is an image of a page, so Excel and Power Query find no text to read and return nothing. You first need optical character recognition to turn the picture back into real, selectable numbers. Run the file through an OCR PDF to Excel tool, which recognizes the figures and rebuilds the table, then download the spreadsheet. The same step is needed for photographed documents and older paper records that were scanned into a document OCR archive.
Can I open a PDF as an Excel file without Microsoft 365?
Yes. Because the built-in From PDF feature is tied to 365 and recent Windows Excel, anyone on an older version, a perpetual license, or a Mac needs another route. A browser-based converter does not care which Excel version you run; it produces a standard XLSX or CSV that opens in any of them. Our walkthrough on how to import a PDF into Excel without Microsoft 365 covers the free fallbacks and where they break down.
What is the difference between opening, embedding, and importing a PDF in Excel?
These three get confused constantly, and they produce very different results. Opening means loading a file into a grid you can edit, which Excel simply cannot do with a PDF. Embedding, through Insert and then Object, drops the PDF in as an icon or a static picture of the first page; the numbers are still trapped inside the image and you cannot calculate with them. Importing, through Get Data and From PDF, is the only one that actually pulls the data into cells, and it is the option you want when the goal is to work with the figures. If the import returns messy columns, a converter that rebuilds the real table is the cleaner path to numbers you can total.
Can Excel open multiple PDFs at once?
Not through the standard menu, which handles one file at a time and makes you repeat every step for each PDF. If you are converting a stack of statements or reports, look for a converter that accepts a batch and returns one workbook or a file per document. Processing them together saves the click-by-click repetition, and a batch PDF to Excel converter is built for exactly that volume.
So Excel cannot open a PDF, but you are rarely stuck. On Windows with a current version you can import simple tables through Power Query, and for scans, Mac, older Excel, or anything with a complicated layout, a converter that reads the real table structure gets you clean rows and columns in one upload. The PDF to Excel converter at the top of this page handles all of those cases, and if the PDF you are wrestling with is study material rather than data, you can even turn it into a practice quiz from a PDF instead.