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
// Forum Link: answers.microsoft.com/en-us/m...
// Step 1 Document: onedrive.live.com/view.aspx?r...
// Step 2 Formula: = Pdf.Tables(File.Contents("D:\Documents\Bank\2022-07.pdf"), [Implementation="1.3"])

[@1Gollywalk]

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?

[@enersysthermal8921]

It worked! Thank You! Keep posting more information!

[@joycechong613]

Will do so! I'm happy to be able to help you with this. :)

[@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

[@joycechong613]

Welcome, all the best in your studies!

[@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.

[@joycechong613]

Hi how about you try to right click your document. Select Properties > General. Combine these 3 info together: 1. Location 2. Add a slash \ after location 3. Type of file, for example .pdf in this case Example of the document path should be something like this C:\Users\USER\Desktop\documentname.pdf

[@stevenlitvintchouk3131]

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.

[@sonalpatil2619]

Hey thanks alot its awesome it helped al lot 🎉

[@nayansaha4349]

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

[@joycechong613]

You're most welcome!

[@CatherineKatka]

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

[@joycechong613]

Thanks! 😊

[@jeronimolegua6606]

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

[@joycechong613]

Hi, thanks for letting me know, glad that I'm able to help!

[@mrashid229]

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

[@joycechong613]

Thank you! It's so nice to hear this from you. :)

[@Adam-ei5it]

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 ?

[@sergiosergio7556]

Thank You very much!

[@joycechong613]

Welcome!

[@ronnykp7808]

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

[@joycechong613]

Hi, welcome! I'm glad this helps you. :)

[@MsMassad]

Thank you very much

[@joycechong613]

You're most welcome!

[@muhammadsafdar692]

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

[@ashish.bonde.84]

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

[@joycechong613]

Hi. I believe Power Query comes in handy for your situation. Try to search 'combine multiple tables using Power Query' in KZbin. Hopefully this helps.

[@oliverfletcher7929]

You’re a genius!!

[@joycechong613]

You're most welcome! Glad it's helping you.

[@karanpatil8218]

Thank you 🙏

[@joycechong613]

Welcome!

[@gowthamdharmaraj9979]

thank you 😊

[@joycechong613]

Welcome!

[@johnt9186]

Joyce, THANK YOU||||| Amazing tutorial.

[@joycechong613]

Hi John, thanks, I'm glad to be able to help!

[@user-re1rx6tf3p]

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

[@joycechong613]

Hey you should be able to import all 13 pages using the same method. You should be able to see all the displays of the 13 tables of your document after you finish the steps @4:15. You can select whatever page you want to load from there. Hope this helps!

[@mwajahat]

When press Refresh Button, then get this error, pls help on it, Thanks "Initialization of the data source is failed."

[@joycechong613]

Hi, I have not encountered this problem before, but maybe you can run a repair on your excel? I searched for some resources online and saw this:- itecnote.com/tecnote/initialization-of-the-data-source-failed-excel-2016/

[@miroslavdusko849]

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?

[@joycechong613]

This seems odd. The option should be there all along. Which version of excel you are using?

[@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

[@joycechong613]

When you load the PDF, you should see a list of all the tables inside your pdf. From there, you can select multiple tables you want to load. In this way, you can import all the tables in your pdf.

[@winaykumar_m]

@@joycechong613 Thanks did figure this out. Tried doing multi select and then appended similar tables to create the consolidated data. Please LMK if there's faster way of doing the same?

[@user-xq4uz9er7p]

it shows my table is empty

[@SudhirKay]

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

[@joycechong613]

Ah I have no idea honestly. Have you given this a try already?

[@elle13nako]

Hi, the steps are very clear but it doesn't work for me. After i pasted the formula, no table generate. I tried to change 1.0 / 1.2 as well, it just didn't run. I am using Office 365 :(

[@joycechong613]

How about value 1.1 / 1.3 ? Give them a try.

[@elle13nako]

Hi, thanks for replying. Actually, I tried all. Does it work for fillable PDF form? Because mine PDF was an application form.

[@user-fo7rs4iy6m]

I cant enter the forum. Is it no longer available?

[@joycechong613]

Hi, the forum link is still working on my end. You can try this as well! answers.microsoft.com/en-us/msoffice/forum/all/power-query-get-transform-get-data-from-pdf/1bd2afdc-2912-4b08-aae6-40250b0d589d

[@bpavan1419]

how to get that document which is shown at 3:06

[@joycechong613]

You can use your own document haha! Any document can be imported using this method.

[@grmnepal]

Why I can not find refresh option😔😔

[@joycechong613]

After you download the excel copy, open the excel & make sure you click 'Enable Editing' on Protected View. Then right click on the green row, you will be able to find the refresh option.

[@BebomiMia]

On step 2 it showing Datasource.Error this device is not ready?

[@joycechong613]

community.fabric.microsoft.com/t5/Desktop/DataSource-Error-Could-not-find-a-part-of-the-path/td-p/2569932

[@joycechong613]

You can try this. I believe it's something to do with perhaps you did change the file location before.

[@ooomyoom]

my table is showing empty , please help

[@joycechong613]

Have you checked your document yet? See if you select the correct document or not.

[@ooomyoom]

The document is correct @@joycechong613

[@wasimqadari2077]

While Trying this formula I am facing this error➡ Expression error: The name 'Pdf.Tables' wasn't recognized. Make sure it's spelled correctly.

[@joycechong613]

You may check if any spelling is not correct and make changes accordingly. I believe it is related to the spelling of your words.

[@sachingeorge879]

Its right!! I am working as a partime worker on santa monics i have faced this problem,,, so wiered

[@wasimqadari2077]

@@joycechong613There was not any spelling mistake, I copied the formula from your post.

[@joycechong613]

@@wasimqadari2077 Ok! Checking with you, if you're using your own file, did you change this xxx to your document path? = Pdf.Tables(File.Contents("xxx"), [Implementation="1.3"])

[@wasimqadari2077]

@@joycechong613 Of course sir

[@kmr5534]

how to import multiple pdf files into excel

[@joycechong613]

Can you combine all your separate pdf files into one? Then you can proceed to use the same method using the combined pdf file.

[@kmr5534]

@@joycechong613 unable to load all pages content .at a time only one page content is loading.

[@ceyhunozdemir6057]

links dead

[@joycechong613]

Hi, I am able to open the forum and document links from my end. Let me know which link is not working thanks!

[@ceyhunozdemir6057]

@@joycechong613 they both look dead. Maybe because of the shortcuts or the ISP

[@joycechong613]

Hi thanks for letting me know, I just updated the original link in the description section. Thanks!

[@mohammadshameer4302]

NOT WORKING

[@joycechong613]

Which part?

[@vkgupta4107]

not clear

[@joycechong613]

What is the issue that you're having then?

[@MrMandarpriya]

just doesn't work in mac m1. It is like making a joke

[@user-cb6mo4xr3b]

Thank you very much

[@joycechong613]

You're most welcome! 😁