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.
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).
- 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).
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.
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.
- 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.
- 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.
- In conclusion, you can customize the data and the format cells according to your preference.
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.
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.