How to Import Data from a Picture into Excel

Tired of manually typing data from a printed handout, a screenshot, or a locked PDF into an Excel spreadsheet? You’re not alone. This mind-numbing task is a major time-waster, but thankfully, Excel has a built-in feature that acts like a scanner for your data. This article will show you exactly how to use Excel's Data from Picture function on both your computer and your phone to turn images into editable data instantly.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is Excel's 'Data from Picture' Feature?

For years, a common workplace chore involved taking a printed document - like a price list, an attendance sheet, or financials from a report - and painstakingly transcribing it into a spreadsheet. Excel's Data from Picture dramatically speeds up this process using a technology called Optical Character Recognition (OCR).

Here’s how it works:

1. You provide Excel with an image containing a table of data.
2. Excel's artificial intelligence analyzes the pixels in the image to identify text and numbers.
3. It then recognizes the table’s structure - where the rows and columns are - and works to place the recognized text into the correct cells.
4. Finally, it gives you a chance to review and correct any values it was unsure about before importing them into your worksheet.

Instead of you typing everything out by hand, the AI does the heavy lifting, turning what used to be a 30-minute task into a 30-second one. It's a perfect solution for converting static, "un-copyable" data into a fully functional and editable spreadsheet.

When Should You Use This Feature? Practical Examples

This feature isn't just a gimmick, it solves real-world problems. Here are a few common scenarios where importing data from a picture is incredibly useful:

• Digitizing Printed Documents: You're handed a printed inventory list or a schedule at a meeting. Instead of typing it all in later, you can snap a photo with your phone and have it in Excel before you even get back to your desk.
• Extracting Data from PDFs: You have a research report or a vendor catalog in PDF format where the text can't be selected or copied. Take a screenshot of the data table and import that image directly into Excel.
• Capturing Online Data: You find a data table on a website or in an online presentation, but it’s saved as an image. A simple screenshot is all you need to pull that data into a usable format.
• Transferring Notes from a Whiteboard: After a brainstorming session, snap a photo of the neatly written table on the whiteboard. Excel can often recognize the handwriting and convert it, though printed text works best.

How to Import Data from a Picture File into Excel (Desktop)

Using the feature on the desktop versions of Excel (for Windows, Mac, or web) is perfect when you already have an image file saved, like a screenshot you just took. The process is straightforward and only takes a few clicks.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Get Your Image Ready

First, make sure your image is saved in a common format like PNG, JPG, or GIF. The quality of your image is the single most important factor for success. For the best results, ensure your image has:

• Clear, legible text. Fuzzy or low-resolution images won't work well.
• Good, even lighting. Avoid harsh shadows or glare across the data table.
• A straight-on perspective. Tables photographed at an angle can be distorted, making it harder for the AI to read accurately.

If you're taking a screenshot, try to crop it so only the table is visible. This helps Excel focus on the data you actually want to import.

Step 2: Navigate to 'From Picture' in the Data Tab

Open a new or existing workbook in Excel. Click on the Data tab in the main ribbon. In the "Get & Transform Data" section, you'll see an option called From Picture. Click on it, and a dropdown menu will appear.

Select Picture From File. An explorer window will open, allowing you to navigate to and select the image file you want to import.

Step 3: Let Excel Analyze the Image

Once you select your image, a "Data from Picture" pane will appear on the right side of your screen. Excel will show a progress indicator while its AI analyzes the image, identifies text, and maps out the table structure. This usually takes just a few seconds.

Step 4: Review and Correct the Data

This is the most crucial step. Excel's AI is good, but it's not perfect. It will automatically flag any characters or values it's not confident about with a pink highlight. Your job is to act as the human supervisor.

In the right-hand pane, you can see a list of all the values that need review. Click on the first one. Excel will show you a small snapshot from your original image and the value it thinks it recognized. You can simply type the correct value into the text box and click "Accept."

You can quickly move through all the flagged cells this way. Common errors include mistaking the letter "O" for the number "0," or "I" for "1." It's always worth taking a minute to review everything, even cells that aren't highlighted, just to be safe.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 5: Insert the Data into Your Worksheet

After you’ve completed your review (or if you’re happy to review it directly in the sheet), click the blue Insert Data button at the top of the pane. A small dialog box might pop up reminding you that you are responsible for validating the accuracy of the data. Click Insert Data again.

And that's it! The data from your image will now appear in your Excel worksheet, properly formatted in columns and rows, ready for you to work with.

How to Import Data with the Excel Mobile App (iOS & Android)

Sometimes, the handiest tool is the one in your pocket. The Excel mobile app makes this process even faster by letting you use your phone's camera to capture data on the fly. This is perfect for digitizing a document right as you receive it.

Step 1: Open Your Workbook and Find the Icon

Open the Excel app on your smartphone and create a new blank workbook or open an existing one. Tap on a blank cell where you want your data to start. At the bottom of the screen, you should see a toolbar with several icons. Look for the Insert Data from Picture icon - it looks like a small grid with a camera lens. Tap it.

Step 2: Take or Select a Photo

Your camera will now open within the Excel app. You have two options:

• Take a new picture of the document.
• Select an existing picture from your phone's photo library.

If you're taking a new photo, hold your phone steady and parallel to the document to avoid skewed angles. Make sure the entire table of data is visible in the frame.

Step 3: Crop the Image to Isolate the Table

After you've taken or selected the picture, the app will prompt you to crop it. Drag the handles on the corners and sides of the white border so that it tightly frames only the data table. Cropping out any extra background, headers, or surrounding text will greatly improve the accuracy of the data extraction. Once you're done, tap Confirm or Done.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 4: Let Excel Work and Review on the Go

Just like on desktop, Excel will now process the image. Afterwards, it will show you a preview of the extracted data. Any cells that need your attention will be highlighted in red. Tap on a highlighted cell to get options to Edit it or approve it as is. You can make any necessary corrections right on your phone screen.

Step 5: Insert the Data

After you've quickly reviewed the data and made any changes, tap the Insert button at the top of the screen. The data from the photo will be placed directly into your spreadsheet, starting at the cell you originally selected.

Pro Tips for Getting Accurate Data from Your Pictures

Following a few best practices can significantly reduce the number of corrections you have to make.

• Quality Over Quantity: A blurry, poorly lit photo is the number one cause of errors. Take your time to get a crisp, clear shot. If possible, use your phone’s flash if the lighting is poor, but watch out for glare.
• Simple Tables Have Better Luck: The feature works best on simple grids of rows and columns. Tables with merged cells, strange orientations, or nested columns might confuse the AI and require more manual cleanup after import.
• Check for Common Mix-ups: Always give the final data a quick scan for common OCR mistakes, like numbers misread as letters (5 vs. S, 1 vs. l) or similar punctuation (a decimal point vs. a comma).
• Double-Check Your Numbers: If you’re dealing with financial or other critical numerical data, be extra diligent in your review. An OCR error in a text field is an inconvenience, a misplaced decimal in a sales report can be a disaster.

Final Thoughts

Digitizing data with Excel's Data from Picture tool is a powerful feature that eliminates one of the most tedious manual data entry tasks. By transforming dead text from images into live data in a spreadsheet, you can save a significant amount of time and effort, whether you're at your desk or on the go with your phone.

Automating data entry is a huge step, but it's just the beginning. Manually building reports from that data can be just as time-consuming. This is exactly why we created Graphed. We wanted to automate the entire reporting process, not just one part of it. Instead of importing data and then building charts, Graphed connects directly to your data sources - like Google Analytics or Shopify - and lets you build entire dashboards just by describing what you want to see in plain English. No more pivot tables, no more VLOOKUPs, just answers in seconds.