Forum Discussion
Excel - Get Data from PDF is Missing
Hi Raphael1175
For Excel version, channel... Within Excel: go to File > Account, on the right side - i.e.:
The From File > From PDF option (in Excel User Interface) isn't available in all versions of Excel & Channels (no idea for Excel 2019 Home & Student). Such option allows users to easily do something (through a wizard) that could be +/- complex otherwise
However, it's not because the option doesn't appear in the Excel User Interface that don't have access to the corresponding Power Query function (Pdf.Tables). To check this on your version of Excel:
- Download the attached file & open it
- In Sheet1 rigth-click on the following Table
- Select the Refresh option
Once the Refresh is complete, search in that Table for Pdf.Tables. If you find that occurence it means your version of Excel can import Tables from PDF files
If you have Pdf.Tables function let us know and someone will explain how to use it...
Lorenzo Hi, I did the check and the entry "Pdf.Tables is in the list.
Please let me know to to proceed further.
Thanks
- LorenzoAug 14, 2023Silver ContributorHi. Look 7 posts above yours