You no longer need to manually input a data table printed on a piece of paper. Microsoft is adding a new feature to Excel for Android (and iOS) to allow users to take a photo of a printed table and convert it into useful data.
The new āInsert data from pictureā feature uses Microsoft artificial intelligence (AI) to analyze and recognize the data without the need of the end-user to manually input the data.
This is a feature part of the set of tools available for Office 365 subscribers.
In this guide, youāll learn the steps to quickly import a printed data table into an Excel spreadsheet using your Android phone camera.
How to snap a picture import printed data table into Excel
To import a data table from a piece of paper using the Excel app for Android, use these steps:
-
Open Excel (mobile).
-
Tap the Insert data from picture button at the bottom of the screen. (If you donāt see this button, you can try using the ālight bulbā button to find it, but itās likely that itās not yet available for you.)
Excel Insert data from picture feature
-
Square the camera into the data within the red borders.
-
Tap the Capture button.
-
Crop the image as necessary with the picture editing tools.
-
Tab the Done button.
-
Use the editing tool to correct any mistakes. Or tap the Ignore button to import the data table without edition.
Excel data capture edition
-
Tap the Insert button.
Once you complete the steps, Excel will process the data and insert it into the spreadsheet where you can continue making changes or input new data.
While this guide focuses on Android, Microsoft is planning to bring the feature to Office 365 subscribers on iOS.