How to Convert PDF to Excel

[@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

[@milkyrosepabelic172]

My office 365 doesn't have get data from PDF. How to solve this issue Kevin?

[@DSeisun1]

Thanks! Well worth a little $$ thank you.

[@terribowman7542]

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

[@ShastaBean]

a 30 sec demo = not dragging out a >5 min+ video = not not dragging out

[@karenbork706]

Thanks!

[@KevinStratvert]

Wow, thanks so much! Much appreciated 🙏

[@carolfluter]

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

[@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.

[@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.

[@techguyweebee8806]

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

[@johnakidd]

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

[@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!

[@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?

[@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

[@mike-iy6yr]

Very easy to follow, thank you Kevin

[@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

[@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.

[@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).

[@johnkanini6870]

This was very helpful. Thank you Kevin.

[@workforcedagupan6129]

my excel file has no pdf to excel converter

[@missyphillips437]

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

[@JoannaKaupa]

Mine too

[@benjamintucker9829]

Kevin, You have best instructional videos, super helpful

[@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😢

[@officefrontremax9331]

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

[@MariaM-fc8pp]

Whoo hoo magic!😀 I love your tutorials!

[@roberttaylor1364]

Thanx, that pathway of efforts was Spot ON!! Perfect...

[@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 ?

[@njemilenantan2269]

Thank you so much. Adobe was charging me so much for this facility.

[@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 😂

[@charlesdavis6041]

Excellent tutorial on importing data!

[@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

[@kumkumzummy2957]

Same

[@tiyamikernmaziya1328]

Brilliant!!! Saved me a world of work...

[@hawaiisplantationvillage9175]

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

[@EliMTL]

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

[@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 ?

[@courageonyemaechi2096]

I would love to know too

[@SaryuPatel-vr3ze]

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

[@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

[@kemoycutenar9482]

Very simple and to the point!

[@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?

[@jsourav1001]

Same. Which version of MS office are you using?

[@tashaero]

@@jsourav1001 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 😟😟

[@dancoffey4293]

This is so good I can't believe it. You are the absolute best!!!

[@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?

[@Tomboy.bakery]

I have the same issue too!

[@Tomboy.bakery]

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?

[@Gan8325]

Very well explained. Thank you so much.

[@MichaelToub]

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

[@annkeys7]

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

[@RichardIweanoge]

This was really useful. Thanks.

[@ahmedshakebzubairi25]

Excellent Video. You are a consistent high performer

[@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 ?

[@boymalinao963]

Thanks kevin.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!

[@MusicMediaAlappuzha]

Thanks👍

[@CourtneyHsu]

how about on a Mac?

[@kevinjhonmarzon2823]

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

[@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

[@angelalitchmore5033]

Fabulous this lesson came in handy today.

[@scottng8171]

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

[@mara112308]

quick easy and plain... a great vid. Thank you so much..

[@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 🥲

[@lakelife5467]

Great detail explanation!

[@adamkabich3130]

this option doesn't appear on my excel 2019.

[@hotstepper1734]

You, Kevin, are a national treasure.

[@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

[@brianndlovu1173]

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

[@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.😃👍

[@olunicholas4362]

Thank you God bless you Kevin 🙏 all the way from Africa

[@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.

[@anyarediary6960]

Thank you so much... Life saver... ❤ I love your channel... More tutorials to come...

[@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

[@santanu2098]

Thank You Kevin, Really a helpful video !!

[@lunyteve]

That's awesome! Thank you for this video

[@mahmudulhasanmahir]

Thank you so much Kevin for this tutorial.🙂

[@mscolumbiatiger]

Thank you!!! Such a great tool! Much appreciated!

[@reginaldfairley3451]

Kevin you should change your last name to Smart! This was exactly what I needed! Very informative and to the point 👍 👏

[@dhingradimple]

Thanks Kevin. Never knew it that easy.

[@EDRISSALEXIS21]

Thank you! This one worked perfectly.

[@lightmo_99]

Thanks man! This is really helpful :)

[@roshanKumar-jr7tv]

Hey Kevin I just benefit so much from you bro thanks for sharing such valuable information…

[@markgreen2170]

excellent, I'm going to try it tomorrow when I get to work! thanks!

[@delboykinobi5273]

Cheers dude Very helpful 2 thumbs up 👍👍

[@孟依昌]

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

[@brofarez]

Terima kasih boss ... From Kuala Lumpur

[@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.

[@dynnisel9994]

sawwweeeet! Worked really well! Thank you!

[@angelacummings3279]

This has been soooooo helpful!!!!❤❤❤❤

[@vancejochim1439]

Excellent help. Much easier than paying Adobe $19/mo to convert pdfs to worksheets. Stratvert rules.

[@sivakrishna7298]

Great info. Thank you!!

[@raymondchika7139]

Nice one buddy. Thumb up.

[@Prsvrxfit]

AMAZING! Perfect for dealing with quickbooks

[@ANHUYNH-ov3cx]

Thanks Kevin , this is my good teacher .

[@thecosapu._.]

Thank you, it's really helpful.

[@sirfiel862]

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

[@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

[@naomibrown2504]

you are an awesome teacher

[@muaykaliente4386]

Thanks dude that was really helpful 👍

[@jessemendoza4044]

Thank you for the tutorial it is saving me so much time.

[@myoneblackfriend3151]

Thank you, Kevin. I'll try it.

[@JunkAccount-ig8st]

Excellent video! Thank you!!!

[@rojopayra4lr534]

Thanks, your speech is very clear that is imagine

[@edwardm9788]

Good one. I have just subscribed to Excel MS 365, making life a little easier. Thanks Kevin

[@hectorvillavicencio898]

Thanks Kevin for showing a clear step-by-step to convert the pdf to excel. Quick question, I did that, but was unable to add the columns in excel. How do I convert the number-data so I am able to analyze it?

[@rubymermaid7005]

THANK YOU SO MUCH!!! It worked like a charm. I did have to load one table at a time, however. When I tried loading more than one, I got a message that the data was downloaded, but I couldn't see it. Small price to pay - I only had 4 tables.

[@pedromonsivais657]

I just downloaded a 30 day trial Excel 365 but my version looks a little different than this, get data from PDF option doesn't show like on this video. Any idea? I downloaded the free 30 day version to see if it works before I buy. Thanks

[@DIRECTORE]

very helpful !!!!!! thank you