How to Get Data from Picture in Excel

Trying to copy data from a screenshot, a PDF, or a photo into an Excel sheet is one of the most tedious tasks imaginable. You're stuck manually retyping every line, squinting at the screen, and checking for typos. Thankfully, Excel has a built-in feature to do this automatically. This article walks you through exactly how to use the "Data from Picture" tool to convert an image into an editable Excel table in just a few clicks.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly Is Excel's "Data from Picture" Feature?

Years ago, turning a static image into usable data required specialized Optical Character Recognition (OCR) software. Now, that technology is built directly into Microsoft Excel for Microsoft 365 subscribers. The "Data from Picture" feature uses AI to analyze an image, identify data organized in a table format, and import it into a new worksheet.

It’s designed to save you from mindless manual data entry, whether you’re working with a PNG screenshot, a JPG photo, or an image you've simply copied to your clipboard. You have two primary ways to access this tool:

• Picture From File: This option allows you to import data from an image file saved on your computer.
• Picture From Clipboard: This is perfect for capturing data directly from a webpage, PDF document, or presentation without needing to save it as a separate file first.

This functionality is available on Excel for Windows, Mac, and even the Excel mobile apps for iOS and Android, making it incredibly versatile for capturing data on the go.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Guide: Getting Data from a Picture File

Let's start with the most common scenario: you have an image file (like a screenshot you’ve saved) and want to pull the data into Excel. For example, consider a price list from a printout saved as a JPG file.

Step 1: Navigate to the Data Tab

Open a new or existing Excel workbook where you want the data to go. Click on the Data tab in the ribbon at the top of the window.

Step 2: Select "From Picture"

In the "Get & Transform Data" section, you will see an option called "From Picture." Click on it to reveal a dropdown menu.

Step 3: Choose "Picture From File"

From the dropdown menu, select Picture From File.... This will open a standard file explorer window, allowing you to browse your computer.

Step 4: Select Your Image File

Locate the image file containing your data (e.g., .PNG, .JPG, .BMP) and click Insert. Excel will now start analyzing the image.

While it analyzes, a pane will appear on the right side of your worksheet showing a progress indicator. This usually only takes a few seconds, but it might take longer for more complex or lower-quality images.

Step-by-Step Guide: Getting Data from Your Clipboard

What if the data is on a webpage or in a PDF and you don't want to save a separate file? Using your clipboard is an even faster workflow.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Copy Your Image

First, capture the image you need. You can do this in a few ways:

• Webpages: Right-click on the image and select "Copy image."
• Screenshots: Use your computer’s screen-capture tool (like Windows key + Shift + S on Windows or Shift + Command + 4 on a Mac) to select the area containing the table. This automatically copies it to your clipboard.
• PDFs: Some PDF viewers have a "snapshot" tool that lets you select and copy a portion of the page as an image.

Step 2: Navigate to Data > From Picture

Go back to your Excel worksheet. Just like before, click on the Data tab and then click the From Picture button.

Step 3: Choose "Picture From Clipboard"

This time, select Picture From Clipboard. Because the image is already copied, Excel will immediately begin analyzing it. The same "Data from Picture" pane will appear on the right and show you the progress.

The Most Important Step: Reviewing and Correcting the Data

Once Excel finishes its analysis, it will present you with a preview of the data. Do not skip this step! The AI is very good, but it's not perfect. It often needs a little human help to get things right.

Understanding the Review Pane

The "Data from Picture" pane on the right shows a preview of your original image at the top and the extracted table beneath it. Excel will automatically highlight any values it is uncertain about in red.

• Reviewing cells: Simply click on any cell in the table preview to edit its contents. The corresponding area in the image above will zoom in, allowing you to easily compare the extracted text with the source image.
• Accepting Changes: As you review and make corrections, you are confirming the accuracy of the data. You can click on each red-highlighted item and either type the correct value or click an "Accept" button to approve Excel's guess.
• Common Errors: Keep an eye out for common OCR mistakes, like confusing the number 0 with the letter O, the number 1 with the letter l, or misinterpreting smudges or shadows as characters. Dates and special currency symbols can also sometimes be tricky for the AI.

Insert the Data

After you have reviewed all the highlighted items and feel confident in the preview, click the Insert Data button at the top of the pane. A confirmation dialog will appear, reminding you that you are responsible for the accuracy of the data. Click Insert Data again, and the information will be placed into your worksheet as a fully editable Excel table.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Tips for Getting the Best Results

You can help Excel's AI do a better job by providing it with the best possible source image. Here are a few practical tips to improve your accuracy:

• Use High-Resolution Images: The clearer your image, the better. Blurry, pixelated, or low-resolution pictures will produce poor results.
• Ensure Good Lighting: If you're taking a photo with your phone, make sure the document is flat and well-lit. Avoid shadows across the table, as they can obscure the text.
• Crop the Image: Trim your image so that it only includes the data table itself. Any extra text, graphics, or borders around the table can confuse the analysis.
• Stick to Simple Tables: This feature works best with straightforward, grid-like data. Complex tables with merged cells, nested headers, or unusual layouts may not be imported correctly.
• Straighten the Image: Ensure the image is not at an angle. The rows and columns of your data should be as horizontal and vertical as possible. Most photo editing tools have a simple feature to straighten skewed images.

Common Use Cases for "Data from Picture"

Not sure where this feature might fit into your workflow? Here are a few common scenarios where it can be a massive timesaver:

• Digitizing Printed Reports: Transfer financial statements, inventory lists, or printed documents into Excel without retyping anything.
• Capturing Online Data: Extract product information, pricing charts, or statistics from websites that don’t allow you to copy and paste text.
• Importing from PDFs: Pull tables from PDFs - especially scanned ones where the text is part of an image - directly into your worksheet.
• Saving Data from Presentations: Grab data shown on a slide during a webinar or meeting by taking a screenshot and importing it instantly.

Final Thoughts

Excel's "Data from Picture" feature is a powerful tool for overcoming the frustration of getting static data into a usable format. By analyzing images from files or a clipboard, it eliminates hours of tedious manual data entry and lets you focus instead on analyzing the information.

This is a brilliant solution for one-off tasks and converting static images, but much of a modern business’s data doesn’t live in pictures - it's scattered across dozens of live platforms. At Graphed , we automate the painful work of pulling real-time data from tools like Google Analytics, Shopify, Salesforce, and Facebook Ads. Instead of downloading spreadsheets or taking screenshots, our platform connects directly to your data sources, allowing you to create live dashboards and get instant insights just by asking questions in plain English.