![Yoshiko tsushima download](https://cdn1.cdnme.se/5447227/9-3/22_64e61dfde087c31b3e70ff43.png)
You should also be able to check that the values line up properly in the table - if not then the error lies with the original PDF creation, not what you are extracting. Select a table or page you want to import and click Load button to import the PDF table to the Excel sheet. 1 Answer Sorted by: 0 If the PDF file is definitely a table rather than an image of a table, then I would use Word to open the file and extract the data from the Word File to excel. Step 3: All tables and pages in the PDF file will be opened in the Power Query Navigator window. Step 2: Choose the PDF File you want to import to Excel and click Import. Step 1: Go to the Data tab and click Get Data > From File > From PDF. Office 365/Microsoft 365 users can import data from a PDF to Excel. Import Table from PDF to Excel via Office 365 Multiple Batch Processes like data extraction, OCR, combine PDF, etc.Optimize PDF Size and Organize Pages and Files.Protect PDFs and Add Digital Signatures.Fill, Convert, and Extract Forms and Form Data.A quick look at the top features will reveal the breadth and depth of its document management capabilities. It offers a wide array of functionality, from PDF creation to PDF editing, annotations, file conversion (as we've just seen), PDF protection, form-filling and e-Signing, comprehensive form management, and advanced tools like OCR and batch processes. Office 365/Microsoft 365 users can import data from a PDF to Excel.
![excel import pdf table excel import pdf table](https://support.content.office.net/en-us/media/3261c5c6-24a0-4b36-9ad0-7595bf129bdb.png)
Here are just some of the other utilities that are included. Wondershare PDFelement - PDF Editor is a great tool to import PDF to Excel but it's a lot more than that.
![Yoshiko tsushima download](https://cdn1.cdnme.se/5447227/9-3/22_64e61dfde087c31b3e70ff43.png)