Convert Table in a PDF File to Excel

Have you ever wanted to get a data table in from a PDF file into excel so you could do some further analysis or charting? There's not a PDF to Excel converter capability though some websites have tools to do this for you (but if you have confidential information you'd wouldn't want to upload it to a 3rd party site). One way to extract or import a table in from a PDF file is to use an intermediary application and Microsoft already makes one....Word! This is probably the best way to do it if you already have Office applications since it is free (it's almost like copy and paste). You don't need to go online to use any tools, so see how this could be done quickly and easily :-)
Got Power Query? See it done here • Power Query - Convert ...
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 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 / doughexcel
#excel
#msexcel
#doughexcel

[@ericrichardruka9580]

So glad I've find this video. Thank you so much. It saved a lot of time !

[@DougHExcel]

Thanks!

[@davidbank336]

Thanks Doug, I failed a management accounting exam last year because I messed up on copying over vast amounts of data from tables, and missed a few key ones in the clutter. Your video made this much easier for me as I am prepping for the re-exam

[@DougHExcel]

Hi David Bank...you're welcome, glad you liked!

[@billyoung8118]

I'm a statistician for a commercial insurance agency. I can't even begin to tell you how many hours I have wasted over my 20+ years of doing this work, either manually retyping PDF data or doing all kinds of text extraction formulas for well behaved tables when copied into Excel. I have a degree in electrical engineering, so I'm no idiot. But this really make me feel like one for wasting so much time doing this work when relying on Word is so simple. Thank you for posting this approximately 2.5 years ago!

[@DougHExcel]

Hi Bill Young, thanks for the comment! I've often been pleasantly surprised by what Excel (and other MSFT apps) can do and the best part is they are usually so readily available. Glad you liked!

[@LostinTranslation479]

I just wanna hug you
You saved me a lot of time !! And I've been watching tons of useless video until i came across yours
Thaaaaaaaaaaank
Youuuuuuuuuuuuu
♡ xoxo

[@DougHExcel]

You are welcome!

[@jackflash5659]

Excellent tutorial Doug. Thank you very much!

[@DougHExcel]

You’re welcome! Thanks for the comment!

[@zephyx3]

Good guy Doug. Thanks for helping me save time

[@DougHExcel]

Thanks Zephy, glad it helped!

[@goodcharlotteden]

This is so very helpful! Saved me so much time. Finally a video that actually helped me out! Appreciate your help!

[@DougHExcel]

Glad it helped. Thanks for the comment!

[@jimstuebner6624]

Thanks, Doug! Saved me hours of time!

[@DougHExcel]

Glad it helped!

[@angelm3684]

Doug, you are the man! Thanks so much for this.

[@DougHExcel]

My pleasure!

[@winebottle520]

Your video is a life savor for me! Thank you so much for posting it!!!! :D

[@DougHExcel]

Thanks Adventure Chicken, glad it helped!

[@sangeetakatre]

Extremely useful. Thanks a million!!

[@DougHExcel]

Glad it was helpful!

[@arminpalang2327]

UA-cam should give you a medal of HONOR!

[@DougHExcel]

Thanks for the kind words! 😁

[@JackBoeau]

Many Thanks! Helped a lot! :)

[@DougHExcel]

Glad it helped!

[@bobloly1190]

Worked great, thank you!

[@DougHExcel]

You're welcome!

[@erencelik2490]

You saved my life. Thank you brother.

[@DougHExcel]

You are welcome!

[@lancairtalk7237]

This video saved a lot of time. Excellent.

[@DougHExcel]

Glad it helped!

[@satyamsingh3755]

It was a great help

[@ferdisnyman1041]

Thanks, Doug, very helpful. Much appreciated

[@DougHExcel]

Glad it was helpful!

[@whoisarod]

I needed this!!!

[@DougHExcel]

:-)

[@donnalee3368]

Excellent tip!!

[@DougHExcel]

Glad you think so!

[@777Justin]

This worked well. Thanks.

[@DougHExcel]

You're welcome!

[@stevennye5075]

This is a huge time saver.

[@DougHExcel]

Hi Steven Nye, glad you liked it, thanks for commenting!

[@TimothyDeck]

This just helped me out. Thanks

[@DougHExcel]

You’re welcome, glad it helped!

[@taylorscottkennedy2]

Saved me 2 hours today. Thank you thank you thank you.

[@DougHExcel]

Great to hear! You're very welcome!

[@nkmoorthybe]

It is helped me lot! I strucked for long time! Thank you Doug H

[@DougHExcel]

You’re welcome!!

[@anushamuddanna8261]

Now, that was very helpful!! Merci :)

[@DougHExcel]

Glad it was helpful!

[@averageheightwizard4798]

best way I found thanks!!

[@DougHExcel]

Hi Average Height Wizard, thanks for the kind words!

[@zacharyclarke4991]

GOAT! You saved me so much time, Thanks!

[@DougHExcel]

Glad to hear it!

[@bindur1765]

Stay blessed 🙏. You saved whole lot of time

[@DougHExcel]

Hi Bindu R, thanks for the kind words!

[@Scruklemush]

OMG thank you so much! You saved me a tremendous amount of time, definitely subscribing to you.

[@DougHExcel]

Glad I could help! And thanks for the sub!

[@jayabanerjee2284]

Thank you sooo much man!!❤️❤️❤️

[@DougHExcel]

You’re welcome ☺️!

[@emilym6994]

Super helpful! Thank you!

[@DougHExcel]

So glad!

[@fernandodavidez757]

You saved you tons of time, thank you!!

[@DougHExcel]

Glad it helped!

[@dylandouglas4890]

Very nice. You just saved me a lot of time at work

[@DougHExcel]

Thanks Dylan Douglas, glad it helped!

[@cindijackson6810]

Nice! Thank you!!

[@DougHExcel]

You’re welcome!

[@stephaniekayreyes1608]

this video deserve a thumbs up

[@DougHExcel]

Hi steph R, thanks for the kind words!

[@funsky77]

I never knew word can open pdf! Thank you! 🙏

[@DougHExcel]

You’re welcome!

[@am8464]

Life saver. Thank you!

[@DougHExcel]

You're welcome!

[@MiguelPisani]

Worked. Thank you.

[@DougHExcel]

Glad it helped!

[@googleram2935]

Love you bro 🔥

[@DougHExcel]

Hi Google Ram, thanks for the comment!

[@shana7456]

Awesome!!! Thank you

[@DougHExcel]

You're welcome!😀

[@rodrigofaustino8000]

Very helpful! Thank you!

[@DougHExcel]

Glad it was helpful!

[@bigwavedave94583]

excellent! How can ANYBODY complain! Good job!

[@DougHExcel]

Hi bigwavedave94583, glad you liked it, thanks for commenting!

[@rupalijadhav7290]

Thank you.. this saved a lot of time...thank u soo so much

[@DougHExcel]

Welcome 😊

[@moghost]

Thanks. Help a lot in sorting data from pdf table.

[@DougHExcel]

Glad it helped

[@BenjieTS]

you save hours of my life, thank you!

[@DougHExcel]

Glad to hear that!

[@AnkiandIshu]

Thank you so much for the tutorials. It worked. :)

[@DougHExcel]

Great to hear!

[@ame12334]

Thank you so much!

[@DougHExcel]

You’re welcome!

[@anubharaghuwanshi5611]

obviousslyyyy it is chaarrmiingggg .... thanks for recommending

[@DougHExcel]

Thanks for the comment!

[@alandumezweninare9601]

You are a life saver. I was trying to manually enter figures from a pdf until i decided to look for a youtube video

[@DougHExcel]

Thanks ADN, glad it helped!

[@Rochy1969]

Great video!!!

[@DougHExcel]

Glad you liked it!

[@ricardojohnsonthon7547]

Thank you Doug!

[@DougHExcel]

Welcome!

[@kavikumar816]

very handy. thank you

[@DougHExcel]

You’re welcome!

[@1aditya11]

Thanks bro
U saved my alot of time

[@DougHExcel]

You’re welcome!

[@charviethakore651]

saved time.. really!! Thanks a lot!

[@DougHExcel]

You're welcome!

[@radu0505]

I don’t understand the 84 dislikes you got in the video. You went straight to the point of the title of the video. Good job bro. It helped me out a lot !!!

[@DougHExcel]

Hi radu0505, thanks for the kind words!

[@sukrucuneytfazl1183]

Perfect job bro

[@DougHExcel]

Gladly you thought so!

[@WCephei77HD]

Brilliant!

[@DougHExcel]

Thanks!

[@AnkitTiwari-pb7xd]

Thank you very much sir
Am glad

[@DougHExcel]

Most welcome!

[@estalin9418]

Thank you!!

[@DougHExcel]

You’re welcome!

[@Hugo-xj2mj]

Thank you!

[@DougHExcel]

You’re welcome!

[@Habeshacurls28]

this video helpd me a lot, thank you

[@DougHExcel]

Glad to hear it!

[@LetitiaJM]

Thank you. You are amazing

[@DougHExcel]

Glad you liked!

[@TheBirdcagee]

Thank you so much!!!!!!!!

[@DougHExcel]

You're welcome!

[@nicola6890]

Thank you so much. It works!

[@DougHExcel]

You’re welcome!

[@user-rj8be6su8h]

thank you so much! this helped me a lot!

[@DougHExcel]

Glad it helped!

[@rainierfernandez5661]

this is so helpful thank you 😭😭😭😭😭

[@DougHExcel]

You’re welcome ☺️ !

[@nemepito]

Thank you Master!!

[@DougHExcel]

You are very welcome

[@mahandrsinghpardeshi9171]

so much thanks dude

[@DougHExcel]

You’re welcome!

[@sandraescauriazarubio9629]

Your video is super helpful, I am in accounting and need bank and credit card statements, this is a God send. Thanks!!

[@DougHExcel]

Glad it was helpful!

[@rawani2601]

Super easy thank you💗

[@DougHExcel]

Hi Rawan Alali, glad you liked it, thanks for commenting!

[@tramhuynhthingoc2455]

oh my goh, u made my day. thank you!

[@DougHExcel]

Glad it helped!

[@Jamcam99]

Perfecto Doug. Thanks.

[@DougHExcel]

Thanks for watching!

[@xinGXW]

very useful!

[@DougHExcel]

Thanks for the comment!

[@naveens5017]

Awesome , simple fix to my big problem ;-)

[@DougHExcel]

Thanks Naveen S, glad it helped!

[@nnirmalkumar3719]

Very good, thank you!

[@DougHExcel]

Hi N Nirmalkumar...you're welcome, glad you liked!

[@tankylube3077]

Thanks man

[@DougHExcel]

Happy to help

[@amoreokko4602]

Thank you very much

[@DougHExcel]

You are welcome!

[@bimalakunwar9786]

thank you so much !

[@DougHExcel]

You're Welcome!

[@michellestankovic5727]

saved my life fam

[@DougHExcel]

Glad it helped!

[@pwillis7220]

Great video. Thanks

[@DougHExcel]

You're Welcome!

[@kasmindanil5527]

thanks a lot for sharing, god bless you !

[@DougHExcel]

Hi Kasmin Danil, glad you liked it, thanks for commenting!

[@alperenuiucak5872]

thanks a lot dude you are awesome

[@DougHExcel]

You're welcome!

[@sachinkishore4115]

Thank you bro

[@DougHExcel]

Any time

[@quentinjanssen5624]

Thanks!!!

[@DougHExcel]

You bet!

[@kolorowaguma]

Thank you so much :D

[@DougHExcel]

You're welcome!

[@rabiamir7731]

Love u save my lot of time😀

[@DougHExcel]

Glad it helped!

[@monkeyman8671]

yoo this really helpful thanks m8

[@DougHExcel]

Hi Monkey Man, thanks for the comment!

[@budoorsalem8378]

thank you
that was helpful

[@DougHExcel]

Glad it helped!

[@sulaimanaloraini4212]

Thank you a lot that is super useful

[@DougHExcel]

Glad to hear that!

[@pragyabhartisharma3805]

Thank you 😊😊❤️❤️ thank you so much ❤️💕💕💗💗🙏🙏🙏

[@DougHExcel]

You’re welcome! 🙏 🤗

[@mecha_engineer]

Thank u so much

[@DougHExcel]

You’re welcome!

[@dheeru022]

Thanks a lot

[@DougHExcel]

Hi K D, you're welcome!

[@MathRoot]

Thanks buddy

[@DougHExcel]

You’re welcome!

[@gabemillee3726]

Thanks it really did

[@DougHExcel]

Thanks Gabe Millee, glad it helped!

[@sanchitasurbhi1491]

Thank you

[@DougHExcel]

You’re welcome

[@jco_ii8042]

Thank youuuuuu!!

[@DougHExcel]

Hi John Ortega, you're welcome!

[@HeiseSays]

Thanks :)

[@DougHExcel]

Welcome!

[@nathanhol99]

Wow I could have saved myself so much time, now I know, thank you :)

[@DougHExcel]

You're Welcome!

[@hillarykoske760]

works thanks

[@DougHExcel]

Hi Hillary Koske, you're welcome!