We are going to explain how to digitize a data table by taking a photo with Excel on Android and iOS, a function that was introduced a few months ago and that has finally begun to reach users of both operating systems. The idea is simple, that if you have a data table on paper you can digitize it.
To do this, Excel will use Office Lens Technology, although in such a way that you will not need to leave the office application at any point in the process. So you can see how it is done, we are going to show you step by step with a test table that we have created and printed. By the way, tables can also be digitized pointing directly to a screen and not just to paper.
How to digitize a table with Excel
The first thing you have to do is make sure you have Excel updated on your mobile, open the app and enter a new workbook. While in it, you have to click on an icon that shows a table with a camera, and that is located in the lower options panel. You do not have to click anywhere to find this icon, so if it does not appear the first time it is because you have not received the update with this function.
When you take the photo, you will go to the screen where you can edit the capture. In the options on the top right you can crop or rotate the photo (1). As you saw in the previous capture, we took it diagonally, so I used that to put it horizontally. Once you have everything to your liking, press the accept button at the bottom (2) on the screen.
Regardless of whether or not you decide to edit the table cells, or even after you do, what you have to do is click on the Insert button that you have in the upper right part of the screen.
If before inserting the table you click on Review , Excel will automatically take you one by one for each of the cells that appear in red, offering you the Ignore or Edit options in each one . You will see them at the bottom, and they serve to edit the cell or ignore the possible error saying that it is fine as Excel has it, and that it stops appearing in red.
Once you are satisfied, in the preview, press the Insert button and the table you have digitized will be added to the Excel workbook you were in first . If you click Insert before checking the cells that appeared in red, a window will appear before going to the book allowing you to choose between ending the process or checking the cells. Once everything is in the workbook, you can edit it as a native Excel table.
Hope the above article is helpful. Get more tutorials like this please visit us on our official web page.