Import Data from a Picture to Excel

Mynda Treacy

July 28, 2022

New to Windows is the ability to import data from a picture to Excel*.

No more typing data manually into spreadsheets. It works with image files or screen captures on your clipboard.

It's available on the Data tab of the Ribbon > From Picture, as shown below:

import picture from ribbon

*Import data from a picture requires a Microsoft 365 license and is currently being rolled out to users on the Microsoft Office Insiders beta channel.

If you are on the beta channel and you don't have this feature, you just need to sit tight and wait until rollout is complete.

In the meantime, you can use the Excel Mobile app to import data from a picture and then open the file on your desktop to continue working with it.

See Import Data from a Picture to Excel in Action

Subscribe YouTube


Import Data from a Picture to Excel : Step by Step

We'll look at two examples, one from a picture file and another from a screenshot. The picture file I have contains a fee statement:

import data from sample image

To import the data, go to the Data tab > From Picture > Picture From File and select your picture.

Excel opens the picture pane on the right that shows the progress:

data from picture analyze

Tip: You can left click and drag from the pane header to undock it and make it bigger.

When complete you get a preview of the data and the original image:

import data from picture preview

Clicking on Review enables you to check and edit the cells with pink fill:

check and edit review

To edit other cells, simply click on them and type.

Tip: if you're having trouble seeing the highlighted cell in the image preview, try resizing the Data from Picture window to get it to adjust.

Once you've made your revisions, click 'Insert Data' to load to the worksheet.

Importing Data from a Screenshot

If you've ever tried to copy and paste data from a web page to Excel, you'll know it can be hit and miss. It's more reliable to take a screenshot with the following key combination:

screenshot keystrokes

Then in Excel go to the Data tab > From Picture > Picture From Clipboard.

You can take screenshots of anything, including PDFs created from scanned documents.

Keep in mind that you can also use Power Query to get data from a PDF that's not created from a scanned document, which might be easier if you have multiple tables contained in a single PDF, or multiple PDFs to get data from.

Limitations

Currently the following languages and character sets are supported: English, Bosnian, Croatian, Czech, Danish, Dutch, Finnish, French, German, Hungarian, Italian, Norwegian, Polish, Portuguese, Romanian, Serbian, Slovak, Slovenian, Spanish, Swedish, and Turkish.

AUTHOR Mynda Treacy Co-Founder / Owner at My Online Training Hub

CIMA qualified Accountant with over 25 years experience in roles such as Global IT Financial Controller for investment banking firms Barclays Capital and NatWest Markets.

Mynda has been awarded Microsoft MVP status every year since 2014 for her expertise and contributions to educating people about Microsoft Excel.

Mynda teaches several courses here at MOTH including Excel Expert, Excel Dashboards, Power BI, Power Query and Power Pivot.

Leave a Comment

Current ye@r *