Smart Life

How to Turn a Photo of Data Into an Excel Spreadsheet in Seconds

diamond glass smartphone

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.

Follow TechTheLead on Google News to get the news first.

Subscribe to our website and stay in touch with the latest news in technology.

Click to comment

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Must Read

Are you looking for the latest innovations in tech? You're in the right place, just subscribe to our RSS feed

Techthelead Romania     Comedy Store

Copyright © 2016 - 2023 - SRL

To Top