With the import of data from photos into Excel, you immediately have the correct content without having to manually type or perform many operations. The following article guides you to import data from photos into Excel.

Instructions for importing data from photos into Excel

Step 1:

With the image saved to your computer, click on the Data tab and then select From Picture and then click on Picture from File to select the image available on the computer.

How to import data from photos into Excel Picture 1

Step 2:

Display the folder on the computer. Users find the folder containing the image you want to import data into Excel and then click select.

Immediately on the right edge of the interface on Excel, users will see the data extracted from the image. You can click Review to preview how the data is displayed in the image. Or we click Insert Data to insert into Excel.

How to import data from photos into Excel Picture 2

 

As a result, we get the data imported from the image in Excel as shown below.

How to import data from photos into Excel Picture 3

How to import data from screenshots into Excel

Step 1:

You will take a screenshot of the data that the user wants to enter the data and then copy it to the clipboard on the computer. Continuing to use Excel, click on the Data tab and then click From Picture, select Get and Transform Data.

Then you click on Picture From Clipboard .

How to import data from photos into Excel Picture 4

Step 2:

Then the content in the image is also extracted and you also click Insert to insert data from the image into Excel.

How to import data from photos into Excel Picture 5

4 ★ | 1 Vote | 👨 190 Views

Above is an article about: "How to import data from photos into Excel". Hope this article is useful to you. Don't forget to rate the article, like and share this article with your friends and relatives. Good luck!

« PREV POST
NEXT POST »