Convert PNG to XLS

A scanned table or screenshot must be converted when the recipient needs editable spreadsheet cells instead of a fixed image. PNG stores pixels rather than rows, columns, or formulas, so table conversion requires OCR before the result can be saved as an XLS workbook.

What the PNG format is

PNG (Portable Network Graphics) is a lossless raster-image format used for screenshots, scanned documents, charts, forms, and images with transparency. Web browsers, Microsoft Paint, macOS Preview, Adobe Photoshop, and scanner software can create or save PNG files. A PNG can display a table but contains no native cell values, formulas, worksheets, or spreadsheet formatting rules.

What the XLS format is

XLS is the binary workbook format used by Microsoft Excel 97–2003. It can store worksheets, values, formulas, basic formatting, charts, and multiple sheets. XLS remains useful when a legacy accounting, reporting, or database application cannot open the newer .xlsx format. Modern Excel can open XLS files, but each worksheet is limited to 65,536 rows and 256 columns. If the receiving software supports it, .xlsx is generally preferable because it has higher worksheet limits and is the current Excel format.

How to convert PNG to XLS

With Microsoft Excel

1. Open a blank workbook in Microsoft 365 Excel for Windows or a supported Excel mobile app.
2. In Windows, choose Data → From Picture → Picture From File and select the PNG. On mobile, choose Insert → Data from Picture and capture or select the image.
3. Review the OCR results in Excel's inspection pane. Correct digits, decimal marks, dates, column boundaries, and blank cells.
4. Insert the recognized data into the worksheet.
5. Choose File → Save As, select Excel 97-2003 Workbook (*.xls), and save the file.

Data from Picture is intended for tabular images and may not exist in older perpetual editions of Excel or in every platform version. If Excel only inserts the PNG as an image, that is an embedded picture, not a cell conversion.

With ABBYY FineReader PDF

1. Open the PNG in ABBYY FineReader PDF.
2. Set the OCR language to every language used in the image.
3. Run OCR, check the detected table regions, and correct cell boundaries, text, and reading order.
4. Export the recognized table as a Microsoft Excel workbook.
5. If ABBYY creates an .xlsx file, open it in Excel and choose File → Save As → Excel 97-2003 Workbook (*.xls).

ABBYY is useful for multi-page scans and complicated tables because it allows table regions and recognition errors to be corrected before export.

With an online OCR service

For non-confidential images, a service such as OnlineOCR can recognize a PNG and produce spreadsheet output. Upload the image, choose Excel output when available, run OCR, download the result, and save it from Excel as Excel 97-2003 Workbook (*.xls) if the service supplies only .xlsx. Online services vary in their table reconstruction, file-size limits, and retention policies; do not upload invoices, identity documents, financial records, or other sensitive files unless those terms are acceptable.

Quality and compatibility limits

OCR accuracy depends on resolution, contrast, skew, focus, text size, handwriting, and table complexity. Use a straight, sharply focused scan at approximately 300 dpi for printed text, crop unrelated graphics, and improve contrast before recognition. Check decimal points, minus signs, currency symbols, and characters that resemble one another, such as 0/O and 1/I. OCR may also misidentify dates, merged cells, empty cells, and numbers with leading zeros.

The process cannot recover formulas that were merely displayed in the PNG. OCR normally captures their visible results as text or numbers, not as working formulas. Charts, logos, colors, merged-cell layouts, and handwritten annotations may need manual reconstruction. Compare totals and critical values with the source image before using the XLS file for accounting, reporting, or data import.