How to Import PDF to Excel //
Вставка
- Опубліковано 26 сер 2024
- This 1 minute #shorts video is a step-by-step tutorial that shows you how to import PDF to Excel. With Office 365, it is super easy and fast to convert PDF to Excel in just a few clicks
✅ More details on how to import a PDF into Excel spreadsheet: techcommunity....
🔔 Subscribe to my Channel: aka.ms/MikeYou...
📢 Connect with me on Social:
Twitter: / mtholfsen
LinkedIn: / miketholfsen
Instagram: / mtholfsen
Pinterest: / miketholfsen
TikTok: / mtholfsen
Wakelet: www.wakelet.co...
#shorts
For more #Shorts videos, check out my growing playlist ⏩ ua-cam.com/play/PLdHjJccRYryOgdpQCnD2YLGSEy39Bya5q.html
Hi
Siap 🎉
Thanks for not taking 14 minutes to explain this. Exactly what I wanted, thanks!
Glad it helped!
Omg you just saved me 4 hours of my life thank you !
Not working, both on latest version of Excel and on 365 Microsoft website logging in thru my paid subscription
In my excel in get data option doesn't have from pdf option. Can you please tell me how I can fixed it
Mines doesnt have it either
same with me.
Same here
This option is only available in the 365 Version of office
@@jaimeconjo and 2021
Love this quick helpful demo. One note of warning, though. As someone who uses this functionality often I can tell your readers that some PDF's don't read very well. Some you will only be able to see the first page or some of the data elsewhere. There is a complex fix for this which uses VBA and Power Automate to convert the file to Word, then back to PDF! But if you want to do that manually it means the Get Data functionality will work on your new PDf file.
Saved me hours of frustration thanks!
Oh my gosh! You just saved my life! I love your content!
What is the process of importing PDF into Mac Excel?
good stuff, thank you.
You saved my life Mike! Thank you! Lot's of love from Istanbul...
Best video ever. Right to the point and works! Thanks Mike.
Great... Thanks ❤❤
Super useful
your short video is saving my life
Terima kasih Mas Mike, saya contek ilmunya yaa❤
Thank you for this help!
Thank you
Oh, this is what exactly what I wanted. Though I had watched this tip somewhere else but forgot to apply. I'm happy I haven't worked on the new project yet which involved copy table from pdf.
I'll see it tomorrow if that works for me. Let me set a reminder to use the trick😅.
Thank you.
Fantastic! Thank you Mike!
Very useful. Thank you 👍
Exactly what I was looking for, thanks Mike!
Glad to help!
or you can copy the table from PDF, right click, select past special and select the one that is working
Thank it works 😊
This only works on 365. Not older versions
Thank you ❤❤❤
mine doesnt have get data option
I love to watch it, not lose time.
What version of Excel does this work on? On both my Mac and PC I only have the option to get external data from access, from Web, from text or from “other sources“ but PDF is not one of them.
Office 365 version
Try under the new query button in the data tab menus. You will see “from file” there.
@@fullnelsondnb have check but not showing PDF tab, pls help
Excellent Thank you very much
What is the pdf file saved in? Where did Excel find it? How did it get jnto Sample data? Did you save it to a folder "sample data"?
Pdf
Thanks buddy, you save me a lot of time and now i can avoid ILOVEPDF
Thank you so much for this seriously.
You are so welcome!
What if I have a bunch of tables (more than 100 pages) to import...
thank you it worked
I just tried this on my own but I don't have the PDF feature w/in the "Data" tab in my 2019 Excel version. I tried doing this in my free-based 365 Excel but nothing there either. Do I have to pay for a 365 subscription to access the Data/PDF feature?
You can solve the problem by opening the PDF in Word and, after that, by copying (with a simple "copy and paste") the table in Excel
@@92ElFlaco I tried that but it says converting PDF to Word is a subscription feature with adobe
same here
Mind-blowing! Thank you so much.
Thank you…. Helpful
When imported all my values are “null”, anyone else have this issue?
Thanks
data tab how to enable in excel cannot see it
Nice video, can I ask a question? I had 4000 pages of pdf file, how can I import this data to excel? because my Ryzen 5 7535HS and my I3 11 series apparently couldnt do that much of import. Can still import it without split the PDF?
Thank you
How to convert all Excel sheets to one PDF page?
Very useful
Nice thanks
Awesome
What if my pdf’s table keep changing based on new data?
It does not work on Mac.
get data option isn't available in excel even I use ms excel 2013
I don't have this option
Yes, neither do I. I think this demonstration is for 365 Excel (premium, paid subscription). I have the 2019 Office suite. Disappointing.
@@chrisvee1004 I have the 365 suite and also don't have this option.
@@kathleenmcclure9869 May i know which plan did you applied for that means standard or premium
This is only applicable with Office 365 ONLY.... what for and how bout to others 2021, 2019, >>>>>????? hopeless ?
I think it is available for Office 2021 now
@@MikeTholfsen nOTHING Too
Yeah its hopeless, im still using the ancient 2010 version
I did not see from pdf and am using Microsoft 11. Can you help?
Looks like this function is not available in the Mac Office version either
upload more videos 🙏🙏
Lots more coming in the new year!
@@MikeTholfsen 👍👍thnks
I am guessing I should be connected to the Internet to do this?
What if there's no pdf option in get data?
Nice
Thank you, you saved me from throwing my laptop out of the window
Unsure but I don't have the PDF option I have Microsoft 365
How do I merge the files if I have more than 1 file?
how i can do this trick on Microsoft world 2007 😕
Not possible unfortunately
in my excel " get data option" no pdf option.
The PDF option is only available in the 365 version office
Hi
Me too, “there is no from pdf” option!
@@jaimeconjo thanks,
in data I dont have from PDF option
Sir, will PDF option show in Office 365 online free version
It does not
Not show PDF option
Which excel version is this
Office 365
@@MikeTholfsen thanks babe
00:01
Amazing video
I wish you would have told me that 10 years ago!
👍
Chat gpt can just do it now
in Mac
Not working
what about the opposite