Forum Discussion

Copper Contributor

Oct 31, 2023

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

Silver Contributor

Oct 31, 2023

(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 Power Query / Get & Transform – Get data from PDF missing

(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)

Hathaway7
Copper Contributor
Nov 01, 2023
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.
- Lorenzo
  Silver Contributor
  Nov 01, 2023
  Hathaway7
  
  Ref. to Power Query data sources in Excel versions 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 Power Query / Get & Transform – Get data from PDF missing - you got the following?:
  
  If you did make sure your system has .NET 4.5 or higher version and try again...

Resources