Forum Discussion
samuel_kodjoe
Jun 28, 2021Copper Contributor
how do i extract data from a pdf file using power query in excel?
hi team, Please i would like to find out if there is a way to extract data from a pdf file using power query in excel? regards!!
SergeiBaklan
Jun 28, 2021MVP
If you are on Windows, on Excel 365 and not on semi-annual channel you shall have this connector
Perhaps these days availability bit wider, not sure. But in any case that's for subscription model.
- samuel_kodjoeJun 29, 2021Copper Contributorwow.....so there is no ad ins i can install to access this with 2019 version?
- LorenzoJun 29, 2021Silver Contributor
Copy/paste the following code in a new blank query using the Advanced Editor
let Source = Record.ToTable( Record.RemoveFields(#shared, Record.FieldNames(#sections[Section1]) ) ), SelectedTypeFunction = Table.SelectRows(Source, each [Value] is function), RemovedValue = Table.SelectColumns(SelectedTypeFunction, {"Name"}), SortedByName = Table.Sort(RemovedValue, {{"Name", Order.Ascending}}) in SortedByName
then load the result of that query on a sheet. If you find Pdf.Tables in column [Name] the function is available in your version of Excel/PQ. Per its name the function is looking for table(s) in the PDF...
- samuel_kodjoeJun 29, 2021Copper Contributorhi Lz!
I saw Pdf Tables in column name after loading the code, how then do i locate it.
Thanks for the feedback.