Skip to main content
A table screenshot being converted into editable cells in an Excel spreadsheet

Guide

Getting a Table Screenshot Into Excel Without Retyping

Table OCR can rebuild rows from a screenshot—if the grid is clear. Here is what helps and what still needs a human pass.

By Muhammad Sulaiman

15 views

How to Convert a Screenshot of a Table to Excel for Free

Someone sends you a screenshot of a price list. You need to sort the prices, update a few rows, and share the result in Excel. The table is visible, but clicking on a number does nothing. It is part of an image, not an editable cell.

Quick answer: Crop to the table, ensure grid lines or clear columns are visible, then run Image to Excel. Always spot-check numbers; merged cells and shadows confuse detectors.

To turn a table screenshot into a workbook you can edit, use Image to Excel. Processing stays in your browser for normal use.

Free online tool

Try our Image to Excel

Convert table images to Excel XLSX with editable cells—OCR runs in your browser.

Try free

You could retype every row. For a longer table, that takes time and makes it easy to miss a digit. A table OCR tool offers a faster starting point: it reads the image, detects rows and columns, and creates a spreadsheet you can review.

Why can’t I copy a table directly from a screenshot?

A screenshot records pixels. It does not retain the original spreadsheet’s cells, formulas, or column structure. Even if you can select text with an OCR feature, copying it may put every value into one column or mix up the order of the rows.

To get an editable spreadsheet, you need to extract the table structure as well as the text inside it. IMG Free Toolkit’s Image to Excel converter does this for JPG, PNG, and WebP images.

How to turn a table screenshot into an Excel file

Start with the clearest image you have. A direct screenshot usually works better than a photograph of a screen because its text is sharper and its rows are straight. If you have a photo, try to keep the entire table in frame and avoid glare over important numbers.

Open the Image to Excel converter and add your image. You can also paste a screenshot. Select “Extract Table” to detect the rows and columns. The tool runs the OCR process in your browser and shows the extracted cells for review.

Check the result before downloading. Compare the first and last rows with the image, then inspect headings, decimal points, dates, totals, and any values where one wrong character would matter. Correct mistakes in the detected cells and download the Excel XLSX workbook.

If the image contains multiple detected tables, the workbook places them on separate sheets. Open each sheet and check that no rows or columns were missed.

What should you check after converting an image to Excel?

OCR is useful, but an extracted table still needs a human review. Pay particular attention to characters that look alike, such as 0 and O, 1 and I, or 5 and S. A price of 10.50 becoming 10.5 may be harmless in one task, while 100.50 becoming 10.50 is a serious error.

Look for shifted columns, too. If a long description wraps onto a second line in the image, OCR may interpret that line as a new row. Blank cells and tables without visible borders can also make the layout harder to detect. Compare a few rows across the entire width of the table rather than checking only the first column.

Do not assume the exported workbook contains the original spreadsheet’s formulas or styling. A screenshot cannot reveal the formula behind a displayed total. Recreate any calculations you need in Excel after verifying the extracted values.

How to get a better result from a table photo

Use a sharp, well-lit image and keep the camera parallel to the page. Make sure column headings are visible and avoid cropping the rightmost or bottom rows. If the table occupies only a small part of a large photo, crop closer to it while leaving all the cells intact.

For a screenshot, zoom in until the table text is readable before capturing it. If you can access the original spreadsheet, use that file instead of converting a screenshot. It will retain information an image cannot carry, including formulas and cell types.

Worked example: a real expenses screenshot to Excel

To show what you can realistically expect, we made a small sample table: seven office purchases and a total row (1,597.58) in five columns, with dark borders around every cell. We took a plain screenshot at normal (100%) zoom and ran it through Image to Excel on this site in desktop Chrome.

Before: a screenshot of an office expenses table with dark cell borders. After: the downloaded Excel file with the same nine rows and five columns, all 42 cells correct

What came out

  • All 42 cells were correct and in the right place: 9 rows by 5 columns, from the header to the total, with no extra columns.
  • The table appeared about a second after we clicked Extract Table, once the OCR data had loaded.
  • Qty and Amount were saved as real numbers with two decimals (42.50, 1,249.00), so a SUM over the Amount column gives 1,597.58 straight away.
  • The title above the table was left out of the sheet, so the header is row 1.

Lighter gridlines, no gridlines and photos

We repeated the test with faint spreadsheet-style gridlines, with no borders at all, at 200% zoom, and as two tilted, soft-focus photos of the printed table. Every screenshot version scored 42 of 42 again, and so did the photo with dark borders. The photo with faint gridlines scored 41 of 42: "Furniture" came back as "Fumiture".

Before: a tilted, slightly blurred photo of the expenses table. After: the downloaded Excel file with 41 of 42 cells correct and the misread word Fumiture highlighted

That slip is typical of photos: blur makes "rn" look like "m". The tool doesn't flag the cell, so with a photo, read the text columns against the original before you rely on them. The numbers held up better than the words. Every amount was right in every run.

Excel or CSV: which should you choose?

Choose Excel XLSX when you want a workbook and the option to keep multiple detected tables on separate sheets. Choose CSV when you need a simpler table file for importing into another application. IMG Free Toolkit also has an Image to CSV tool.

If the image contains ordinary paragraphs rather than a table, use Image to Text instead. Picking the tool that matches the image’s content makes the result easier to work with.

Can I convert a screenshot to Excel for free?

Yes. IMG Free Toolkit’s Image to Excel converter lets you extract a table, review and correct cells, and download an XLSX file for free. Processing happens in your browser, and the image is not uploaded to IMG Free Toolkit servers. Convert your table screenshot to Excel.

The most reliable approach is simple: start with a clear image, extract the table, and check the important values before using the workbook. That short review can save more time than retyping the entire table and prevent a small OCR mistake from becoming a spreadsheet error.

Related: receipt photo OCR · cleaner photo text extraction.

FAQ

Why are my columns split wrong?

Skewed screenshots and missing vertical separators confuse cell detection. Straighten and crop before retrying.

Does this work for handwritten tables?

Printed or on-screen tables work best. Handwritten grids are unreliable.