How to Extract Data from Image to Excel

Manually re-typing data from an image into an Excel spreadsheet is one of the most tedious tasks imaginable. Whether you're grabbing data from a screenshot, a scanned report, or even a photo of a printed price list, the mind-numbing process of entering numbers and text cell by cell is slow and prone to error. Luckily, you can stop. This article guides you through several easy methods for automatically extracting data from an image and getting it into a clean, editable Excel file.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Data from Picture: Excel's Built-In Superpower

Many people don't realize that modern versions of Microsoft Excel (included in Microsoft 365) have a powerful feature specifically for this purpose. Called "Data from Picture," this tool uses Optical Character Recognition (OCR) to identify tabular data within an image and import it directly into your worksheet. It turns a manual, ten-minute task into an automated, ten-second one.

This is your best first option if you have an up-to-date version of Excel, as it's fully integrated and impressively accurate.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Use Data from Picture (Desktop App)

Here’s the step-by-step process for pulling data from an image file saved on your computer.

1. Go to the Data Tab: Open a blank workbook in Excel. In the top ribbon, navigate to the Data tab.
2. Select "From Picture": Look for the "Get & Transform Data" section. Here, you'll find an option called From Picture. Click it.
3. Choose Your Source: You'll see two choices: "Picture From File" and "Picture From Clipboard."
4. Let Excel Analyze the Data: Once you select your image, a "Data from Picture" pane will open on the right side of your screen. Excel's AI will analyze the image, identify the table structure, and start converting the characters it sees into text and numbers. This usually only takes a few seconds.
5. Review and Correct the Data: This is a critical step. No OCR system is 100% perfect, and Excel is transparent about that. It gives you a chance to review everything before importing.
6. Insert the Data: After you're satisfied with your review, click the blue Insert Data button. You may get one final pop-up asking for confirmation. Click "Insert Data" again, and the table will appear in your worksheet, perfectly formatted into rows and columns.

From there, you can format, sort, filter, and analyze the data just like any other Excel table.

For On-The-Go Data: Use the Excel Mobile App

What if the data you need isn't on your computer? Maybe it's on a printed receipt, in a physical report at a client's office, or in a product catalog. The Excel mobile app for iOS and Android has an incredibly useful, camera-first version of the "Data from Picture" feature.

How to Scan Data with Your Phone

1. Open the App and a New Workbook: Launch the Excel app and create a new, blank workbook.
2. Find the "Data from Picture" Icon: At the bottom of the screen with your worksheet open, tap on the "Insert" icon (often represented by a small button with a spreadsheet and a camera). From there, you'll see a Data from Picture option. An alternative is looking for a small table icon with a camera.
3. Capture the Image: Your phone's camera will activate. Position it over the document you want to scan so the table is clearly in view. A red border will appear, intelligently highlighting the table it detects. Once it looks right, tap the shutter button to take the photo.
4. Crop and Confirm: The app will give you a chance to crop the image, which is helpful for focusing only on the data you need to extract. Drag the corners to tighten the selection around your table and tap Continue or Confirm.
5. Review and Insert: Just like on the desktop, the app will process the image and then show you a review screen. You can tap on any cell to correct errors before tapping Open or Insert to drop the data into your mobile sheet. You can then save the file to OneDrive and open the clean, digital data on your computer seconds later.

Graphed

Still Building Reports Manually?

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

Watch the Demo

When You Don't Have Excel: Online OCR Tools

If you're using an older version of Excel that doesn't include the "Data from Picture" feature, or if you need a quick, one-off solution without opening any programs, web-based OCR converters are a great alternative.

These websites allow you to upload an image file, process it through their OCR engine, and download the output as an editable Excel file (.xlsx). Many of them are free for moderate use.

How to Use an Online Converter

While every site is slightly different, the general workflow is almost always the same:

1. Navigate to an online OCR to Excel conversion site (you can find dozens with a quick search).
2. Click the "Upload" button and select your image file.
3. Verify that the output format is set to "Microsoft Excel (XLSX)."
4. Click the "Convert" button.
5. After the process is complete, download the generated Excel file to your computer.

Important Considerations for Online Tools:

• Privacy and Security: Be very cautious about what you upload. You should never use a free, third-party web tool to process documents containing sensitive financial, personal, or proprietary business information. Assume anything you upload could be seen.
• Accuracy Varies: The quality of OCR can vary significantly between different tools. You may find that the resulting Excel file requires more manual cleanup than one processed by Excel's native feature.
• Limitations: Free versions often have restrictions on file size, the number of pages you can convert per day, or processing time.

The Google Sheets Workaround

Google Sheets doesn't have a direct "scan table" feature like Excel. However, if you're a committed Google Workspace user, you can use Google Drive's built-in OCR as a workaround. This method is a bit more manual and clunky, but it gets the job done.

1. Upload your image to Google Drive.
2. Locate the file in Drive, right-click it, and select Open with > Google Docs.
3. Google will automatically perform OCR on the image. It will open a new Google Doc with the original image at the top, followed by the extracted text underneath.
4. The text version of your table will likely lose its grid structure. At this point, you need to copy all the extracted text.
5. Open a new Google Sheets spreadsheet, click on cell A1, and paste the copied data.
6. Your data will probably be jumbled into a single column. From here, you'll need to use Google Sheets' data cleanup tools. The most useful one is Data > Split text to columns, which can separate the information into the proper columns based on delimiters like spaces, commas, or tabs.

This process requires more cleanup but is a viable option for those without access to Excel.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Tips for the Best Results

No matter which method you choose, the quality of your output depends almost entirely on the quality of your input. Follow these best practices to ensure a clean, accurate data extraction:

• Use High-Resolution Images: A clear, high-quality image is the single most important factor. If the text is blurry or pixelated, the OCR engine will struggle to read it correctly. Strive for at least 300 DPI (dots per inch).
• Ensure Good, Even Lighting: Shadows, glares, or dark spots can obscure characters and lead to errors. Take photos in brightly and evenly lit environments without a harsh direct flash.
• Shoot Straight-On: Capture the image from a flat, bird's-eye view. Taking a photo at an angle skews the text and distorts the table, making it much harder for the software to recognize the grid.
• Crop Out the Noise: Before processing, crop the image so that only the table you want to extract is visible. Extraneous headers, paragraphs of text, or other visual elements can confuse the OCR algorithm.
• Printed is Best: These tools work best on clean, printed, machine-readable text. While some OCR tech can handle neat handwriting, it’s far less reliable.
• Always Double-Check: Treat the raw output as a first draft. Always budget a few minutes to scan the final spreadsheet for common mistakes like 'O' vs. '0', '1' vs. 'l', or 'B' vs. '8' before you start using the data for analysis.

Final Thoughts

Manually transcribing data from images into spreadsheets is finally a thing of the past. Using tools like Excel's built-in "Data from Picture" feature, its mobile counterpart, or online converters, you can quickly turn static information into dynamic, actionable data ready for analysis.

Getting data out of images is a huge time-saver, but that’s often just the first step in a much longer reporting process. You might still have to pull related datasets from Google Analytics, your CRM, or your Shopify store to get the full picture. This is exactly the kind of manual work we built Graphed to eliminate. Instead of spending hours compiling data, you simply connect your business tools once and can then use plain English to get answers, build reports, and create real-time dashboards instantly.