How to Convert an Image of Data into an Excel Table
Question details
The user needs to extract tabular data from an image and convert it into an editable Excel spreadsheet using optical character recognition (OCR).
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user has a picture containing structured data and wants to import it directly into a spreadsheet without having to type all the information manually.
- Observed behavior
- Older versions of Excel and Windows lack native image-to-table OCR features, requiring alternative tools or specific built-in functions in newer versions to recognize and format the text into cells.
Ensure your image is clear, well-lit, and has high contrast to improve OCR accuracy. If your image contains sensitive or confidential data, avoid using public online converters to prevent data leaks.
Use the Built-in 'Data from Picture' Feature in Excel
If you are using Microsoft 365 or a newer version of Excel, you can use the native image-to-data feature to seamlessly import tables.
Modern versions of Excel include a powerful built-in OCR feature that scans pictures and translates them into an editable table format directly within the application.
Open your Excel workbook and click on the 'Data' tab in the top ribbon.
Click on 'From Picture' (usually located in the 'Get & Transform Data' group). Select either 'Picture from File' to upload a saved image or 'Picture from Clipboard' if you have copied an image.
Excel will analyze the image and open a preview pane. Review the extracted data and click on any highlighted cells to correct recognition errors.
Once verified, click the 'Insert Data' button to finalize the conversion and place the table into your active worksheet.
Use a Trusted Online OCR Converter
For older Excel versions or quick standalone tasks, a web-based OCR converter can turn your image into an XLSX file.
Convert Images to Spreadsheets Instantly with WPS Office
WPS Spreadsheet features a powerful, built-in 'Picture to Text/Table' tool. It uses advanced OCR technology to quickly and accurately extract data from images and place it directly into your workbook, bypassing the need for unsafe third-party converters.
- 1. Open WPS Spreadsheet: Launch WPS Office and open a new or existing Spreadsheet workbook.
- 2. Access Picture to Table: Navigate to the 'Tools' or 'Data' tab on the ribbon and select the 'Picture to Table' option.
- 3. Upload your image: Choose an image from your local drive or take a screen capture of the data you want to convert.
- 4. Extract and Insert: Review the smart extraction preview, make any quick edits if needed, and insert the formatted table directly into your active sheet.
Frequently Asked Questions
Why is Excel's 'Data from Picture' button missing on my computer?
This feature is primarily available to Microsoft 365 subscribers and newer versions of Excel. If you use Excel 2019 or older, or if you are on a restricted enterprise license, the button will not appear on your Data ribbon.
How can I improve the accuracy of the image-to-table conversion?
To get the best OCR results, ensure your image is high-resolution, cropped strictly to the table data, and free of shadows, glare, or distorted angles. Standard, highly legible fonts also yield better recognition than handwritten text.
Can I extract data from a scanned PDF into an Excel table?
Yes. You can either take a screenshot of the table within the PDF and use the 'Picture to Table' feature, or use a dedicated PDF-to-Excel converter tool, which often possesses robust native OCR capabilities specifically tuned for document conversion.
Is it safe to use free online OCR tools for business data?
It is generally not recommended to upload confidential business, financial, or personal data to free online converters. Their data retention and privacy policies may compromise your security. Using built-in offline tools or trusted enterprise applications is much safer.
