How to Convert a Photo of a Table to Excel (3 Methods, Free First)

BygImageReader Team
⚡ Quick Answer

Free method: OCR the table photo with gImageReader, copy the text, and rebuild the table in Excel (works for simple tables). For automatic table-to-Excel conversion that preserves rows and columns, you need paid software like ABBYY FineReader — free tools read lines, not grids.

A photo of a table — a price list, a bank statement, a class schedule — and you need it in Excel. This is one of the most requested OCR tasks, and also one where free and paid tools differ most dramatically. Here’s the honest breakdown.

Method 1: Free — OCR + Manual Rebuild (Simple Tables)

1

Photograph the table straight-on

Shoot perpendicular to the page in even light. Skewed photos destroy column alignment — the most common failure.

2

OCR with gImageReader

Import, set the language, and recognize. You’ll get all the text — just not in columns.

3

Rebuild in Excel

Paste into Excel, then use Data → Text to Columns to split on spaces or delimiters. For small tables (under ~30 cells), this takes five minutes and costs nothing.

Why free tools struggle: Tesseract is a line recognizer — it reads text row by row and has no concept of a table grid. Columns collapse into a single text stream. No preprocessing fixes this; it’s architectural. Our comparison test demonstrates it with a real bank statement.

Method 2: Automatic — ABBYY FineReader (Complex Tables)

ABBYY analyzes the page structure first — detecting the grid, headers, and merged cells — then reads the text into the right cells. The result opens in Excel with rows and columns intact. If you convert tables weekly, the time saved pays for the license within a month.

Try ABBYY FineReader Free →

*This link takes you to the official ABBYY website. We may earn a commission if you purchase via this link, at no extra cost to you.*

Method 3: Excel’s Built-in “Data from Picture”

Microsoft 365’s Excel has Data → From Picture, which photographs a table and imports it — surprisingly decent for clean, simple tables, and free if you already subscribe. Worth trying before buying anything.

Rule of thumb: one-off simple table → free Method 1. Weekly tables or financial statements → Method 2. Already paying for Microsoft 365 → try Method 3 first.

Frequently Asked Questions

How can I convert a photo of a table to Excel for free?
OCR the photo with a free tool like gImageReader to extract the text, paste it into Excel, and use Data → Text to Columns to split it. This works for simple tables; complex grids with merged cells won’t survive the free route.
Why does free OCR mess up table formatting?
Free Tesseract-based OCR reads text line by line and doesn’t understand table structure — columns collapse into one text stream. Preserving the grid requires document-analysis AI found in paid tools like ABBYY FineReader.
Can Excel convert a picture of a table automatically?
Yes — Microsoft 365 Excel has a built-in “Data from Picture” feature that photographs a table and imports it. It’s decent for clean, simple tables and free with a subscription. For complex or frequent conversions, dedicated OCR software does better.

Start with free OCR

Download gImageReader — free table-text extraction in minutes.

Download gImageReader Free

Similar Posts