🏫 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: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html ➡ PDFgear free PDF editor: bit.ly/3PdTiWG
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.
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.
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 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.
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.
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)
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 ?
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 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).
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.
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.
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!
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.
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
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. :)
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?
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. :)
OMG where was this info last year (at least for me) I could have used this so many times for my teacher reports ! This year I am going to use it and I know I will be seen as expert!!!! Thanks Kevin you are my hero.
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?
Thank you so much! I struggle with Excel and am just learning as need it for jobs. Very helpful! some TH-camrs blab on and don't get to the point. I will be watching more of you :D
Saved me a lot of time, thank you so much. I was looking around and be like do I really gotta retype everything out of hundreds of pdf files to make a spreadsheet?
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.
@@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.
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.😃👍
This is an AWESOME video if I can only get it to work as I am hoping someone here will be able to provide direction. I have checked and I have the most recent version of Excel but I dont have that button he is referring to it is only GET EXTERNAL DATA which is not reflective of the video. Also see comments below about how to update and I dont have any ACCOUNT button. I apologize as I am not tech savvy and desperately need to convert working PDF files for data. Any help is appreciated. Thank you.
very helpful, thank you! I may import up to 500 part numbers listed in a chart in a PDF document. Sometimes I have to insert the 4 row after every other cell in Excel. Can you help with that. To make it more complex, I may Have to import row 3 and row 4 from the PDF chart to a cell in Excel below each other instead of side by side as shown on the PDF. Would love to show you the PDF. I have more complex scenarios importing from PDF chart to Excel.
Hi Kevin, this is very helpful to my work now. Here is my question...I download PDF documents with pre inserted ,,, (comas) in it but I want to remove ,,, (comas), could you please help me to remove all these comas after converted to excel format?
Thanks for the video! Unfortunately I have this option INactive.. Searched on the web a bit regarding it, but could not figure out why? Can you help with that, Kevin?
Hi Kevin, thank you so much for your tutorials which are super handy! For this one convert PDF to Excel, really want to use this function but in my Excel, after clicked the "Data", the "Get Data" icon doesn't show up. Do I need to pre-set something? I am using office 365 from my Uni. Thank you so much!
HI Kevin So sorry to ask but it seems like my version of the app (Excel) doesn't support the option of ^^From PDF^^ for some reason . I will really appreciate if you explain to us why ? i am so in need of this feature TNX
🏫 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: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
➡ PDFgear free PDF editor: bit.ly/3PdTiWG
My Microsoft office 365 has no "From PDF" option
I dont get the option of pdf in files
How to enable it
@@melvindias4248 -thats why I asked, hope some one will share it
Hello sir ..Sir office 2016 Excel From File m pdf Wala option nai ha
To bad it doesn't work with Excel 2019
My office 365 doesn't have get data from PDF. How to solve this issue Kevin?
Thank you for not dragging this out and getting to the point. Very helpful!
a 30 sec demo = not dragging out
a >5 min+ video = not not dragging out
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.
I wouldn't be able to breathe properly without Kevin Startvert and Leila Gharani explaining Excel to me!
my excel file has no pdf to excel converter
Me also! I am at a public library and no luck!
Mine too
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.
This is about as amazing as anything I've ever seen. What a huge timesaver! Thank you!
A straightforward way to convert PDF to EXCEL is exactly what I have been looking for. Thanks.
Your lesson on converting a PDF file to Excel was awesme & easier than I thought. Thank you!
This one made me a hero today...GO Kev!
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.
Hello Chris, which version of excel are you using, I have Office 365 and I don't see that option. Thanks
@@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.
@@zimmejoc chirs can you send me link
@@relaxingiru link to what?
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
Because he's using Excel 365 not the normal excel.
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.
@@artiphoria That can't be right because I'm using 365 and can't see the PDF option.
Same here I cant see the PDF option
@@Argyll1000 Same problm occurs with me . Can anyone has idea ?
Thank you so much. Adobe was charging me so much for this facility.
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)
Thansk ❤️
Love it! Very nice workaround 😂
Kevin you should change your last name to Smart!
This was exactly what I needed! Very informative and to the point 👍 👏
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
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.
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 ?
Thank you! You saved me from hours of copy and pasting! Well done video!
Hey do you know telepathy. I was searching for the same few mins back and got this notification. Thank you kevin. You are awesome.
I was just trying to do this in the morning.
Ramy Samy hahah. Same here
In nature 14 people think in same way at same time
Hello Kevin, your tutorials greatly help me in my job as educator. "Mabuhay" from Philippines. thanks.
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!
How do you do pdf to word please explain
@@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).
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!
I'm using Panaforma software to extract data from PDFs in CSV and Excel format.
You guys can try it as well.
Dang...., getting a third party PDF converter now looks so dumb.
Thank you God bless you Kevin 🙏 all the way from Africa
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.
same :(
Same
Same
Same
Hi Kevin, What version is this Excel? I can't find "From PDF" in "Data - Get Data - From File""
Same here, I have an office365 subscription and it doesn't show the pdf file option.
I also can't find that
Namaste Sir 🙂🙏 Sir , The Method i am using i already have office 2019 it shows option in data . you can try sir 🙏
Same here
Same here😢
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.
Whoo hoo magic!😀 I love your tutorials!
You, Kevin, are a national treasure.
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!
Any answer of your question?I have same problem.
Same happens to me 🤷🏼♂️
Same problem!
I am using Ms office (2016) and in excel spreadsheet we don't have the option of "From Pdf". Plz guide
I hear it said from the latest version excel 365
I am also not getting this option
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.
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
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?
Same. Which version of MS office are you using?
@@jahidulsourav1001 I'm using MS Office 365 Pro Plus
Same here
This is a new feature.
It takes time to roll out to all office 365 version.
Hi in excel 2016 there ns no option fron pdf 😟😟
Hi could you add a video for how to download a PDF bank statement and manipulate this is power query. Thanks for all the great videos.
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. :)
Glad it was helpful!
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?
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. :)
Does this facility available in excel 2016 ?
OMG where was this info last year (at least for me) I could have used this so many times for my teacher reports ! This year I am going to use it and I know I will be seen as expert!!!! Thanks Kevin you are my hero.
how about on a Mac?
You are a great help for me since I really don't have knowledge about excel, thank you so much.
Thank you Kevin. This is one of the best tutorial I've seen. Very very helpful!
Thanks Kevin , this is my good teacher .
this option doesn't appear on my excel 2019.
Yes, it's very helpful video which I found on TH-cam
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?
I have the same issue too!
But I went to pdf and exported to Excel. Still works!
Same with me
same here, and not an answer, what office is kevin using?
Thank you so much! I struggle with Excel and am just learning as need it for jobs. Very helpful! some TH-camrs blab on and don't get to the point. I will be watching more of you :D
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 🥲
Thanx, that pathway of efforts was Spot ON!! Perfect...
I had no idea you could do that, thank you so much!
Thank you for explaining this slowly, step by step, you made it so easy to navigate. My excel spreadsheet came out beautifully.
This was really useful. Thanks.
Saved me a lot of time, thank you so much. I was looking around and be like do I really gotta retype everything out of hundreds of pdf files to make a spreadsheet?
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.
Same here. Did you figure out what we are supposed to do?
@@dineshkumarl8309 I'm sorry, but no.
Your presentation is clear and easy to follow. Thank you.
I don't have the "Get Data" tab on the Data page of Excel... Any ideas
I have the same problem. I click DATA and where Kevin's page shows "Get Data" my page shows from HMTL & another option
@@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.
me 2
Thank you. Your instructions were very clear and easy. Thanks
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.😃👍
excellent, I'm going to try it tomorrow when I get to work! thanks!
Kevin, is there away in TEAMs to upload the presentations we want to use from PowerPoint before the meeting starts?
yes! Check out the following video: th-cam.com/video/vFQLanK7Gi4/w-d-xo.html
I am going to watch all your tutorials. You are awesome.
Next Video Record ur Screen and and Webcam (dont disturb ur screen by ur webcam) Like PRO GAMERS
WHO IS SUPPORTING ME to make a video like this?
YEAH KEVIN MAKE A VIDEO LIKE THAT
Yes Kevin
Yes
Yes Kevin
You really speak like CHILLS.....
I've d been searching this for long. thanks so much Kevin.
you are one of the most diligent youtuber. almost one video per day. yeah.
Brilliant!!! Saved me a world of work...
This is so good I can't believe it. You are the absolute best!!!
This is an AWESOME video if I can only get it to work as I am hoping someone here will be able to provide direction. I have checked and I have the most recent version of Excel but I dont have that button he is referring to it is only GET EXTERNAL DATA which is not reflective of the video. Also see comments below about how to update and I dont have any ACCOUNT button. I apologize as I am not tech savvy and desperately need to convert working PDF files for data. Any help is appreciated. Thank you.
AMAZING! Perfect for dealing with quickbooks
Kevin, You have best instructional videos, super helpful
Thank you so much Kevin, you make life pretty easier!
Very easy to follow, thank you Kevin
Hugely helpful - pushed off having to get an Adobe account for just a little longer!
Good one. I have just subscribed to Excel MS 365, making life a little easier. Thanks Kevin
Thank you so much... Life saver... ❤ I love your channel... More tutorials to come...
Fabulous this lesson came in handy today.
Thank you so much Kevin for this tutorial.🙂
This person shows in a very simple way.
Thank you.
Thanks, your speech is very clear that is imagine
Hi Kevin. Thanks for explaining converting PDF to EXCEL in excel 365. Please tell me the easiest way in excel 2016. Thanks.
Thanks Kevin. Never knew it that easy.
very helpful, thank you! I may import up to 500 part numbers listed in a chart in a PDF document. Sometimes I have to insert the 4 row after every other cell in Excel. Can you help with that. To make it more complex, I may Have to import row 3 and row 4 from the PDF chart to a cell in Excel below each other instead of side by side as shown on the PDF. Would love to show you the PDF. I have more complex scenarios importing from PDF chart to Excel.
Thank you, so easy, really appreciat e you. God bless you more.
Hey Kevin I just benefit so much from you bro thanks for sharing such valuable information…
You saved my life tbh 😂, thanks captain!
Hi Kevin, this is very helpful to my work now. Here is my question...I download PDF documents with pre inserted ,,, (comas) in it but I want to remove ,,, (comas), could you please help me to remove all these comas after converted to excel format?
Thank you for the tutorial it is saving me so much time.
You've saved my life and time thanks. 👍
Thanks for the video! Unfortunately I have this option INactive.. Searched on the web a bit regarding it, but could not figure out why?
Can you help with that, Kevin?
Very well explained. Thank you so much.
This was very helpful. Thank you Kevin.
quick easy and plain... a great vid. Thank you so much..
Hi Kevin, thank you so much for your tutorials which are super handy! For this one convert PDF to Excel, really want to use this function but in my Excel, after clicked the "Data", the "Get Data" icon doesn't show up. Do I need to pre-set something? I am using office 365 from my Uni. Thank you so much!
Same here.
same here using the Office 365 package and i dont get this option in the drop down
Very simple and to the point!
My friend you are a life saver. Thank you so much for this information
Excellent tutorial on importing data!
Excellent Video. You are a consistent high performer
HI Kevin So sorry to ask but it seems like my version of the app (Excel) doesn't support the option of ^^From PDF^^ for some reason .
I will really appreciate if you explain to us why ? i am so in need of this feature TNX
Thank you! This one worked perfectly.
you are an awesome teacher