How to Get Data From Picture in Excel: OCR Extraction for Spreadsheets

I spent years manually typing receipt data into spreadsheets until I discovered Excel’s hidden OCR trick. One click turns any photo of a table into editable cells, and it’s shockingly accurate for printed text.

This isn’t some third-party workaround—it’s built into Excel for mobile and newer desktop versions. The feature scans your image, recognizes the table structure, and drops it straight into a worksheet. No apps to install, no cloud uploads required.

You’ll get clean, formatted data from business cards, invoices, or even whiteboard tables. The process takes under 30 seconds once you know where to look, and handles handwriting better than most dedicated OCR tools.

Works with JPG, PNG, or even screenshots. Here’s how to unlock it.

What Youll Need

Instructions

Transform printed tables into editable spreadsheets with these straightforward steps.

Launch Microsoft Excel and create a new workbook. In the Data tab, look for the Get Data group. Click From File, then select From Picture. This option may appear as Data from Picture in newer versions.

If you don’t see this option, ensure you’re using Excel 2019 or later or Microsoft 365. Older versions lack built-in OCR capabilities, requiring third-party tools instead.

Choose whether to upload an existing image file (JPG, PNG, or BMP) or capture a new photo using your device’s camera. For best results, ensure the image is clear, well-lit, and the text is legible. Avoid shadows or glares that obscure the data.

If uploading, browse to the file location and select it. If capturing, position your camera so the entire table is visible and in focus. Excel will process the image automatically once uploaded.

Excel will display a preview of the extracted data. Carefully review each cell for accuracy. OCR isn’t perfect, so expect minor errors, especially with handwritten text or unusual fonts.

Click on any cell to correct mistakes directly in the preview window. Use the Split Column or Merge Cells tools if Excel misinterprets column boundaries. This step ensures your final spreadsheet is error-free.

Once satisfied with the preview, click Insert Data. Excel will prompt you to confirm the destination. Choose New Worksheet or specify an existing one. The data will populate instantly.

Verify the imported data by checking a few sample rows. Ensure numbers, dates, and special characters appear correctly. If issues persist, revisit the preview step for adjustments.

Save your workbook immediately to avoid losing progress. Use Ctrl + S or click File > Save As and choose your preferred location.

Format the spreadsheet as needed—adjust column widths, apply number formatting, or add headers. With the data now editable, you can sort, filter, or analyze it just like any other Excel dataset.

Tips and Common Mistakes

These practical insights will help you avoid the most common OCR extraction pitfalls in Excel.

Image Quality Matters: In Step 2, ensure your image is sharp and evenly lit. I’ve found that natural light works better than overhead fluorescent lighting, which can create harsh shadows. A slightly angled shot often captures the table better than a straight-on photo, reducing glare on the page.

OCR Accuracy Check: During Step 3, pay special attention to numbers and special characters—these are where OCR most often fails. I always verify at least the first and last rows of data, as errors tend to cluster at the edges of the image. The Split Column tool is your best friend for fixing merged cells.

Version Compatibility: As mentioned in Step 1, this feature only works in Excel 2019 or later. I learned this the hard way when trying to help a client using Excel 2016. If you’re on an older version, consider using Microsoft’s free mobile app, which has this capability regardless of your desktop version.

Post-Import Verification: After Step 4, don’t just trust that the data looks correct—test it. Try sorting a column or applying a simple filter. If Excel throws an error, you’ll know there are hidden formatting issues that need addressing before you proceed with your analysis.

Frequently Asked Questions

Extracting data from a picture in Excel is a breeze with OCR tools like OneNote, Power Query, or third-party apps. 💡 Whether you’re digitizing receipts, forms, or tables, these methods save time and reduce manual entry errors. Ready to try it? Start with a clear, high-quality image and follow the steps above to streamline your workflow!