Did you know that you now have the option of importing and converting PDF data into Excel? This was one of the top requests of Excel users: How can we convert a PDF file into Excel?
Now you can use Power Query’s amazing data functionality to not just convert PDF to Excel, but import the PDF data with a connection the original PDF file. This way you can refresh the imported data in Excel to get the latest data from your PDF document. In addition to this, you can also clean the imported PDF data.
In this video we will test the functionality with 3 different business cases. We will first test the automatic refresh in Excel when the content of the PDF changes. In the second example we will import a specific table from a PDF document (Tesla’s quarterly financial report). And finally we’ll get creative and import the table of contents from a PDF eBook into Excel.
The new PDF data connector is available as part of a Microsoft 365 subscription
⯆ Read the full blog post:
Complete Excel Power Query playlist:
★ My Online Excel Courses ►
✉ Not sure which of my Excel courses fits best for you? Take the quiz:
EXCEL RESOURCES I Recommend:
Get Microsoft 365:
Microsoft Surface:
GEAR
Screen recorder:
Main Camera:
Backup Camera:
Main Lens:
Zoom Lens:
Audio Recorder:
Microphone:
Lights:
More resources on my Amazon page:
Time Stamps
00:00 Import from PDF to Excel with Power Query
00:41 Automatic Refresh – Import from PDF to Excel with Power Query
03:36 Convert Financial Report from PDF to Excel with Power Query
07:10 Import Table of Contents from PDF to Excel with Power Query
Let’s connect on social:
Instagram:
Twitter:
LinkedIn:
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #PowerQuery…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
If you have an image that you'd like to import into a table in Excel or Word, check out this video: https://youtu.be/KG4Jz0FLY5w
Hi, instead of filter out those section heading with null value, is there a way to split them into a new column? Thanks.
Very nice
This video is on point. Wow
As usual, Leila is very very good.
Hi Leila, your videos are always helpful. today i am stuck. what if i have a password protected PDF and i have that password, i want to convert it in excel how i will do that. need your help
Thanks Leila. Very helpful.
hello great teacher
unfortenally I don't find PDF in liste of "from file" in Data
what I must do .?
Thank you so much for all the great tutorials you offer! Quick question and it might be a silly or wishful thinking 🙂 Is Power Quesry capable of recognizing the table if the document was printed as PDF rather than it being a true PDF file?
This is excellent, thank you. Sometimes Excel doesn't find a table in the PDF though which is vexing.
I dont have that option on my excell
Leila, I cannot believe my eyes. You just cannot imagine what a lifesaver you have been. I saw many videos trying to explain importing PDFs to Excel. Unfortunately, none of those could solve my problem. I get Invoices in PDF format and need to convert those line items wise to Excel to maintain the material and quantity, rate and total amount. I had to spend hours converting each Invoice. Now I can very accurately convert those in a matter of minutes. In fact, before this comment, I managed to convert 23 invoices. Thank you very much!
Dear Leila, what shall I do if I do not have an option Get Data / From File / From PDF? I have MS Excel for Office 365. thanks in advance
all you is the same i thought 3 diferent methods.. you wasted my time
the latest version of Microsoft 365 does NOT have the "From PDF" file source. Why is that? I cannot extract my tables from PDF's now 🙁 Appreciate your help. Thanks
Hello leila, I have one excel book with multiple sheets, All sheets have different information, please make video on how to create PDF export button. which works for all sheets.
my excel does not show the option Import Data From PDF. I have all other options, except PDF. I have tried MS-Office 2007 & now 2021 also
Seems so easy when you do it! It took me some rewatches to be able to do it on my data set at work. At home, my excel seems to be a version that it is not able to get data from PDF files. Do you know since what version is excel capable of getting data from pdfs?
PERFECT!!!!
good day i am new to excel and your videos has been a life saver. please i use excel 2016 and the option of importing from file is not in my please wat version did you use fo r your video excel version. please await your reply
Million likeeee 10000000000000
amazing.
Hi, I like your method but for some reason it's not working for me. I have a large pdf and need to convert it to excel. It's 26,971 pages any suggestions would be greatly appreciated. I've tried the ilovepdf and adobe but to now avail. Thanks.
How to Convert PDf File with 400 pages into excel .. I tried into power bi tool but it took so much to Convert and open into my power query plz help
Hi Leila. you're videos are excellent. I learn a lot thanks for all the effort and hard work. I am trying to do the pdf import but I dont have "From PDF" option when I click on Get Data/From File. How can I resolve that?
Thanks
How to convert all word document tables into excel tables ?
I like your all videos i have done data analyst course previous month now I want to start my career. I have gap 12 years
thanks leila but in my ms excel the option pdf its not appear why
any suggestions on how to properly convert tax return pdf to excel?
Hi Ma'am,
Good Morning.
May you please confirm which execl version is this? Because I have no option in my excel version.I mean Get data from a PDF file.
One more query that , how you convert a image file to an excel?
I have tried many more from internet but did not get success.
Please reply
My excel has no option for selecting form ->PDF
Help! I need to extract a table that spans 70 pages in the middle of a technical document. There is a page heading at the top of each page that Power Query recognizes as a table. Is there a way to filter out the "header" tables that I don't want and merge the content from the 70 pages into one table?
Why don't I see the option to import pdf in data options? I have office 365 Personal & Family. This has been available since 2020 and you would expect to have it by now.
i cant find the from pdf file., help
How to do the same in google sheets ?
Hey… if I need to use some info like (full name or employee I'd)which above on headers to be included with my headers how I can do that
testing101
Why In my excel not ( show Get Data From PDF).
Whats the reason
Thanks so much for sharing helpful and important information. I'm using Excel 2019 and I don't find the option (Data —> Get File —> From File) to import a PDF file.
Do I need a newer version?