Forum Discussion

talha_gamalux's avatar
talha_gamalux
Copper Contributor
Feb 18, 2022

Get Data from PDF is missing - Excel 2019

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?    
excel
talha_gamalux's avatar
talha_gamalux
Copper Contributor
Feb 18, 2022

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

 

 

Lorenzo's avatar
Lorenzo
Silver Contributor
Feb 18, 2022

Hi talha_gamalux 

 

Please go to Data (tab) > Get Data > From Other Sources > Blank Query (the Power Query Editor opens). Then, in the Power Query Editor formula bar, start typing: =Pdf

 

 

If you see - as above - https://docs.microsoft.com/en-us/powerquery-m/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

 

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 & File name

  • LeftyDiale's avatar
    LeftyDiale
    Copper Contributor
    Jan 19, 2024
    This worked for me

Resources