PCMag editors select and review products independently. If you buy through affiliate links, we may earn commissions, which help support our testing.

How to Import Data Into Excel by Snapping a Photo of It

Take a picture of something with the Microsoft Excel mobile app, and it will turn the photograph into editable text inside a spreadsheet. Here's how to do it.

 & Jason Cohen Senior Editor, Help & How To

Our team tests, rates, and reviews more than 1,500 products each year to help you make better buying decisions and get more from technology.

Our Expert
LOOK INSIDE PC LABS HOW WE TEST
65 EXPERTS
43 YEARS
41,500+ REVIEWS

Data entry is a painful chore. If only there was a way to automate the process of taking data from one location and adding it to a spreadsheet. Now there is, with the mobile version of Microsoft Excel.

You can now take a picture of a chart with the app (iOS, Android) and convert it into editable text.

First, sign into (or create) a Microsoft Account; otherwise you won't be able to create new spreadsheets or edit any data.

Then, create a new workbook by tapping the icon in the upper-right corner of the app and selecting the kind of document you want to open.

Excel app

If you're looking to import data from a picture, you can snap a photo from the Excel app. Tap the Data from Picture icon on the bottom toolbar to open your camera. Focus on the chart you wish to enter into a spreadsheet, and you will see an orange rectangle appear as the app attempts to read the data. Snap the picture and it will be available for review.

Excel app

After you take the photo, the app gives you a chance to look over the image and determine whether or not you want to continue working with it. Tap the checkmark on the screen to move to the next step, or tap the X button to try again. You can also crop and rotate the image from this screen.

Excel App

From here you can edit the preview. Excel will show you the image captured next to its best approximation of the data in it. The app will flag the cells it feels may feature questionable results, which are highlighted in red. Tap Review to see each item individually and select Ignore to accept or Edit to make changes. You can also double-tap on a cell to edit. Tap Done to save any changes.

Excel app

Once you have reviewed everything, tap the Insert button to add the chart to your spreadsheet. The app then lets you share the final product by emailing it as an attachment or sending a link.

Excel app

While this process works with both images taken off paper and from a screen, I found that the former works much better than the latter. An image taken from a piece of paper just needs some grammatical cleanup, while a picture of a computer screen may need significant reformatting due to distortions.

Much like popular text translation apps, spelling and formatting can become a little wonky, but it sure beats trying to recreate a chart from scratch.

About Our Expert

Jason Cohen

Jason Cohen

Senior Editor, Help & How To

My Experience

As PCMag's editor of how to content, I have to cover a wide variety of topics and also make our stories accessible to everyday users. Considering my history as a technical writer, copywriter, and all-around freelancer covering baseball, comics, and more at various outlets, I am used to making myself into an expert.

I believe tech corporations are bad, but you might as well know how to use technology in everyday life. Want more how to content delivered right to your inbox? Sign up for the tips and tricks newsletter that I curate twice a week.

The Technology I Use

My job as how-to guru means I use just about every gadget under the sun, so I can figure out how everything works. I work from a Lenovo ThinkPad running Windows 11, but also have a very large Dell Inspiron 17 3000 and Apple silicon MacBook. I also have a Google Pixel 6a for personal use and use a Galaxy Z Flip 4 for additional Samsung-related testing. For iOS coverage, an iPhone 13 mini works like a charm, though it's already becoming a little long in the tooth.

My desktop situation includes a dual monitor setup with a modest Acer monitor. I also use a Logitech mouse (who can use these ThinkPad trackpads) and a Havit keyboard (my first mechanical keyboard; I love it but my wife hates it!). I'm a recent convert from wired headphones; I have Anker Soundcore Liberty Air wireless earbuds for personal use and have taken to the Sennheiser HD 450BT headphones for work.

Whenever I have a second to myself, I'm probably gaming on my Nintendo Switch, Steam Deck, or Xbox Series S. I also still have a bunch of classic consoles lying around as well.

  • Breaking down complicated and confusing processes into simplified instructions
  • Finding new tech problems to solve
  • OS-level tips and tricks

Read full bio