Excel has become on its own merits the best app for creating type spreadsheets, thanks to the large number of options available to us. While it is true that Numbers is an excellent option for home users, it is still a long way from the solution Microsoft offers us.
Despite what you might expect, Windows and Mac versions don't go hand in hand. Obviously, the Windows version is the first to receive new functions, functions that later also lead to the Mac version. Today we are talking about one of them, a function that allows us to import tables from images.
Surely on more than one occasion, you have come across a table on physical paper or in a document that has been sent to you (in a format other than Excel). In order to apply formulas in the table, we have been forced to copy all data to a table, a tedious process, especially when the number of data is very high.
If you have used any text or table recognition application, you have seen how the result has been nothing short of acceptable. Fortunately, Microsoft has announced the availability of a new function that allows us to create tables directly from images, be it a photograph that we have taken of the table document or an image that we have captured from a document.
How to create tables in Excel from an image
- Once we have the Excel sheet open where we want to add the images, we must make a screenshot of the table data (Shift + CMD + Ctrl + 4).
- Next, within the Excel sheet we go to the Insert ribbon, and polish on Pictures> Insert Pictures from Clipboard.
- Then a preview of the table will be displayed on the right side of the screen. The review process it will show us the names or data that it has not interpreted correctly. Once we have adjusted the names or data, click on Insert table.
This function is available for users of the Office 365 version as of the version 16.38, a version that was released in mid-June.