How to Convert PDF to Excel

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step tutorial, learn how to convert an Adobe PDF file to a Microsoft Excel file.
⌚ Timestamps
0:00 Introduction
0:36 Example PDF with table of data
1:07 How to import PDF data into Excel
4:24 Wrap up
📚 Resources
- PDFgear free PDF editor: bit.ly/3PdTiWG
📃 Watch related playlists
- Playlist with all my videos on Excel: • ❎ How to use Excel
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
🚩 Connect with me on social
- LinkedIn: / kevinstratvert
- Discord: / discord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🙏 Request How To Tutorial Videos
forms.gle/BDrTNUoxheEoMLGt5
🔔 Subscribe to my KZbin channel
kzbin.info?...
🎬 Want to watch again? Navigate back to my KZbin channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ 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

[@KevinStratvert]

🏫 Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY ➡ PDFgear free PDF editor: bit.ly/3PdTiWG

[@santanukumarbal6504]

My Microsoft office 365 has no "From PDF" option

[@melvindias4248]

I dont get the option of pdf in files How to enable it

[@anaana5688]

@@melvindias4248 -thats why I asked, hope some one will share it

[@zikraamin3028]

Hello sir ..Sir office 2016 Excel From File m pdf Wala option nai ha

[@gregmunson7320]

To bad it doesn't work with Excel 2019

[@terribowman7542]

Thank you for not dragging this out and getting to the point. Very helpful!

[@carolfluter]

This is about as amazing as anything I've ever seen. What a huge timesaver! Thank you!

[@johnakidd]

A straightforward way to convert PDF to EXCEL is exactly what I have been looking for. Thanks.

[@richardwaldron1684]

Was sat copying/pasting from PDF table into Excel thinking A it was going to take all day and B there must be a way to import this. Very, very glad you posted this. Really easy and helpful, thank you.

[@hawaiisplantationvillage9175]

Thank you Kevin. This is one of the best tutorial I've seen. Very very helpful!

[@ksltechnology]

Good I find it awesome that the feature is built into excel to make extremely seamless. I never thought this would be possible until seeing you share this tutorial, so thanks for the awesome lesson Kevin. :)

[@KevinStratvert]

Glad it was helpful!

[@toddlasvegas]

I have been using Excel for many years, and I cannot believe I did not know how to do this. So easy, thank you so much!

[@lgdfanny6137]

I'm using Panaforma software to extract data from PDFs in CSV and Excel format. You guys can try it as well.

[@robynjohnston3890]

Thank you so much! I struggle with Excel and am just learning as need it for jobs. Very helpful! some KZbinrs blab on and don't get to the point. I will be watching more of you :D

[@MariaM-fc8pp]

Whoo hoo magic!😀 I love your tutorials!

[@MichaelToub]

I had no idea you could do that, thank you so much!

[@tomarredondo5878]

Your lesson on converting a PDF file to Excel was awesme & easier than I thought. Thank you!

[@generaldvw]

This one made me a hero today...GO Kev!

[@texasseastar]

I’ve needed to know this for the longest time. PDF to WORD is fairly smooth, but PDF to Excel has been a much bigger challenge. It never occurred to me to go through the DATA tab. I will DEFINITELY be giving this a try. Thanks Kevin!

[@ramsajivansahu4585]

How do you do pdf to word please explain

[@texasseastar]

@@ramsajivansahu4585 from the Adobe menu I use FILE/EXPORT TO/MICROSOFT WORD. You can also change the PDF to an image, text, web page, etc. As I listed above, exporting to Excel doesn't work as well (format gets messed up).

[@mohamedadjal8502]

Hi, Professor, you have provide in a lot of effort for these videos, thank you, I have a question if we have for example in cell "a1" the number 10.00 m, how to have this number with the same format in cell "b1 "using a text function or some other function, thank you very much.😃👍

[@sirfiel862]

Hello Kevin, your tutorials greatly help me in my job as educator. "Mabuhay" from Philippines. thanks.

[@2002southzone]

Thanks so much, Kevin. You can't believe how much this helps me to work on my taxes. I just liked & subscribed. Thank you again!!!!

[@RichardIweanoge]

This was really useful. Thanks.

[@Imanbobbi]

OMG....this is indeed a life saver. I have wasted so many hours of my life doing this the hard way lol. Thank you for this

[@rachelm6874]

Thanks Kevin! Very simple to follow!

[@Zukes0915]

Thank you for explaining this slowly, step by step, you made it so easy to navigate. My excel spreadsheet came out beautifully.

[@LoraTange]

You made it look so easy! There were multiple tables in my pdf. When I clicked LOAD, the tables went to a list section to the right called Questies & Connections. When I bring up each table I see a lot of NULL values. There must be extra steps with multiple tables to get them imported correctly.

[@TylerStanczak]

I find it awesome that the feature is built into excel to make extremely seamless. I never thought this would be possible until seeing you share this tutorial, so thanks for the awesome lesson Kevin. :)

[@ramsajivansahu4585]

Does this facility available in excel 2016 ?

[@francoisdejager1478]

So grateful for this excellent and simplified explanations to understand and apply this technology to make me more effective in my work. Thank you, Kevin.

[@dragonintheroom]

Seriously????!!! Kevin!!! Where were you last year?! I absolutely love the simplicity of your solutions. Keep up the extremely valuable content. Already subscribed and notified a couple of videos ago, but this is my first comment. Been slapping my forehead by your solutions... why didn't I think of that. Again... Super valuable KZbin Channel right here!!!!

[@michaelwhite4188]

Hi Kevin! Thanks for the video! Can you also share how we can convert complex notepad to excel format? Like a very complex notepad text 🥲

[@robrayborn1349]

Power Query works wonders on PDF tables! I've found that it doesn't work quite so pretty on PDF files do not have the data within a table. The 'table' is the main factor that makes it easy. However, a PDF without a table (like a Sales Invoice) could possibly import gibberish that might take even longer to clean the data. Any suggestions for PDF importing to Excel where there isn't a table present ?

[@chefSqueez]

This seems to be the easiest and simpliest way to do this. I'm gonna give this a try. Thanks for sharing and explaining!

[@KevinStratvert]

You bet!

[@MrWasphantom97]

Awesome stuff Kevin, really helpful 😄

[@VijaySingh-vd4fv]

Hi Kevin, Hope you r doing fine !! I am not able to see from PDF option in my excel workbook. Kindly suggest why so ? Thanks in advance Vijay

[@artiphoria]

Because he's using Excel 365 not the normal excel.

[@texasseastar]

If file/save as Adobe PDF doesn't appear you can also try PRINT and then change your default printer to Microsoft Print to PDF. Since Adobe is subscription-based that also could be blocking it if you don't have an Adobe account. If you do as nd still can't get it to work it could be a security setting that needs to be changed.

[@Argyll1000]

@@artiphoria That can't be right because I'm using 365 and can't see the PDF option.

[@irenebenavidez4840]

Same here I cant see the PDF option

[@yashwinbhatia3438]

@@Argyll1000 Same problm occurs with me . Can anyone has idea ?

[@ROAMTAJOGI]

Hey do you know telepathy. I was searching for the same few mins back and got this notification. Thank you kevin. You are awesome.

[@ramysami]

I was just trying to do this in the morning.

[@ROAMTAJOGI]

Ramy Samy hahah. Same here

[@fapalakad665]

In nature 14 people think in same way at same time

[@elenapark6213]

Your videos are awesome!!! Thank you Kevin~^^

[@hareemislam6376]

This person shows in a very simple way. Thank you.

[@charlotte213]

Hi Kevin, What version is this Excel? I can't find "From PDF" in "Data - Get Data - From File""

[@pippaknuckle]

Same here, I have an office365 subscription and it doesn't show the pdf file option.

[@versitychogyi8038]

I also can't find that

[@raddinrossvelt1869]

Namaste Sir 🙂🙏 Sir , The Method i am using i already have office 2019 it shows option in data . you can try sir 🙏

[@yepsyeps5953]

Same here

[@pphotCalvin]

Same here😢

[@tashaero]

Hey Kevin! This is great. But I don't have the 'From PDF' option. Is there any way I can get that on the list?

[@jahidulsourav1001]

Same. Which version of MS office are you using?

[@tashaero]

@@jahidulsourav1001 I'm using MS Office 365 Pro Plus

[@techbasics6142]

Same here

[@hussainfawzer]

This is a new feature. It takes time to roll out to all office 365 version.

[@TheLaopi]

Hi in excel 2016 there ns no option fron pdf 😟😟

[@user-to3bg1en9o]

you are one of the most diligent youtuber. almost one video per day. yeah.

[@un_knownn_]

Dude Kevin you just saved my whole day by this. Thanks a lot.

[@user-sf1cf3fj3t]

how about on a Mac?

[@albinfrancis7480]

Wonderful Kevin, helps a lot!

[@bmo3778]

If you have Ms. Office 2019, you can do this: 1. Open pdf in Ms. Word 2019 　a. use "open with" on the pdf or "file>open" in Word 　 b. don't use drag-and-drop 2. Clean the word wrap problem 　a. select the table 　b. open "replace" dialogue 　c. enter the input "^p" for paragraph mark or using the special character menu 　d. enter the output " " for space or blank if you want 　e. replace all 3. Copy and Paste to Excel (straight forward)

[@ziyanshaik9650]

Thansk ❤️

[@KevinStratvert]

Love it! Very nice workaround 😂

[@adamkabich3130]

this option doesn't appear on my excel 2019.

[@lolsuper40]

This is just what i want thanks so much Kevin;

[@rafiqfazaldin5873]

Thanks for the clarity in your explanation. It surely did help. Thank You for your efforts.

[@MehrdadIrani24]

Thanks Kevin, that is great! Unfortunately I don't see "From PDF" in the list of "From File" under "Get Data". Is there a way to activate the From PDF in that list?

[@pregnant.tomboy]

I have the same issue too!

[@pregnant.tomboy]

But I went to pdf and exported to Excel. Still works!

[@Testercams]

Same with me

[@SofiaLagarini]

same here, and not an answer, what office is kevin using?

[@workforcedagupan6129]

my excel file has no pdf to excel converter

[@missyphillips437]

Me also! I am at a public library and no luck!

[@Anisabell2]

My God Kevin, you read my mind! Thank you, thank you, thank you!

[@koreeWatley]

Love your videos - always give me what I'm looking for

[@joanevangelio5900]

Hi Kevin! I have followed your instructions but there is no PDF included the choices in the "Get Data" dropdown. I am using 2019 Microsoft license. Please help me. Thank you in advance.

[@ambarcatalan9604]

same :(

[@dilshanmadhuranga1237]

Same

[@hinajade7407]

Same

[@scottng8171]

Dang...., getting a third party PDF converter now looks so dumb.

[@hotstepper1734]

You, Kevin, are a national treasure.

[@mzeechuma]

Thanks Kevin for the tutorial, now I know how

[@casimirodasilvasantoshe-hi5797]

Kevin, is there away in TEAMs to upload the presentations we want to use from PowerPoint before the meeting starts?

[@KevinStratvert]

yes! Check out the following video: kzbin.info/www/bejne/rHe0fZSkgJx6n5Y

[@paolagarcia6106]

I have a question, The option is only available for the microsoft porducts in USA? Because I can´t see the option in my excel program!! Thanks so much!

[@muhammadzahid3130]

Any answer of your question?I have same problem.

[@abelamengual3028]

Same happens to me 🤷🏼‍♂️

[@mutiullahkhan9583]

Same problem! I am using Ms office (2016) and in excel spreadsheet we don't have the option of "From Pdf". Plz guide

[@wanfahmi7269]

I hear it said from the latest version excel 365

[@engtap2850]

I am also not getting this option

[@RA-rh5lb]

Thanks Kevin, for the short but informative video on pdf to exce conversion

[@thebattlefamily4784]

Thank you Kevin!! You are the MVP ❤️❤️🔥🔥🔥

[@hyamsinvestments784]

I don't have the "Get Data" tab on the Data page of Excel... Any ideas

[@mikebyrne7021]

I have the same problem. I click DATA and where Kevin's page shows "Get Data" my page shows from HMTL & another option

[@Ishtarthemoon]

@@mikebyrne7021 i think if you have an older version of excel that's why. mine is the same. i'm going to try importing the data into word first that could be a workaround.

[@MohamedElghaber]

me 2

[@colinelliott5629]

My version of Excel doesn't offer pdf. I have icons for Access, Web, text, and 'other'. Under other, it offers two types of SQL, XML, unlisted (OLEDB), and Query (ODBC). Currently, I'm using a mixture of sorting, text functions such as LEN, and 'text to columns', but it involves a fair amount of manipulation.

[@dineshkumarl8309]

Same here. Did you figure out what we are supposed to do?

[@colinelliott5629]

@@dineshkumarl8309 I'm sorry, but no.

[@guliqbal7403]

This amazing! Thank you so much for sharing this !🤗

[@fookth88]

Very clear step by step tuition. Much much better then those in Tiktok which are extremely fast until you can't even see how they did it.

[@ALANsLab]

Next Video Record ur Screen and and Webcam (dont disturb ur screen by ur webcam) Like PRO GAMERS

[@ALANsLab]

WHO IS SUPPORTING ME to make a video like this?

[@dereklezly6299]

YEAH KEVIN MAKE A VIDEO LIKE THAT

[@jayanthirani5739]

Yes Kevin

[@stevenst2439]

Yes

[@aaronsteve854]

Yes Kevin

[@TeacherKay]

Thanks @Kevin for Awesome tutorial

[@officefrontremax9331]

I am going to watch all your tutorials. You are awesome.

[@Miharifeno]

Great tutorial and timesaver! thank you!

[@EMZ_LAFREE]

You are a blessing to me Mr. Kevin. Thanks......

[@tanmaysawant496]

Thank you for giving me this information, It helps me to work & save me 80-90 % of the time.

[@julieyu646]

Brilliant! Exactly what I wanted!! Thanks!

[@SamanthaWhite-nu6tr]

Thank you, this was really helpful and easy to understand. Great job.

[@putriestimandasari8904]

Exactly what I need. Thank you Kevin !! :)

[@kevinjhonmarzon2823]

I've d been searching this for long. thanks so much Kevin.

[@Persevere.x]

AMAZING! Perfect for dealing with quickbooks

[@techguyweebee8806]

I wouldn't be able to breathe properly without Kevin Startvert and Leila Gharani explaining Excel to me!

[@akshayuppala9295]

I just found out importing data from text a few days ago. It was helpful in my maths assignment

[@ChristopherGreenwell]

Kevin!!!... you are a rock star. Thank you!

[@user-hn8pc7mg8f]

Thank you Kevin!

[@ManjaroJam]

An interesting task to cover is a multiple-page Excel document scanned to pdf. Laser printers allow users to scan excel xls or its variations, to pdf. Try scanning multiple Excel pages and save them as a single file by using the native scan software of the printer. For example, xerox has its own scan software and pdf converter. a 10 page scan in to PDF will do. Then see if you can convert the originally scanned excel document to PDF back in to Excel.

[@vidhyasubramanian3549]

You made it so easy for us. Thank you

[@annkeys7]

Your presentation is clear and easy to follow. Thank you.

[@0525carla]

You are a great help for me since I really don't have knowledge about excel, thank you so much.

[@donnafletcher5386]

Thanks, Kevin. Appreciate it. Make my life easier.

[@milanchavda8044]

Wow this is amazing… Thank you Kevin

[@gilenagarra5354]

Thank you, Kevin. This is very helpful!

[@EliMTL]

Thank you! You saved me from hours of copy and pasting! Well done video!

[@akashbhatt6680]

My friend you are a life saver. Thank you so much for this information

[@zimmejoc]

excellent. I just found a PDF that I need to import into Excel while I was watching your video. In fact, I started watching your video to avoid typing the data in by hand. Now I don't have to! I love it when serendipity looks my way.

[@louisyassa8175]

Hello Chris, which version of excel are you using, I have Office 365 and I don't see that option. Thanks

[@zimmejoc]

@@louisyassa8175 At home, I have 2016 and it worked like a charm. In my office, I have 365, and I don't have that option either. A quick search finds numerous instances of 365 users doing just as Kevin does and pulling a PDF into Excel in Office 365. I wonder if it is a versioning thing? At work I'm using version 11929.20838 while Microsoft says the most current version is 13127.20296.

[@relaxingiru]

@@zimmejoc chirs can you send me link

[@zimmejoc]

@@relaxingiru link to what?

[@arunaananthram2902]

Thanks for this, great help

[@kemoycutenar9482]

Very simple and to the point!

[@blumendoza5801]

This is great man. Its really helpful thanks

[@johnkanini6870]

This was very helpful. Thank you Kevin.

[@methos-ey9nf]

Hugely helpful - pushed off having to get an Adobe account for just a little longer!

[@mahmudulhasanmahir]

Thank you so much Kevin for this tutorial.🙂

[@SaryuPatel-vr3ze]

Thank you. Your instructions were very clear and easy. Thanks

[@MarS-bo9dp]

That is great! Thank you so much; you are awesome. Gracias!

[@joannaj5369]

Helpful video! When I follow your steps, however, I get queries and can't figure out how to resolve them. Would you be able to do a video on that? I'm converting a loan amortization pdf and want to reconstruct the formulas. Thanks!

[@1hjehje]

Very useful. Thank you!

[@aveavilado1389]

So helpful thank you, looking forward to see more informative videos like this!

[@brianndlovu1173]

Thank you so much Kevin, you make life pretty easier!

[@judithlee4314]

Thank you so much Kevin.

[@mike-iy6yr]

Very easy to follow, thank you Kevin

[@mariegracemedina276]

Thank you that was very helpful!

[@dubaitravelexpert]

Amazing tip. Thank you sharing