How to Convert an Image Table to Excel
A report screenshot, a photo of a paper table, or a scanned statistical sheet often contains data you want to calculate, summarize, or filter. Re-entering it cell by cell is slow and easy to misalign. Recognizing the table in an image and restoring it as an Excel spreadsheet gives you editable, computable data directly. This guide explains the steps, things to watch for, and common questions.
How table conversion differs from ordinary OCR
Ordinary OCR answers the question "which words appear in the image". Table conversion must also determine which row and column each value belongs to. It identifies table lines, cell boundaries, and row-column relationships, then places content into the corresponding Excel cells.
For this reason, regular tables with clear lines usually restore the best.
Conversion steps
- Open the ImgDoc image to Excel converter.
- Upload an image containing a table. Common image formats are supported, and several images can be added in order.
- Wait while the structure and cell contents are recognized.
- Download the generated .xlsx file and check that rows and columns align and the data is complete.
Before doing calculations, verify a few key numbers to confirm nothing has shifted into the wrong row or column.
Which tables restore well?
- Clear, continuous borders not covered by stamps or stains;
- Regular row heights and column widths;
- Short text inside cells without heavy spanning;
- Straight images with legible text;
- A clear distinction between headers and data.
Shooting paper tables straight on and avoiding tilted perspective noticeably reduces cell misalignment.
Things to know for complex tables
- Merged cells: Merged title rows may be split or repeated and may need manual merging.
- Borderless tables: Tables separated only by spacing are harder to judge and may shift columns, so check them carefully.
- Large tables across pages: Each page is usually handled separately, so add headers and continuity yourself when combining.
- Line breaks in cells: Multi-line text may become multiple cells and need adjustment.
- Number formats: Thousands separators, percentages, and dates follow the recognition result; reset cell formats if needed.
Common questions
Can I use formulas right away?
The result is normal cell content. Values stored as numbers can be calculated directly; if a number is recognized as text, change the cell format to a number.
What if rows and columns do not align?
Check whether the original image is clear, tilted, or borderless. Minor shifts can be fixed by moving columns or inserting rows in Excel; for severe misalignment, re-take the image and convert again.
What if one image contains several tables?
Crop it so each table is a separate image and convert them individually for cleaner structure and better accuracy.
Start converting
Get your table image ready and recognize it into Excel online:
Open the image to Excel converter
If the table is part of a PDF, read how to convert PDF to Word for handling different source files. If you only need words rather than a table, see how to extract text from images.