How to Insert Excel Table from Image

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will explore the process of extracting an Excel Table from image. The table is an important feature of Excel. Tables are used to analyze data smoothly in Excel. Sometimes we have to insert data manually from printed and handwritten documents. However, with the advanced Excel techniques, extracting data from images and importing it directly into Excel has become a time-saving and efficient alternative.

Overview of inserting excel table from image


Download Practice Workbook

You can download this practice workout below.


How to Insert Excel Table from Image: 2 Efficient Methods

In Excel, with the help of advanced techniques, you can easily extract tables from images into Excel datasets. For this process, you need to add images from the File Explorer as well as from the Clipboard. The two efficient processes are discussed in this article. We will add a table from the below image.

Downloaded image from Google to insert as Table in Excel


1. Excel Table From Image: Image Saved in File Explorer

To initiate the process, open a new Excel worksheet and insert the image containing the desired data. For this,

  • Select a cell of the worksheet. Here, we select cell B4 and go to the Data tab.
  • Expand the From Picture option and choose Picture from File.

Data tab to Insert image

  • Select desired image from File Explorer and click on OK button.

Add image from File Explorer

  • You will find the image opens up with data structure.

Convert image into dataset

  • You can click on the Insert Data button if no need to modify anything.
  • Or you can click on the Review button to check each and every data.
  • After correction click on Accept button.

Review data from an image

  • After reviewing the entire dataset click on the Insert Data option.

Insert data from the image

  • You will find the dataset insert into the worksheet.

Dataset insert to the Excel

  • To convert the dataset into a table, select the whole dataset.
  • Go to the Insert tab and select the Table option.

Insert table in Excel

  • Check My table has headers in the Create Table dialog box.
  • Click on OK.

Select range for the table

  • You will find a well-developed table added to your worksheet, the same as the image you inserted.

Created Table from image in Excel

Note: If you do not get the Picture From option on the toolbar of Excel, you have to use the Data From Picture option.

Alternate way to insert image


2. Inserting Table from Image: Using Clipboard Option

Sometimes you need to take screenshots of some datasets as they are not saved and you convert them into Excel datasets. In that case, you have to insert the image from the Clipboard rather than the File Explorer. To do so,

  • Click on the shortcut key Windows + Shift + S to take a screenshot.

Taking screenshot

  • Go to the worksheet and open the Data tab.
  • Choose the Get & Transform Data group and expand the From Picture icon.
  • Select Picture from the Clipboard option.

Adding an image from the clipboard

  • When we took that screenshot, it was saved on the clipboard. After inserting the clipboard, our dataset will look like below.

Insert image as data in worksheet

  • Review the required items and change them where necessary by selecting Review option.
  • Finally, click Accept to move forward.

Review every required items

  • Insert the dataset into the worksheet by clicking on the Insert Data option.

Insert the data into worksheet

  • You will find the dataset insert into the worksheet.

Data add to the worksheet

  • Select the dataset, go to the Insert tab, and select the Table option.

Insert table

  • Select the range for the table and check on the option My table has headers.
  • Click on OK.

Select range for the table

  • Finally, you will find the table converted from the screenshot.

converted table from the screenshot in Excel


Frequently Asked Questions

1. Can I directly convert an image into an Excel table without additional tools or software?

No, you cannot directly convert an image into an Excel table without using any additional tools or software. Excel is a spreadsheet program that primarily deals with numerical and textual data, whereas images are visual representations that contain pixel information.

To convert an image into an Excel table, you typically need to utilize optical character recognition (OCR) technology to extract the text from the image and then import that extracted text into Excel. OCR software or online tools are commonly used for this purpose.

2. Are there any specific file formats or image resolutions that work best for accurate conversion to an Excel table?

When it comes to the accurate conversion of images to an Excel table, the choice of file formats and image resolutions can have an impact on the quality and accuracy of the conversion. But there are no strict rules for this.


Things to Remember

  • To extract an Excel table from an image, you have to insert data in data form in Excel.
  • Screenshots are saved on the clipboard. So while inserting a screenshot, choose the option Picture from Clipboard.
  • To convert download images choose Method 1.

Conclusion

I hope now you can extract Excel table from image easily. This learning will make your work more efficient and quicker. If you face any problems while practicing, feel free to comment below. You can also gain advanced knowledge on Excel other formulas and functions by visiting the ExcelDemy website.

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Annyca Tabassum
Annyca Tabassum

Annyca Tabassum holds a BSc degree in Geography and Environment from Shahjalal University of Science and Technology, Bangladesh. She has a deep passion for Excel. As an Excel & VBA Content Developer for ExcelDemy, she not only provides solutions to complex issues but also demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, she is interested in Data Analysis with MS Excel, SPSS, Python Web... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo