Forum Discussion
Excel - Get Data from PDF is Missing
Hi, I am using Office Home & Student 2019 and I am missing the From PDF option as well. I am not a techie person and I do not understand what the channels mean. is there another way to get this option?
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- Hi. Look 7 posts above yours
Hi, I downloaded your file and it show Pdf.tables
Could you please teach me how to use the import PDF function because I could not find it in data tab
Lorenzo I have downloaded the file and refreshed and now have the pdf.table in it. How do i go about importing the pdf document into my excel?
- Asanteeli
here is the article from Lorenzo please follow that
The article is available (https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-get-transform-get-data-from-pdf/1bd2afdc-2912-4b08-aae6-40250b0d589d) and explains the Next step when you get a You CAN import Tables from PDF files with the in used product
Hi JPAC_64
Just updated an article I put together the other day, no more need to search for Pdf.Tables, after refreshing the green table you get:
(hopefully this will help Raphael1175 & shahdarshak ...)
The article is available https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-get-transform-get-data-from-pdf/1bd2afdc-2912-4b08-aae6-40250b0d589d and explains the Next step when you get a You CAN import Tables from PDF files with the in used product
Its working for me. Thank you for the article!
Hi Raphael1175,
Did your issue resolved with respect to Get data from PDF option?
I am on Version 2206 for Excel.
shahdarshak Hi, unfortunately, It was not. I am not a very techie and I do not know what they meant with "channels". Is there anything I can do to get that option? Do I have to subscribe to Office 365? Getting a lot of confusing answers and I am not a very technical person. I am using Windows 11.
