In this step-by-step tutorial, learn how to convert an Adobe PDF file to a Microsoft Excel file.
0:00 Introduction
0:36 Example PDF with table of data
1:07 How to import PDF data into Excel
4:24 Wrap up
📃 Watch related playlists
– Playlist with all my videos on Excel:
– Learn the fundamentals of Excel in just 2 hours:
🚩 Connect with me on social
– LinkedIn:
– Discord:
– Twitter:
– Facebook:
– TikTok:
– Instagram:
🙏 Request How To Tutorial Videos
🔔 Subscribe to my YouTube channel
🎬 Want to watch again? Navigate back to my YouTube channel quickly
🛍 Support me with your Amazon purchases:
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel — the price to you is the same.
#stratvert…(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
À
Thank you!
This isn't working
This is a very basic example. Be my guest with hundred of pages with complex table layout.
ดิฉันฟังไม่รู้เรื่องแล้วก็อ่านไม่ออกด้วยภาษาอังกฤษมันคืออะไรคะบอกภาษาไทยได้ไหมคะ
When go to get data and choose PDF and click the file, it opens, but on each page it says "This table is empty." What do I do? Thank you.
What if the information on the PDF is not perfectly laid out? How can I enter information in a table format when it is not so straightforward? Thanks for sharing this video!
Sir is this possible in office 16
Is it possible to edit a scanned family tree which has been saved as a pdf?
i did not found "Get Data" Option i used 2013 version in this version getdata option missing
Thank you for explaining this slowly, step by step, you made it so easy to navigate. My excel spreadsheet came out beautifully.
is it possible in excel 2012 version?
Thank you so much . This is very helpful
If you happen to have MS Office (student version) then you are clearly out of luck here, as this facility is not available there!
So helpful thank you, looking forward to see more informative videos like this!
Would you expand on this video by using a pdf with multiple tables? I Microsoft 365 and if I read in a pdf with one table, then I do not have a problem; however, if my pdf document has multiple tables and they are convert from pdf to Excel, they appear in a column on the right of my Excel workbook and I cannot read them in. Thanks
I dont see the option of import from excel 🙁
Thank you, it was really useful. Keep up the good work.
Thank you soooooo much
Thank you, this was really helpful and easy to understand. Great job.
Hello Sir, I had a question because on form file from PDF is not included how to add the" From PDF"??
mine doesn't show from pdf..
Hi, may i know how to add option "PDF" in the "From File" ?
i have no this option. pls advise.
Great tutorial but what do you do when you import the data and it says "This table is empty"?
Hi
Thank you very much for the explanatory and educational video
I still have a problem,
The table in my PDF file has both text and a number,
When I work according to all these actions only the text works without the number which is the most important part for me,
Is there a way to fix or fix it?
Thank you
When I click Get Data file is not an option (Using Mac). Options:
From HTML
From Text (Legacy)
From SQL Server ODBC
From Database(Microsoft Query)
Data Source Settings
Please help?
When i opened excel and went to data and can't find my PDF ??
Yes, it's very helpful video which I found on YouTube
from my excl file…
data entry i can't find the "from pdf""
another all type is here like from text, from XML, from workbook.
so what need to do…now???
can you help to to Figure it out??
Hi could you add a video for how to download a PDF bank statement and manipulate this is power query. Thanks for all the great videos.
Thank you for explaining this slowly, step by step, you made it so easy to navigate. My excel spreadsheet came out beautifully.
I have facing problem with msoffice unpaid version to convert pdf file into xlxs format pls help
Thank you
while extracting multiple items, it does not works
Thanks. This was very helpful. I was using the pdf to xls websites and that didn't work. You saved me a lot of time.
This is great
Get data is not available in my pc