How to Use Excel Mobile’s New “Insert Data From Picture” Function

How to Use Excel Mobile’s New “Insert Data From Picture” Function

Microsoft isn’t just beefing these apps up to match their desktop counterparts. There are some features that really set the mobile apps apart. In this case one such feature is insert data from picture.

With this function you can grab your phone or tablet and photograph tabulated information such as a food label or spec sheet. The app then sends the image to the cloud where machine vision software interprets it and turns it into a regular table. Here’s how to pull it off.

Steps:

1. The first step, once you have the app open, is to create a new Excel document.

word image 13 - How to Use Excel Mobile’s New “Insert Data From Picture” Function

2. Then tap this icon.

word image 14 - How to Use Excel Mobile’s New “Insert Data From Picture” Function

3. This will open a camera view. Line the data you want to import up on the screen. You’ll see a red outline where the software detects the information.

word image 15 - How to Use Excel Mobile’s New “Insert Data From Picture” Function

4. Once you’re happy, tap the capture button.

5. Now you’ll see a cropped image containing the information. You can crop it if it contains irrelevant text. When you are happy with the image, tap the check mark.

word image 16 - How to Use Excel Mobile’s New “Insert Data From Picture” Function

6. Next, you will see a preview of the information. In this case, Excel had trouble with some of the table entries. You can review each one here. Tap edit to correct any mistakes or tap ignore to skip one and move to the next.

word image 17 - How to Use Excel Mobile’s New “Insert Data From Picture” Function

7. When you are happy with the table, tap Insert, which will put the information into your spreadsheet. You’re done!

 

 

hucool004

You must be logged in to post a comment