Text recognition often reads straight across columns or runs table cells together into one line of text. That’s fine for search, but risky for accounts, forms and reports, where a number’s position tells you what it means.

Step by step

  1. Capture the whole table.Keep borders, headers, row labels and footnotes inside the frame. Don’t crop off the row or column labels.
  2. Keep an unfiltered page.A strong contrast filter may erase faint lines or decimal points. Save the original image before you make a high-contrast copy.
  3. Check the order of the text.Search for a header and copy a few values that sit next to each other. Check that they come out in the same order as the rows and columns on the page.
  4. Use OCR to find things.Use the recognized text to find documents, not as data, unless you’ve checked it. Check totals, ID numbers, and which value belongs in which row and column by hand.

Check before you send

Check the first, middle, and last rows, plus any merged cells or footnotes. If a table is important, keep the image to refer to, or type the key values in by hand and check them, rather than copying the OCR text unchecked.

  • The table’s edges and headers are visible.
  • You checked the order of the copied text.
  • Decimals and units were checked.
  • Each important value is still next to its label.
In Paperlane

A searchable table isn’t the same as a spreadsheet. Paperlane keeps the image visible so you can check what the OCR text actually means.

Why a searchable table isn’t a spreadsheet

In a table, each number means something because of the row and column it sits in. OCR may read every number but lose which label, unit or row each one belongs to.

Test a header, a middle row, a merged cell, and a footnote. Copy a short sample into plain text and compare its order with the table on the page before you move values into accounting or reporting software.

How to decide

Retake the page or type in important values by hand when columns run together, decimals disappear, or the table is too faint to read. A clear image plus values you typed and checked is safer than a searchable table with wrong numbers.

Try this first

Use OCR to find the invoice or line item, then check the value and its label against the page before you act on it.

Example

Say OCR reads every number on an invoice but puts the tax amount next to the wrong line item. Search still finds the invoice, but the numbers are in the wrong places. Check which value belongs to which row before you move data into another app.

When the layout matters, use OCR to find the page and trust the image for the values. Typing values in by hand and checking them is slower than copying, but faster than fixing a wrong report.

Questions people ask

Can OCR make a spreadsheet?

It can help you pull out the text, but it can’t guarantee each value lands in the right cell. Check important cells or type them in by hand.

Why are columns merged?

OCR may read the page straight across, line by line, as if it were ordinary text. Better contrast and OCR that detects page layout can help, but you still need to check the result.

Can OCR convert a table directly into a spreadsheet?

It can help you pull out the text, but it can’t guarantee each value ends up in the right cell. Check important values, or type them in by hand and check them.

Use recognized text to find documents, not as a replacement for the page. Compare names, numbers and layout with the scan before you reuse or share the text.