Importing or converting a table from a PDF document into Excel can be a difficult process. You might have been doing a copy and paste and editing or deleting our strange characters, spaces or tabs. Whether it was a small table or large one, it’s a time intensive process. If you’ve got the Microsoft 365 subscription (formerly Office 365 or O365), you might have the latest features from Power Query to help make this an easier process. If you don’t have Power Query, it still can be done but with another Microsoft application – Word (see that video here at
🔔 SUBSCRIBE to my channel ➜
🏫 Excel Training ➜
📚 Excel Books & Tech Gear ➜
⚙️ Tools: Screencasting ➜
⚙️ Tools: Microsoft Office ➜
⚙️ Tools: TubeBuddy ➜
📝 This description may contain affiliate links and we’ll receive a small commission if a purchased is made using the links (but at no additional cost to you). It’ll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to
#excel
#msexcel
#doughexcel…(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
Hi Doug. Thanks for the great tips. I've tried this and it can be very handy. Thanks for sharing. Thumbs up!
I have Office 2019 stand alone, not 365. Is Power Query available for Outlook 2019? I've been searching and I am not able to find any talk about it. It is available for Excel 2019.
I have gone through your video"Lookup a valu from Multiple Tables posted on Feb 6,2019" pl make a video on the same example
using POwer query insted of Vlookup+indirect.Thanks.
BEAUTIFUL. Nice clean-up. And Import from PDF is a great new feature for lots of people.