Office 365 brings us some new ways to extract PDF files into Excel, whether it’s a single or multiple sheets or even combining multiple PDF files into one, it gets a little harder but it’s all possible and this could be an eternal timesaver trick.
With images, we will look at the built-in method via Office mobile and a third-party app called www.extracttable.com
The custom code I refer to during the video for combining PDF sheets or files is Pdf.Tables([Content])
Related videos:
4 min intro to Power Query:
Combine files in folder in Power Query:
Office mobile app:
Chapters
00:00 – Introduction
00:55 – Single page pdf
02:43 – Data from images
03:16 – Images to Excel on mobile
04:51 – Images to Excel on computer
08:06 – Multi page pdf
09:27 – PDF from folder
11:52 – Complex multi page pdf…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
I'm looking to convert a pdf file to excel that has a data box (product info) and an image (the product). Is this possible?
if I have a folder with pdf in it with different number of pages, and I want to combined in one single excel file by using the function extract from a folder, how can I do it in one shot ?
Is there a way to import if the pdf has an image column, like an image for every row in the image column
what’s your exel version?