How to display data in table format in android

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.

The first time you use the option, you will be asked for a series of permissionsFirst you will see the capture screen, in which you have to give permission for Excel to upload the photo you take to the servers to process it. And then, you will have to give it the permissions on the mobile to use the camera and take photos or record videos.

Next, you will enter camera mode where you must photograph the table you want to digitizeWhen you are going to do it, you will see that Excel marks you before taking the photo the space that your sheet of paper or the table occupies exactly in the photo. That is the part you are going to photograph, discarding the rest. If you are patient you can wait for it to focus well, but this is something you can touch up later.

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.

After accepting, Excel will spend a few seconds processing the image with the message Converting the image to dataWhen it’s done, you’ll get to the preview. In it you will see a preview of the result, in which cells that Excel is not sure it has understood correctly will appear in red. Here you can do two things, click directly on any cell to edit it or click on Review to review the ones that appear in red one by one.

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.

And if you click on any of the cells, including those that are not marked as doubtful, a writing field will open at the top for you to change the text that appears in them. Just write or edit what you want and click the Done button in the upper right corner.

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.

Leave a Comment

Your email address will not be published. Required fields are marked *