How to import data from photos into Excel

On the Office 365 version, users can already import data from photos into Excel for immediate use without having to find some data extraction tools from photos. Users can extract data from photos into Excel with saved images or from screenshots.

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.

Picture 1 of How to import data from photos into Excel

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.

Picture 2 of How to import data from photos into Excel

 

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

Picture 3 of How to import data from photos into Excel

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 .

Picture 4 of How to import data from photos into Excel

Step 2:

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

Picture 5 of How to import data from photos into Excel

Update 27 March 2023
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile