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.
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.
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.
- Select desired image from File Explorer and click on OKÂ button.
- You will find the image opens up with data structure.
- 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.
- After reviewing the entire dataset click on the Insert Data option.
- You will find the dataset insert into the worksheet.
- To convert the dataset into a table, select the whole dataset.
- Go to the Insert tab and select the Table option.
- Check My table has headers in the Create Table dialog box.
- Click on OK.
- You will find a well-developed table added to your worksheet, the same as the image you inserted.
Note:Â If you do not get the Picture From option on the toolbar of Excel, you have to use the Data From Picture option.
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.
- 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.
- When we took that screenshot, it was saved on the clipboard. After inserting the clipboard, our dataset will look like below.
- Review the required items and change them where necessary by selecting Review option.
- Finally, click Accept to move forward.
- Insert the dataset into the worksheet by clicking on the Insert Data option.
- You will find the dataset insert into the worksheet.
- Select the dataset, go to the Insert tab, and select the Table option.
- Select the range for the table and check on the option My table has headers.
- Click on OK.
- Finally, you will find the table converted from the screenshot.
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.
Get FREE Advanced Excel Exercises with Solutions!