Thank you SO MUCH for this video! You saved me hours and hours of time. For anyone else finding this and reading the comments, if you have a large/dense table you're importing, make sure you make the PDF you're taking a screenshot from large on your screen before you take the screenshot. My first attempt resulted in MANY errors, but when I made the viewer bigger before taking the screenshot, Excel was able to read the image accurately. Thank you Mike!
This has limitations (e.g., with multipage docs), so an easier way - depending on how original doc is formatted - is to open pdf in Acrobat Pro (or whatever naming convention Adobe is using today - the expensive version), and use the Save as... to Excel. That generates the xlsx file, which can be opened in Apple's Numbers. Alternatively, if you are doing bulk conversions, you can use Ruby or Python scripting with a util like PDF::Reader to convert to text, treat that as a tsv file, and use regex to extract the data. But generally Acrobat works just fine.
@HnnBz You are right with the limitations but 1) I don't think an average non-technical Excel user would want to get involved with a Ruby/Python/Regex based solution and 2) have you seen the price of Acrobat Pro!! Nonetheless, thanks for the feedback :-)
Hi Mike - Great video - Thank you. Its a shame Office 365 for Mac does not have import from PDF option. If my pdf is longer than a screen full, how do I select all the area of the pdf to import to excel ? Any advice gratefully received.CMND+Shift+4 would not extend below the visible screen area.
@@Peterlusg You can only insert a PDF into Excel for Mac as an image. Either drag the PDF and drop it into a workbook Excel or use Insert>Pictures to import PDF as image to your Excel file. Whichever method you use, it will only import the first page of the PDF 😞
Hi Mike I tried to do this but my three columns of data keeps importing into one cell. I cant get it to go into individual cells. Im using office home and business 2021. Do you know how to stop this. TIA
I was ready to cry and you saved my night
Thank you SO MUCH for this video! You saved me hours and hours of time. For anyone else finding this and reading the comments, if you have a large/dense table you're importing, make sure you make the PDF you're taking a screenshot from large on your screen before you take the screenshot. My first attempt resulted in MANY errors, but when I made the viewer bigger before taking the screenshot, Excel was able to read the image accurately. Thank you Mike!
You're welcome!
Thank you! I spent a long time trying to get the "cure". This video is superb
Hi. Thanks for this video. Though I dont see the option to add data from picture in my Excel on Macbook.
@AshwinMisra what version of Excel do you have? This feature is available to Office 365 subscribers on version 16.38 or greater
Thank you! You have the one video that actually helped me!
@user-ob8us4pe4i Glad I could help!
Thanks, Mike - this is a great video. Really simple and helpful - well done!
Thanks Mike, the best clip I watched on this topic.
thank you Mike for this useful video
Hi mike didn’t know this could be done so thanks for that!
You are very welcome Annie
This has limitations (e.g., with multipage docs), so an easier way - depending on how original doc is formatted - is to open pdf in Acrobat Pro (or whatever naming convention Adobe is using today - the expensive version), and use the Save as... to Excel. That generates the xlsx file, which can be opened in Apple's Numbers. Alternatively, if you are doing bulk conversions, you can use Ruby or Python scripting with a util like PDF::Reader to convert to text, treat that as a tsv file, and use regex to extract the data. But generally Acrobat works just fine.
@HnnBz You are right with the limitations but 1) I don't think an average non-technical Excel user would want to get involved with a Ruby/Python/Regex based solution and 2) have you seen the price of Acrobat Pro!! Nonetheless, thanks for the feedback :-)
Thank you so much 😊
Hi Mike - Great video - Thank you. Its a shame Office 365 for Mac does not have import from PDF option. If my pdf is longer than a screen full, how do I select all the area of the pdf to import to excel ? Any advice gratefully received.CMND+Shift+4 would not extend below the visible screen area.
Does it mean that it is impossible to embed PDF into excel on MacBook?
@@Peterlusg You can only insert a PDF into Excel for Mac as an image. Either drag the PDF and drop it into a workbook Excel or use Insert>Pictures to import PDF as image to your Excel file. Whichever method you use, it will only import the first page of the PDF 😞
The 2019 version of Excel for Mac does not have the Import Data From Picture option. So we have to find some other way...
Yep it's not supported I'm afraid
Hi Mike I tried to do this but my three columns of data keeps importing into one cell. I cant get it to go into individual cells. Im using office home and business 2021. Do you know how to stop this. TIA
Hi @steveblack8410 I have no idea off the top of my head. If you drop me a mail via theexceltrainer.co.uk/contact I'm happy to open a dialog with you
I don't have the data from picture option in Excel
@sir seacow This feature is available to Office 365 subscribers on version 16.38 or greater.