How to insert data into Excel from an image

Have you been trying to get data into Excel from another source, such as an image, and you need to copy it manually? Are some other OCR tools copying the data in the wrong format and making it difficult for you to work? You probably wish there was a native function within Excel that could recognize data in an image or screenshot.

With the Image Data feature in Excel, you can insert your data from an image or screenshot into your spreadsheet.

Benefits of using the Image Data function

You’ve heard of inserting an image into Excel, but now you can also convert an image to data.

The main benefits are:

• This tool will put your information in the default format, so you no longer have to deal with data not being copied correctly.
• Reduces manual effort by allowing you to automatically take data from an image instead of entering it line by line.
• It allows you to insert data from anywhere by simply taking a screenshot.

Creating data from an existing image

This feature will allow you to load a saved image file and convert it to your worksheet as data. This can be useful for many reasons; an example is if you only have paper copies and want to put data, such as tax returns, into Excel. To do this, follow these steps:

1. Make sure the image is saved on the computer.
2. Open Excel and select the data tab.
3. About him Get and transform data section, choose From image.
4. Select Stock Image.

   

5. Browse the location of the image file on the computer and upload it to Excel.
6. On the right side of the spreadsheet, a dialog box will appear and begin to analyze the data. When finished, it will show you a preview of the data and give you the options to insert data either Review.

   

7. Once everything looks good, press insert data. If not, review the data that Excel has captured.
8. After insertion, all your image data will be nicely formatted in your spreadsheet.

   

Creating data from a screenshot

This method allows you to convert a screenshot to Excel data. Screenshots will allow you to pull data from almost any source and put it into your workbook. Make sure you have permission to use the data you’re collecting. Here is how to convert your screenshot:

1. Take your screenshot of the data and copy it to the computer clipboard
2. Open Excel and select the data tab.
3. Go to the Get and transform data section and select From image.
4. Select clipboard image.

   

5. A dialog box will appear on the right side of the spreadsheet while you analyze the data. When complete, it will show you a preview of the data and give you the options to insert data either Review.
6. Once everything looks good, press insert data.
7. All your image data will be nicely formatted in the spreadsheet.

Suggestions for reviewing and correcting the data

Once you’ve selected the image you want to convert to data, you’ll want to optimize it before inserting it into your spreadsheet.

• For a downloaded image or screenshot, crop the photo just to include the data you want to insert.

correct format:



Incorrect format:



• Make sure the image data is in focus, not at an angle or out of focus.
• Before hitting the insert data button, select the Review and review all the tips to make sure your data converts correctly.

Once the data is in your Excel file, you can create a table, change the format, or use it however you like.

Reduce line-by-line copying and undo malformatting when getting data from another source. Instead, easily insert data from anywhere by saving an image or screenshot. With this tool, you can be more productive than ever.