NewSign up free to get 3 credits to try our new Merge Sheets feature

How to Digitize Paper Tables into Excel Without Retyping a Single Cell

Somewhere in your office, classroom, or kitchen drawer, there is a printed table you wish you had as a spreadsheet. A supplier price list. A professor's grading rubric photocopied from a textbook. An old inventory count scribbled on lined paper. Retyping it all feels like punishment. A good image-to-Excel converter does it in seconds, and with ImgToSheet the table usually comes out ready to use.

Here is how to go from paper table to editable XLSX file, with practical tips that determine whether you get clean data or a mess you still have to fix by hand.

Step 1: Get a Good Photo

The single biggest factor in extraction accuracy is the image itself. A blurry, shadowed phone photo of a crumpled page will produce garbled results no matter which tool you use.

What works well:

  • Flat surface, even lighting, no shadows crossing the table
  • Camera held directly overhead (not at an angle)
  • The entire table visible in frame, with a small margin on each side
  • Screenshots of on-screen tables (these convert almost perfectly because the text is already rendered cleanly)

What causes problems:

  • Handwriting (especially cursive or smudged ink)
  • Glossy paper with reflections
  • Tables where gridlines are missing and columns rely on whitespace alignment alone

If you are digitizing from a physical book, press the spine flat and photograph one page at a time. Cropping out everything except the table before uploading also helps the OCR model focus on the right region. For more on book pages specifically, see textbook tables to Excel.

Step 2: Run It Through an Image-to-Excel Converter

Upload your JPG, PNG, GIF, or WebP file to ImgToSheet. The tool sends your image through an OCR model that reads the text and reconstructs the original rows and columns. You get a preview of the extracted table in your browser, then download it as an XLSX file.

Accuracy is what people notice first. ImgToSheet keeps the table's shape: rows stay rows, columns stay columns, and merged headers and uneven layouts come through intact instead of collapsing into one long column. One r/excel user put it this way:

"My dude this works really well. Like holy shit this is the best I've used by a loooooonnnngggg shot." — A user on r/excel

A few things worth knowing about the process:

  • Files can be up to 10 MB each.
  • The XLSX file is generated in your browser. Your image is not stored on any server or database after processing.
  • The free tier gives you 5 conversions every 12 hours, one file at a time. If you are working through a stack of documents, Pro lets you upload up to 15 files at once and get one workbook with a sheet for each.
  • The output is an XLSX file, which opens in Excel, Google Sheets, or Apple Numbers. If you need CSV, open the XLSX and export from there.

Have a PDF instead of a photo? A scanned statement, an emailed invoice, a multi-page report: skip the photography step and use the PDF to Excel converter directly. The free tier reads the first page, and Pro reads every page of the document — each page comes out as its own sheet, and tables that share the same columns can be merged into one afterward.

Step 3: Give the Preview a Quick Look

Clean photos and screenshots usually come out right the first time. Still, a ten-second look at the preview is worth it before the file goes into your workflow, and every cell is editable right there. Things worth a glance:

  • Merged cells that got split into separate columns
  • Numbers read as text (a leading apostrophe or invisible formatting can prevent formulas from working)
  • Currency symbols or special characters that got dropped or substituted
  • Row alignment shifts where one row's data slid into the wrong columns

Even when a cell or two needs a fix, that beats retyping 200 of them. And catching it in the preview means you never build calculations on a bad number.

Step 4: Organize the Workflow When You Have Many Documents

Digitizing one table is straightforward. Digitizing 30 over the course of a week, while juggling other work, is where things fall apart. You lose track of which pages you have already converted, which files still need cleanup, and which ones are ready to merge into a master sheet.

A simple kanban board solves this. Create three columns: "To Scan," "Needs Review," and "Done." Each card represents one document. Move cards across as you work through the stack, whether that is a sticky-note board, a spreadsheet, or any lightweight task tool you already use.

This structure also helps if multiple people are splitting the work, since everyone can see at a glance which documents still need attention. When the tables share the same columns, Pro can merge them into one sheet instead of copying them together by hand.

When OCR Beats Manual Entry (and When It Does Not)

OCR is at its best on printed text with clear gridlines: invoices, price sheets, bank statements, report tables, and textbook data. For these, extraction is fast and the results are usually ready to use as they are.

It needs more help with:

  • Handwritten tables (legibility varies too much)
  • Tables embedded in complex page layouts with sidebars, footnotes, and overlapping elements
  • Very small text in high-density tables (zooming in and cropping to sections helps)

For a 50-row printed table with standard fonts, you will save 15 to 30 minutes of manual typing. Neat handwritten block letters convert well, with a few cells to correct. Messy cursive is the hardest case for any OCR tool, so expect more fixes, which the editable preview makes quick. Our guide to handwritten tables in Excel covers how to get the best results.

The Short Version

Photograph the table flat and well-lit, or start from the PDF if you have one. Upload it. Check the preview for errors. Download the XLSX. If you are processing many documents, track them on a board so nothing gets lost. That is the whole workflow, and it replaces hours of tedious data entry with a few minutes of setup and review.