How to Import PDF into Excel (Get Data from PDF is Missing)

This is the tutorial on how to import tables from PDF into excel if Get Data from PDF is missing.
0:00 Introduction
0:36 Step 1 - Determine If We Can Import PDF
1:42 Step 2 - Import PDF
5:06 Outro

[Gollywalk]

From pdf not showing in my Excel (MS Office 2019 Plus) and I want to "import" multiple pdf files. Can you help please.
I am aware of the single file workaround with "= Pdf.Tables(File.Contents....", but is is only for a single file. Is there away to add multiple files?

[enersysthermal]

It worked! Thank You! Keep posting more information!

[kiptooj]

thanks for the video. I had started following a long route like learning python codes to achieve this

[AyranLP]

Thank you so much, youve saved my study preperations <3

[remoteworkstuff]

Thank you so much for the video. I also tried to use the same instruction from Microsoft help, but still encountered prob with the formula link given to copy-paste. However..

3:05 My PDF file doesn't provide "copy as path" on th right click menu, can't also copy paste manually by "pressing Ctrl+Shift+C then Paste/Ctrl+V".

Would be great if you could give some help with this issue.

[stevenlitvintchouk]

Does not work for me. When I select Data\Get Data\From Other Sources\Blank Query, Excel freezes ("Not Responding") and it never opens the Power Query Editor.

[sonalpatil]

Hey thanks alot its awesome it helped al lot 🎉

[nayansaha]

Thanks a lot. I am so grateful to you. You are so genius. God bless you !

[CatherineKatka]

Thank you, this is a great help, IT WORKS !!!

[jeronimolegua]

Hi, worked for me. Just had to change the 1.0 value. Thanks!

[mrashid]

So grateful to you friend, very clearly explained the steps, you saved my time and effort. Just subscribed you to learn more.

[Adam-eiit]

I refreshed and I get a weird message : initialization of the sata source failed. it doesn't say if I can ot can not import PDF. Any clue ?

[ronnykp]

Hi, I tried, its working. thank you very much.

[muhammadsafdar]

Kon sa version Hy ye???
Humary pass open ni horaha hy

[ashish.bonde.]

Thanks it worked for me but please tell me how do I select all tables (hundred of tables I have) in one go

[rerxtfp]

You showed us how to import one page. I have a PDF that is a big table that spans 13 pages. How would I import all 13 pages of the big table? Please let me know ASAP

[mwajahat]

When press Refresh Button, then get this error, pls help on it, Thanks

"Initialization of the data source is failed."

[miroslavdusko]

Thanks for video. I have one question. Can you explain why one time I see the option import data "From PDF" and after few minutes this option is missing?

[winaykumar_m]

Hi, how to apply a rule to import all tables in the pdf having a similar data structure? Ensuring that the entire data is captured

[SudhirKay]

Hi does this work for excel on mac by any chance?