how do i import pdf file into excel

Question

how do i import pdf file into excel

John Stewart 10

When I click on DATA tab and then get data there is no file get from PDF

Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

Lisa Cofield 0 Reputation points

2026-03-06T07:33:02.74+00:00

I have MS 365 and Office. I am trying to upload data from multiple W-9s into a spreadsheet. Nothing comes over into my excel spreadsheet. Thank you!

Answer recommended by moderator

Bob Jones AKA CyberTaz MVP 437.8K

Contrary to the misinformation you've received Mac Excel does not support extracting data from a PDF file. Please see: Import data from data sources (Power Query) - Microsoft Support

0 comments

2 additional answers

Lisa Cofield 0 Reputation points

2026-03-06T07:33:02.74+00:00

I have MS 365 and Office. I am trying to upload data from multiple W-9s into a spreadsheet. Nothing comes over into my excel spreadsheet. Thank you!

Answer 1

Hi John Stewart,

Good day. I'm Jhun an independent advisor. In regards with your query, let's check first your Excel if it supports PDF import.

The "Get Data" > from PDF is available only in:

Excel Microsoft 365.
Excel 2019, 2021, 2024.

If your Excel supports import PDF, the exact path is:

Data > Get Data > From File > From PDF.

Other Options if it doesn't supported by your Excel.

A. Use a third party PDF to Excel apps like (removed by Moderator) etc. You can also do conversions with free online PDF to Excel converters. You can easily search for it.

B. Use Word to copy then paste to Excel.

Right-click the PDF.
Open with Microsoft Word.
Word converts it to text.
Copy the table.
Paste into Excel.

I hope this helps.

Regards,
Jhun

Answer 2

To import a PDF file into Excel, you can follow these steps:

Open Excel and go to the Data tab.
Click on Get Data.
Select From File and then choose From PDF. If you do not see the option for PDF, ensure that you have the latest version of Excel, as this feature may not be available in older versions.
In the dialog box that appears, provide the file path or the URL to the PDF file you want to import.
Select the data you want to import from the PDF and then click Load or Transform Data to make any necessary adjustments in Power Query.

If you are using Power Query, you can also access the PDF file by selecting the PDF option in the connector selection, as described in the documentation.

Make sure that your version of Excel supports importing from PDF files, as this feature is available in certain versions of Excel and may not be present in all installations.

References: