Skip to main content

OCR extraction problem

Correct OCR Errors When Converting a Table Image to Excel

Detect character substitutions, missing rows and merged cells after extracting a photographed or scanned table.

Use the matching tool

Image to Excel

Open Image to Excel

What the error actually means

Optical character recognition estimates text from pixels. Low resolution, skew, shadows and grid lines can turn 0 into O, 1 into l, or decimal points into noise. The resulting spreadsheet may be well formed while containing incorrect values.

Likely causes

  • The image is blurred or angled.
  • Grid lines touch characters.
  • The table uses small or decorative text.
  • Handwriting or stamps overlap cells.

OCR substitution

Problem

10.50 recognized as IO,5O

Correct pattern

10.50 confirmed against the source image

A safe repair workflow

  1. 1Use the clearest, straightest image available.
  2. 2Extract a representative sample.
  3. 3Validate numeric and identifier columns with rules.
  4. 4Manually compare flagged cells with the image.

How to verify the result

A file that downloads successfully is not automatically a correct file. Check the result at both the structural and business-data levels:

  • Totals reconcile.
  • IDs match expected patterns.
  • No row or column is missing.
  • Low-confidence values are reviewed.

Read the deeper guides