Blog Post

Excel Blog
3 MIN READ

Data from picture in Excel for Mac

Steve_K_Excel's avatar
Steve_K_Excel
Icon for Microsoft rankMicrosoft
Jul 02, 2020

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!

 

How it works

1. Use one (or more) of the options below to capture the content you want to digitize:

  • Select Insert > Data From Picture > Picture From File.
 

 
  • Copy an image of a table to your clipboard. For example, take a screenshot of a table by pressing SHIFT+CMD+CTRL+4, and then select Insert > Data From Picture > Picture From Clipboard.
  • Right-click a cell, and select Scan Documents (requires an iPhone configured to use Continuity Camera). Make sure you have good lighting and focus on the data, and then tap the button to take the picture. If you’re satisfied, tap the Save button to send it to Excel.

 

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.

      

 

Scenarios to try

  • Scan some data from a book or magazine. If you see some interesting data in a book and want to use it in Excel, this is a great way to skip the typing. If you have an iPhone, right-click in Excel on your Mac and select Scan Documents. Your iPhone will light up. Then you can take a picture of the data, and follow the on-screen instructions to bring the data in Excel in no time.
  • Screen capture a table from a website. If you’ve ever tried to copy and paste some data from a web site, you’ve likely noticed that the formatting looks different after you’ve pasted it than it did on the website. Instead, try to capture a screen clipping of the table (by pressing SHIFT+CTRL+CMD+4 on your Mac), then select Insert > Data from Picture > Picture From Clipboard. Then, follow the instructions on screen and you should get just what you were looking for.
  • Take a picture of some printed data. Maybe you’d like to get data from your previous tax returns into Excel and you only have printed copies. Just take a picture of each one, transfer the pictures to your Mac (OneDrive is great for this). Then, select Insert tab > Data From Picture > Picture From File. Then, follow the on-screen instructions to convert picture to data.

Availability

This feature is available to Office 365 subscribers on version 16.38 or greater.

Feedback

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!

 

Updated Jul 09, 2020
Version 2.0
  • excelpbi's avatar
    excelpbi
    Brass Contributor

    Hey Steve - Thanks for Prioritising the release in the Excel Online followed by Excel for Mac

    I am sure when you do release it in Excel for Windows in couple of years (no hurry - the small set of users can continue to wait)  it will come in E5($$) followed by E3($) followed by Pro Plus

     

    Cheers

    Sam

  • waylon_k's avatar
    waylon_k
    Copper Contributor

    Hello Steve,

     

    The article title notes that this feature is available for Excel on MacOS. So naturally, I hopped into Excel on Windows to see if the feature was there too by any chance. I am wondering exactly why the feature has been made available for Mac users before Windows Users. Does it have to do with the Mac/Apple ecosystem of devices (like how easily a mac user can "insert picture from iphone" when working on their computer)?

     

    Just curious—I'm looking forward to this feature for Excel on Windows!

    Thanks,

    Waylon

  • Waylon - thanks for the question.  The main reason to bring this feature to Mac first is what you mentioned, the Mac/Apple ecosystem. Specifically, the introduction of the Continuity Camera was a big part of the reason.