Get Data from PDF is missing - Excel 2019

Question

Hi Guyz, I want to try to get data from PDF but the option is unavailable. I am using Excel 2019 Business version. can anybody help me pls?&nbsp;&nbsp;

lorenzo · Answer

Hi&nbsp;talha_gamalux&nbsp;&nbsp;Please go to Data (tab) &gt; Get Data &gt; From Other Sources &gt; Blank Query (the Power Query Editor opens). Then, in the Power Query Editor formula bar, start typing: =Pdf&nbsp;&nbsp;If you see - as above - Pdf.Tables in the list this means your version of Excel/PQ has that function but you don't have the corresponding option/wizard in the Excel user interface/menus&nbsp;If you have the function create a Blank Query, then in the formula bar enter(1):=Pdf.Tables(File.Contents("MyFolderPath\MyFileName.pdf"), ["Implementation"=1.3])then press [Enter] and you should be good to go(1) Replace MyFolderPath\MyFileName.pdf with the appropriate Folder &amp; File name

leftydiale · Answer

This worked for me

harshulz · Answer

talha_gamalux&nbsp;goto data tab&nbsp;select get data drop downfrom file&gt;from pdf&nbsp;

talha_gamalux · Answer

harshulz&nbsp;I tried but i don't get any option here&nbsp;&nbsp;

riny_van_eekelen · Answer

talha_gamalux&nbsp;I understand it's for MS365 subscribers and Excel 2021 only. So, not available in Excel 2019.

Forum Discussion

Get Data from PDF is missing - Excel 2019

Share

Resources