Get Data from PDF is missing - Excel 2019

DesignWardy
Copper Contributor
Jul 15, 2023
it's the same in my version ang microsoft office 2019 can't get data from PDF format
talha_gamalux
- Lorenzo
  Silver Contributor
  Jul 15, 2023
  DesignWardy
  https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-get-transform-get-data-from-pdf/1bd2afdc-2912-4b08-aae6-40250b0d589d?tm=1657958531852 might help...
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
  Copper Contributor
  Jan 19, 2024
  This worked for me
Riny_van_Eekelen
Platinum Contributor
Feb 18, 2022
talha_gamalux I understand it's for MS365 subscribers and Excel 2021 only. So, not available in Excel 2019.

Forum Discussion