Have you ever had to transcribe some data from a printed page into Excel by hand? Wouldn’t it be a lot easier to just take a picture and have Excel do the tedious work for you? Of course, it would, and we couldn’t agree more.
With the new Data from Picture feature in Excel for Mac, you can insert data from a screen clipping on your clipboard, an image file from your computer, or from your iPhone camera. There’s no need to type all the data. Excel can do it for you!
1. Use one (or more) of the options below to capture the content you want to digitize:
2. After you have captured the picture of the content you want to bring into Excel, the Data from Picture dialog box opens and shows the progress as the image is being analyzed.
3. Review the results and make any corrections necessary. Then select Insert Data.
This feature is available to Office 365 subscribers on version 16.38 or greater.
We hope you love this powerful new way to get data into Excel with ease, and we’d love to hear what you think about it. Please click the Feedback button near the top-right corner in Excel and let us know. We’re excited to hear from you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.