Easily Extract Table Data From Images in Excel Using OCR

Learn how to instantly convert photos, screenshots, and images into editable Excel spreadsheets using built-in OCR tools and the Data from Picture feature.

Manually typing out data from a printed document, a PDF snippet, or a screenshot is one of the most frustrating and time-consuming tasks in any workflow. Fortunately, modern office applications feature powerful optical character recognition (OCR) tools that can do the heavy lifting for you, turning static pictures into fully editable spreadsheet cells in seconds.

Problem Description: Converting Images to Spreadsheets

You have tabular data trapped inside an image file (such as a JPG, PNG, or screenshot) and need it in a Microsoft Excel format. Without OCR technology, users are forced to transcribe numbers and text manually, which significantly increases the risk of human error, ruins formatting, and wastes valuable productivity time.

Quick Answer for Extracting Table Data from Photos

To quickly convert an image to data in Excel, navigate to the Data tab on the ribbon and click From Picture. Select your image source, allow Excel to analyze the contents, review any highlighted corrections, and click Insert Data to populate your spreadsheet.

Likely Causes Behind Manual Data Entry Bottlenecks

• Un-copyable Formats: Receiving data in flattened PDFs, web screenshots, or presentation slides where text selection is disabled.
• Physical Documents: Needing to digitize printed financial reports, receipts, or paper rosters without a dedicated scanner.
• Lack of Source Files: Collaborators sending image exports instead of the original raw spreadsheet files.
• Legacy Software Limitations: Using older spreadsheet software that lacks integrated AI or OCR capabilities.

Recommended Solution: Extracting Data Using Excel OCR

1. Open Microsoft Excel (ensure you are using Microsoft 365, as this feature requires a subscription) and open a blank or existing workbook.
2. Click on the Data tab located in the top ribbon menu.
3. Locate and click the From Picture button. (Note: On some smaller screens, this might be nested under a 'Get & Transform Data' group).
4. Select either Picture from File... (if you saved the image to your computer) or Picture from Clipboard (if you just took a screenshot or copied an image).
5. Wait a moment while Excel's AI analyzes the image and extracts the tables and text.
6. A side panel will appear showing the extracted data. Excel will highlight areas with low confidence (often caused by smudges or strange fonts) in red. Click Review to verify and correct these specific cells.
7. Once you are satisfied with the preview, click the Insert Data button, then click Insert Anyway to finalize. The data will seamlessly populate into your grid.
8. Reference: For official Microsoft troubleshooting regarding this feature, you can visit their Data from Picture guide.

Alternative Solutions for Image-to-Text Conversions

1. Use Microsoft OneNote: Paste your image into a OneNote page. Right-click the image and select Copy Text from Picture. You can then paste the raw text into Excel and use the "Text to Columns" tool to organize it.
2. OneDrive Mobile App: Open the OneDrive app on your smartphone, tap the camera/scan icon, and swipe to the Document or Table scan mode. This allows you to snap a picture of a physical document and directly save it as an editable Excel file to your cloud storage.
3. Excel Mobile App: The Microsoft Office app on iOS and Android has a built-in "Image to Table" feature. Open the app, tap the '+' icon, select Excel, and choose "Scan Table" to use your phone's camera.

Working with WPS Office: Built-in Picture to Excel Tools

If you are looking for a powerful, free alternative to Microsoft 365, WPS Office offers excellent built-in OCR capabilities that rival premium suites. Inside WPS Spreadsheets, you can navigate to the Tools tab and select Picture to Text or use the dedicated PDF and OCR toolkits to accurately convert image-based tables directly into editable spreadsheets. WPS Office is highly compatible with Microsoft formats (.xlsx, .csv) and is a fantastic choice for users who need advanced document digitization without a recurring subscription.

Prevention Tips for Poor OCR Accuracy

• Maximize Image Resolution: Ensure your screenshots are high quality and not overly compressed. Blurry text is the primary cause of OCR failure.
• Improve Lighting and Angles: If taking a photo of a physical document, ensure the paper is flat, well-lit without harsh shadows, and photographed directly from above (avoid skewed angles).
• Crop Unnecessary Elements: Before running the OCR tool, crop out any background graphics, logos, or surrounding UI elements that might confuse the table recognition AI.
• Use Standard Fonts: OCR works best on standard, printed fonts. Heavily stylized fonts or handwriting will require much more manual correction.

FAQs About Spreadsheet Image Recognition

Why is the "From Picture" button missing in my Excel Data tab?

The Data from Picture feature is exclusively available to Microsoft 365 subscribers. If you are using a standalone, perpetual license version like Office 2019 or Office 2021, or if you are completely offline without cloud-connected experiences enabled in your privacy settings, the button will not appear.

Can Excel's OCR read handwritten tables?

While the OCR technology is highly advanced and can occasionally pick up incredibly neat handwriting, it is primarily optimized for printed text. Handwritten numbers are prone to high error rates and will require thorough manual review before inserting.

Is this feature available on Mac?

Yes. The Data from Picture feature is fully supported on Microsoft 365 for Mac. You can access it by going to the Data tab and selecting the same "From Picture" option.