Get Data from PDF is missing - Excel 2019

%3CLINGO-SUB%20id%3D%22lingo-sub-3182170%22%20slang%3D%22en-US%22%3EGet%20Data%20from%20PDF%20is%20missing%20-%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3182170%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22talha_gamalux_0-1645149352966.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349369i98EBC716E837C2D3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22talha_gamalux_0-1645149352966.png%22%20alt%3D%22talha_gamalux_0-1645149352966.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHi%20Guyz%2C%20I%20want%20to%20try%20to%20get%20data%20from%20PDF%20but%20the%20option%20is%20unavailable.%20I%20am%20using%20Excel%202019%20Business%20version.%20can%20anybody%20help%20me%20pls%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3182170%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3182256%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20Data%20from%20PDF%20is%20missing%20-%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3182256%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1310928%22%20target%3D%22_blank%22%3E%40talha_gamalux%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3Egoto%20data%20tab%26nbsp%3B%3CBR%20%2F%3Eselect%20get%20data%20drop%20down%3CBR%20%2F%3Efrom%20file%26gt%3Bfrom%20pdf%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22harshulz_0-1645153289465.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349374i34A723FB9D0466F9%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22harshulz_0-1645153289465.png%22%20alt%3D%22harshulz_0-1645153289465.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3182273%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20Data%20from%20PDF%20is%20missing%20-%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3182273%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1296787%22%20target%3D%22_blank%22%3E%40harshulz%3C%2FA%3E%26nbsp%3BI%20tried%20but%20i%20don't%20get%20any%20option%20here%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22talha_gamalux_0-1645153750501.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349375iC396C2B7F34D7458%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22talha_gamalux_0-1645153750501.png%22%20alt%3D%22talha_gamalux_0-1645153750501.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

talha_gamalux_0-1645149352966.png

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?

 

 

4 Replies

@talha_gamalux 
goto data tab 
select get data drop down
from file>from pdf

harshulz_0-1645153289465.png

 

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

 

talha_gamalux_0-1645153750501.png

 

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

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

 

Screenshot.png

 

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

 

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