Insert Data from Picture generally available on the iPhone Excel app

Published 05-29-2019 09:00 AM 18.9K Views
Occasional Visitor

Today, we are excited to bring Insert Data from Picture to iPhone users, now supporting 21 languages for both versions of the Excel mobile app (Android version available since March). This tabular recognition feature for Excel combines advanced optical character recognition (OCR) technology and machine learning models to transform paper-based information into digital data. Insert Data from Picture brings printed, tabular data directly into Excel, where you can perform various kinds of analysis that are time-consuming or even impossible with pen and paper. Read on to learn how the feature works.


Insertdatafrompicture NEW GIF.gif


Going from analog to digital

Simply open the Excel app on your phone, snap a picture of your paper-based data table, crop and review the image, and you’re done—no technical skills required. The data table is automatically embedded and ready for analysis in Excel.


“If only I had this before, I’d have saved so much time avoiding manual data entry” is one very popular reaction of Excel users so far. Going from analog to digital gives you time for more important tasks and is more secure. In addition, once a printed copy is converted, digital records are easier to organize and search—eliminating paper waste and reducing physical storage space.


Here are a few examples of how users can benefit from Insert Data from Picture:

  • Consolidate dozens, hundreds, or even thousands of rows of paper-based data in a flash—all without a single pencil mark.
  • Create illustrative charts and graphs to summarize information that was extremely difficult to communicate before.
  • Use Ideas in Excel to surface new trends and dependencies you might have missed when your data only existed on paper.
  • Easily archive data documents for future reference and compliance purposes.

Inside Excel: the technology behind the feature

To enable seamless data extraction from an image, Insert Data from Picture reuses many of the same OCR and Layout technologies previously released for Word (i.e., the PDF Reflow feature), Office Lens, and Seeing AI.


First, the image is analyzed to detect the main building blocks of the document, like text and graphical elements (e.g., table borders). For this, we further enhanced our Microsoft-built OCR engine to handle images with scattered text, which is often the case in tabular data and leveraged various image processing techniques to detect graphical elements.


Once the image is decomposed into main building blocks, Insert Data from Picture starts inferring the layout of the table. The most important part is detecting the grid of the table, which is done by generating grid candidates from horizontal and vertical lines (for bordered tables) and empty spaces between text (for borderless tables). After all the candidates are generated, the feature uses a combination of various heuristics and machine learning models to filter false positives and produce the final grid that will be reconstructed in the output. Producing that final grid relies on the analysis of each cell to build out other structures like paragraphs, font properties, and lists.


Artificial intelligence (AI) for more accurate results

For those who have used OCR-based features before, you know it doesn’t always get everything right. Insert Data from Picture takes special care to highlight potential errors, so you can focus on individual entries rather than on the whole thing. The good news is that this is an AI-powered feature designed for continues improvement, meaning that data accuracy will increase over time. To achieve this, we leveraged the collection of machine learning models where each model detects a specific case of misrepresented content (e.g., missed or added characters). Watch this Inside Excel episode to learn how the feature was built to address user needs. 


Left: A smart preview is generated after you crop the image. You can select any cell in this view to zoom into the source data. Center: Review and correct (or ignore) low-confidence entries, which are highlighted in red. Right: Tap “Insert” after reviewing potential issues to insert the final data into Excel.Left: A smart preview is generated after you crop the image. You can select any cell in this view to zoom into the source data. Center: Review and correct (or ignore) low-confidence entries, which are highlighted in red. Right: Tap “Insert” after reviewing potential issues to insert the final data into Excel.


Download Excel for your mobile phone and start using the feature today: Excel app for iPhone and Excel app for Android. To learn more about Insert Data from Picture, see our support article. Also, stay connected with Excel by visiting the Excel Tech Community, and follow us on Facebook and Twitter. We encourage you to send us ideas for new features on UserVoice and send us a smile or frown to help improve the product.


Frequently asked questions


What are the plans to support this feature on other platforms like Windows or iOS?

Insert Data from Picture will be available on iOS for Office Insiders next month. We’re also working to bring this feature to other platforms soon.


Which languages does the feature support?

The feature currently supports 21 Latin languages (such as French, German, and Spanish) for both Android and iPhone Excel apps. You can find the list of all supported languages here. More languages will be added in the future.


Do you need to have an Office subscription to use this feature?

You don’t need an Office 365 subscription. Anyone can download the app on their phones and start using Insert Data from Picture.

Occasional Visitor
Can you confirm that this feature isn't actually available on the iOS Excel app as of 5/29/19? The latest version of the iOS Excel app is 2.25 which was deployed 2 weeks ago. This feature is also not present on the office insiders version (2.26) of the Excel app which was deployed 5/28/19. Pretty confusing when you make this announcement and then in reality the feature isn't available yet.
Occasional Visitor

The functionality is present, but it is visibile only if you log in with MS account

@mors26 , I have no it with both my MSA and work accounts. It looks like it's not deployed for all regions so far.


I have version 2.25 and i'm logged in with an enterprise account. The feature is not there yet.

Regular Contributor

How accurate is this feature when you take a picture of a table that doesn't have borders? Awesome feature that I didn't know that I wanted nonetheless! 

Occasional Visitor

I'm logged in with o365 on iPhone X in the US and don't see the feature. Anybody get this to work on iOS?

Senior Member

There is a weird appearance on devices. I can see this feature on iPad Pro 11, iPhone 8 Plus, iPhone 8. But not on iPad PRO 2015, iPad Air logged with the same corporate account. @MS Excel Team  is there any limitation to see this feature on iOS devices? 

Occasional Visitor

OK, so today it works!

With me too

Occasional Visitor

Is this feature available for iPhoneX? I cannot see the button in my app

@aitorcalero , it shall be. Check to the right, it's not on the first positions.

Occasional Visitor

Thanks Sergei, but I cannot see it. I've scrolled to the right, tried other menus and I cannot see the button. Of course, I have a corporate account too. This is what I see:


Occasional Contributor

@MS Excel Team and @Sergei Baklan  I also do not see this feature on the menu, all of the video and images show it right in the middle of the bottom menu.... I am seeing the same thing as @aitorcalero 


Please advise I really wan to try this!!



Go to settings > Excel > and make sure the toggle for "Use Microsoft Online Service" is on

Community Manager

Hello! Just a heads up, but the MS Excel Team account was created purely to post to the Excel blog. They are not monitoring mentions and that account can't provide support. Their team will be monitoring comments without the tag though.


So best not to tag them and instead rely on helpful community members and MVPs like @Sergei Baklan


I was waiting for this feature since November, 2019.

When does it going to be available for Excel Desktop Version ?



Version history
Last update:
‎May 29 2019 10:18 PM
Updated by: