Forum Discussion
Convert pdf to excel
Hello,
I have gone to the data option to convert a pdf to excel, and no option is listed. Am I looking at the wrong place?
Thanks
4 Replies
Hi Hathaway7
(quite popular topic/issue...)
If your product is up to date and you still don't have the option in the menus check a possible alternative in https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-get-transform-get-data-from-pdf/1bd2afdc-2912-4b08-aae6-40250b0d589d?tm=1657958531852
(And if by any chance this also works for you feel free to post back and to Mark as solution to help people who Search - Thanks)
- Thanks for getting back to me. I contacted Microsoft support and this option was tried but did not worked. I have Professional 2019 so I am surprised it does not work. However, Customer Support showed me a different route using Word.
It's a shame I cannot use the excel option.
Thanks again.Ref. to https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16?ui=en-us&rs=en-us&ad=us it's expected you don't have the option in the menu with 2019 Pro or Pro Plus. Note that the page also indicates that .NET 4.5 or higher is also required
I contacted Microsoft support and this option was tried but did not worked
Are you saying that - after refreshing the query shared with https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-get-transform-get-data-from-pdf/1bd2afdc-2912-4b08-aae6-40250b0d589d?tm=1657958531852 - you got the following?:
If you did make sure your system has .NET 4.5 or higher version and try again...
- No you are not. If it isn't there perhaps your Microsoft 365 license doesn't include that connector?
