iKnowledge School of Technology

Excel Import Data from a Picture

Excel Import Data from a Picture

Excel Import Data from a Picture

We are going to show you how to import data in Excel from an image. This feature is available in both Office 365 and your Excel App that could be downloaded if you have Office 365 already

In this example, we want to import a list of stocks from Google Finance. If you are thinking about copying and pasting this information, well…not so fast!

Picture example for data

Look what happens if we try to copy and paste, even when we choose the paste values only or match the destination formatting, we get a list that is not so clear, and we will need to format a lot of data.

Copy from image

Now watch what happens when I take a screenshot of the stock list, by using my Snipping tool, available on your Microsoft computer for free, depending on your version. First, I open it in my taskbar, then press the New Snip button with the plus sign. We are now selecting and dragging the area with the stock information that we need. Let’s wait for the screenshot to appear and now click copy on the upper right-hand corner of the Snipping Tool

using snipping tool

Now the screenshot is in the clipboard the moment that we clicked copy, so in Excel, I am using the same workbook as before, so you can see the difference, let’s go to the data tab and select From Picture option

insert from data tab

We are ready to import the picture by inserting the data from the picture that we have in our clipboard

data from picture

Excel is now loading and at the same time checking the image for any possible corrections needed on the right panel, we even have a chance to review, edit and insert the data we need from this screenshot

take data from picture

For this demo, I am going to review a few items and then insert my information as-is because you can easily change it in Excel

Let’s go ahead and check a couple of things, you can make the changes if you want or just click accept right in here you can also navigate with the left and right arrows until you see all the reviews that are suggested in Excel

data showing from picture

Alright, so I finished checking the suggestions so let’s go ahead and finish inserting the data in Excel by first accepting the changes and then clicking on the Insert data button and now look at the difference! This is way easier to manage and I can have my information ready.

This is another example where is an image from a website called financialsamurai.com that lists the average car prices, so we can’t even copy the data and paste it into Excel even if we wanted, so we will repeat the same steps, by opening the Snipping Tool, click on New Snip to take a screenshot of it, and after the screenshot appears to click copy right on the upper right-hand corner and now let’s go back to Excel

snipping tool

Let’s go to the Data Tab, select From Picture, remember you can also get an image from your computer but we will go ahead and select from Clipboard, and now we have the information in Excel

insert from clipboard

This time we don’t have any changes to make because the picture from the website is in the shape of a table, similar to Excel and the data is easy to capture, this time I am going to ignore the review items that Excel is suggesting and press Insert Anyway, we saved ourselves hours of work and all the information was ready in seconds with Excel.

data inserted

Let us know in the comments below if you are already using this feature and thank you for reaching all the way to the bottom of our blog!

insert data from picture excel desktop windows 10
convert picture to excel table
insert data from picture excel 2016
data from picture excel missing
best image to excel converter
insert data from picture excel android
insert data from picture excel online
iphone picture to excel
convert picture to excel table
data from picture excel missing
insert data from picture excel 2016
best image to excel converter
insert data from picture excel android
insert data from picture google sheets
import data from picture to excel windows
how to import picture in excel
how to get data from picture in excel
how to import images to excel
how to import data from picture to excel pc
how to import data from picture to excel
how to import images into excel
can you import images into excel