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.
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.
As a result, we get the data imported from the image in Excel as shown below.
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 .
Step 2:
Then the content in the image is also extracted and you also click Insert to insert data from the image into Excel.