Microsoft’s Office Lens app is pretty popular among users and pretty handy too. It can be a game changer when it comes to saving diagrams, lists, or addresses.
What if I told you it just got better? Here’s how to use Excel like a pro and save valuable time.
Did you know your phone can turn a photo of data into editable table data?
Office apps users now have the possibility to play with a feature called ‘Insert data from picture’ in the Excel mobile app of the suite, whether they have an iPhone or an Android phone.
As long as you have a chart/table on a sheet of paper that you can snap with your phone’s camera, you can turn it into an editable spreadsheet. The tool is allegedly using AI, and it seems to be doing a great job, as you can see in the video below:
How to insert data from picture in Excel
Just by tapping the “Insert data from picture” button in the Excel, the camera app will open and start highlighting what it identifies as a table data in a red rectangle.
The moment you are done filling the frame, just press the shutter button.
In the next step, the app gives you the possibility of cropping and discarding any irrelevant data, right before the data is processed and inserted into the ready-made table.
This is the moment you want to type “edit” and correct any data OCR errors you spotted.
In the end, you just press “insert” and you are ready to format and use the table and its information.
The “Insert data from picture” tool supports 21 languages, including French, German and Spanish, with many more to follow in the near future, according to the company.
Moreover, Microsoft said users can access the mobile app feature output from all their devices, by saving it to OneDrive. The company assures it will continue to optimize the feature.