(Originally published on June 13, 2022 by Steve Kraynak)
Hello Insiders! I’m Steve Kraynak, a Product Manager on the Excel team. I’m excited to share with you the availability of a new feature that enables you to turn images with table data into data that you can edit in Excel: Data from Picture!
Import data from picture in Excel for Windows
Have you ever had to type data from a printed page into Excel? Wouldn’t it be a lot easier if you could take a picture, and then have Excel do the tedious work of inputting the data for you? Of course it would!
With the new Data from Picture feature in Excel for Windows, you can insert data from a picture on your clipboard or an image file from your computer. There’s no need to type all the data—Excel can do it for you!
How it works
- Use one of the options below to capture the content you want to digitize:
- Select Data > From Picture > Picture from File to use an existing table image.
"From Picture" on Data tab of Excel ribbon
- Copy an image of a table to your clipboard. For example, take a screenshot of a table by pressing Windows+Shift+S. Then select Data > From Picture > Picture from Clipboard.
- Select Data > From Picture > Picture from File to use an existing table image.
- After you have captured the picture of the content you want to bring into Excel, the Data from Picture pane appears. This shows you the progress as the image is being analyzed.
Analyzing data in image
- Review the results and make any corrections necessary, and then select Insert Data. The data is now in your Excel worksheet!
Review the data and adjust if needed
Scenarios to try
- Screen capture a table from a website. If you’ve ever tried to copy and paste data from a website, you’ve likely noticed that it often results in formatting discrepancies. Instead, capture an image of the table (by pressing Windows+Shift+S), then select Data > From Picture > Picture from Clipboard. Then, follow the instructions on the screen; you should get just what you're 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. No problem. Just take a picture of each one and transfer the pictures to your Windows computer (OneDrive is great for this). Then select Data > From Picture > Picture From File. Follow the on-screen instructions to convert the picture to data.
Requirements
This feature supports the following languages (and recognizes these character sets): English, Bosnian, Croatian, Czech, Danish, Dutch, Finnish, French, German, Hungarian, Italian, Norwegian, Polish, Portuguese, Romanian, Serbian, Slovak, Slovenian, Spanish, Swedish, and Turkish.
Availability
The Data from Picture feature is rolling out to Office Insiders running Beta Channel Version 2207 (Build 15402.20002) or later.
UPDATE (12/1/22): The Data from Picture feature is available to Microsoft 365 subscribers running Version 2210 (Build 15723) or later. Learn more: .
Feedback
We want to hear from you! Please go to Help > Feedback in Excel to provide your thoughts about this feature.
Learn about the Microsoft 365 Insider program and sign up for the Microsoft 365 Insider newsletter to get the latest information about Insider features in your inbox once a month!