Nobody enjoys manually entering tons of data from printed materials into a Microsoft Excel Spreadsheets, especially on cell phones. The “data from image” feature can save you time, reduce the risk of errors, and eliminate tedious tasks.
Excel’s Data From Picture function scans a picture (for example, a table of values printed in a magazine, a printout of financial transactions, or even a screenshot of a table from a website) and analyzes it to find the relevant data. After you are given the opportunity to edit any data it finds, it will import everything into your spreadsheet.
This feature is currently available in Excel for Mac, iPhone and Android. It is not yet known when Windows users will be able to join the fun.
Step 1: Access the data from the image option
Using the camera on your Android device, iPhone, or iPad, you can capture the tabular data you need from places like a website or a printed document. You can also use an image already saved on your device.
Once you have these details in Excel, you can review them for changes or corrections and then paste them into your sheet. It all starts with opening the Data from Image option.
Open minded Microsoft Excel on your mobile device into the workbook, and then into the spreadsheet that you want to use. First, select a cell that you want to paste the data into.
Depending on how you view and use it Excel On your mobile phone, you may see the Data from Picture icon in the toolbar at the bottom.
When you see it like the screenshot above, tap on it. If you don’t see the icon and you see the names of your worksheets instead, tap the Tables tab to display the toolbar.
You can also use the tape. Tap the edit icon at the top, select “Paste” from the menu and select “Data from image”.
If you’re using a tablet, use the Insert tab above and select Data From Image.
Step 2: insert data
You have two options for pasting data with Excel’s data from picture function. The first is to take a picture with your device’s camera. The second is to paste the data from an image that you already have saved on your device.
Insert data with your device’s camera
Once you tap the Data from Image option, your device’s screen will turn into a camera viewfinder. Align the table that you want to capture. When you’re happy with the shot, tap the shutter button at the bottom to take the photo.
Next, you can crop the picture by dragging the edges or corners. Take the time to focus on the data and remove unnecessary background objects or text. When you’re done, tap Next on Android or Confirm on iPhone and iPad to use the picture.
Note: Note: To start over, tap Retake on Android or Cancel on iPhone or iPad and take the picture again.
You will see a progress message as Excel extracts the data from the image for you to work with.
Insert data from a saved image
If you’ve already taken a photo or screenshot of the data and saved it on your device, you can use this option. Select a saved image from the bottom of the viewfinder screen or tap the media icon to add more photos.
Select the picture and it will appear in the viewfinder window where you can crop it, just like the camera shot above. Tap Next or Confirm to use the image.
Step 3: review and paste the data
When the process is complete, you will see a two-part screen in Excel. The upper part shows the image while the lower part contains the data that Excel has drawn from it. Now is the time to review the data before adding it to your spreadsheet.
Depending on the quality of the image and the original content, you may need to adjust some of the text. Also, you will find that some characters such as copyright or registered symbols, bullets and symbols or images are not displayed correctly.
Excel highlights all the items you need to check at the bottom of the screen. Tap one to start reviewing. You can select any highlighted data item and then tap Edit to make a change or Ignore to accept it as it is.
You can also review each item individually in a cleaner user interface. Select a highlighted item, tap Edit, then choose Review All. You will also see the total number of articles that Excel expects a review from you.
To edit the data, tap in the text field and make the change. Then tap “Done”. To accept the data without changes, tap on “Ignore”.
When you’ve reviewed all of the items in question, the data is no longer highlighted. You can then tap Open on Android or Paste on iPhone and iPad to paste the data into your spreadsheet.
Once the data is in your Excel You can work with it like any other data.
You don’t always have to manually enter table data into Microsoft Excel when you are on your mobile device. Keep this feature in mind and use your device’s camera or a saved image to capture and paste the data from a picture.
What is the difference between Microsoft Office’s desktop, web and mobile apps?