How to Extract Data from Image into Excel (With Quick Steps)

In this article, I will discuss how you can extract data from an image into an excel worksheet. This data extraction from images is very much effective and saves a lot of time. This is because, if you can import data from an image, you won’t have to type countless data that the image contains. Unfortunately, you cannot extract data from images from a laptop/desktop unless you are using a Mac with Excel 365. However, in the Excel mobile app, you can take photos of your data and later import them to an excel sheet. This is an amazing feature introduced by excel. Luckily, you do not need Excel 365 subscriptions to use the app.


Download Practice Workbook

You can download the practice workbook that we have used to prepare this article.


Download Microsoft Excel for Mobile to Extract Data from Image

To extract data from an image, you can use the excel app both for Android and iPhone.

Download Excel for Android


Step-by-Step Guidelines to Extract Data from Image into Excel

Step 1: Open the Mobile App

  • First of all, open the excel app from your mobile.
  • Next, insert a new workbook and select an empty cell where you want to place the extracted data. Then expand the highlighted icon next to the sheet name (see screenshot).

Open the Mobile App

  • Upon expanding the above icon, the below panel will appear. Click on the camera icon to take an image of the data.


Step 2: Take a Photo or Upload an Image

  • Once you click the camera icon, the mobile camera is ready to take photos.
  • At this stage, you can take a photo of your data. Alternatively, you can use an image that is saved on your mobile. I will use a previously saved image from my mobile storage.
  • To do that click on the icon that is located below the photo capture icon (see screenshot).

Take a Photo or Upload an Image


Step 3: Image Description

  • Suppose, we have the below image that we want to insert in excel.
  • The image contains date-wise sales data for several grocery items. I have selected this image to insert in excel.

Image Description


Step 4: Insert the Image into Excel and Extract Data

  • After we select the image, the mobile screen will look like the below screenshot. Use the pull handles to crop the image so that you can select the image area that contains only data.
  • Once you are done with the selection and cropping, click Continue.

Insert the Image into Excel and Extract Data

  • As a result, the excel app will start to extract data from the selected image and will return the below-extracted data. From this window, you can select any of the data to review (Copy/Edit/Ignore) the data.
  • Then click Open.

Insert the Image into Excel and Extract Data

  • After that, Excel will display the total number of items that you need to review. To illustrate, from the below screenshot, we can see that 6 items need to be reviewed. Now if you want to review all 6 items click Review all. Otherwise, click on Open Anyway.


Final Extracted Data from Image into Excel

  • Finally, we will see that all the extracted data from the given image is inserted into excel.

Final Extracted Data from Image into Excel

  • In conclusion, you can customize the data and the format cells according to your preference.

Read More: How to Extract Data from Excel Sheet (6 Effective Methods)


Things to Remember

  • You can use third-party websites/tools to extract data from images into excel
  • Sometimes, we can convert an image into pdf format and subsequently extract data from the pdf file. Unfortunately, while converting from image to pdf, data loss happens. So, this is not a good idea to extract data from an image.

Conclusion

In the above article, I have tried to discuss step-by-step guidelines to extract data from an image into excel elaborately. Hopefully, these methods and explanations will be enough to solve your problems. Please let me know if you have any queries.


Related Articles

Hosne Ara

Hosne Ara

Hi, This is Hosne Ara. Currently, I do write for ExcelDemy. I have a long experience working with different industries and I have seen how vast the scope of Microsoft Excel is. So, eventually, I started to write articles on Excel and VBA. Basically, my articles are targeted to help people who are working in Excel. By profession, I am an Engineer. Materials and Metallurgical Engineering is my major. Besides, I am a certified Project Manager (PMP) too. I have worked with Power Plant and IT industry earlier. As a person, I am detail-oriented and love doing research. Establishing a greener world is one of my mottos.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo