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!
@MikeThomas67
4 ай бұрын
You're welcome!
@AshwinMisra
7 күн бұрын
Hi. Thanks for this video. Though I dont see the option to add data from picture in my Excel on Macbook.
@MikeThomas67
6 күн бұрын
@AshwinMisra what version of Excel do you have? This feature is available to Office 365 subscribers on version 16.38 or greater
@peterpayne2219
Ай бұрын
The 2019 version of Excel for Mac does not have the Import Data From Picture option. So we have to find some other way...
@MikeThomas67
28 күн бұрын
Yep it's not supported I'm afraid
@ignatiusliebenberg3808
Жыл бұрын
Thanks Mike, the best clip I watched on this topic.
@rajshah7170
Жыл бұрын
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
Жыл бұрын
Does it mean that it is impossible to embed PDF into excel on MacBook?
@MikeThomas67
Жыл бұрын
@@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 😞
@samsun007
Жыл бұрын
Thanks, Mike - this is a great video. Really simple and helpful - well done!
@TangiwaiKoopu
10 ай бұрын
Thank you! You have the one video that actually helped me!
@MikeThomas67
10 ай бұрын
@user-ob8us4pe4i Glad I could help!
@buaykeetan2605
Жыл бұрын
thank you Mike for this useful video
@DrGaryMBrownstein
3 ай бұрын
Thank you! I spent a long time trying to get the "cure". This video is superb
@pandamonium9834
Жыл бұрын
Hi mike didn’t know this could be done so thanks for that!
@MikeThomas67
Жыл бұрын
You are very welcome Annie
@steveblack8410
Жыл бұрын
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
@MikeThomas67
Жыл бұрын
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
@HnnBz
3 ай бұрын
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.
@MikeThomas67
3 ай бұрын
@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 :-)
@maribelbarcelona3074
10 ай бұрын
Thank you so much 😊
@sirseacow4462
Жыл бұрын
I don't have the data from picture option in Excel
@MikeThomas67
Жыл бұрын
@sir seacow This feature is available to Office 365 subscribers on version 16.38 or greater.
Пікірлер: 25