Shot2Text

Convert an Image to Text in Excel — Into Real Columns

Extraction gives you text, not cells. The real work is the second step — and the leading-zero trap that quietly destroys invoice numbers.

You have a picture with numbers in it — an invoice, a bank statement screenshot, a photographed table — and you want those numbers in a spreadsheet. The trick is not the extraction; it is getting the result into columns rather than one long string.

The honest version first

Text extraction gives you text, not cells. Nothing about reading a picture can tell Excel "this number belongs in column C". So the workflow is: extract, then split into columns. That second step is where the time goes, and it is worth doing deliberately.

Step one: get clean text out

Use the screenshot to text tool for screenshots, the photo to text tool for photos of paper, or the scanned PDF to text tool for an image-only PDF.

Two things to get right here, because they decide whether step two is easy:

Line breaks matter more than you think. Each row of the original should be one line of text. If the reader merges three rows into one line, splitting becomes guesswork. Cropping to the table and nothing else helps.

Numbers need checking. Thermal-printed receipts and dot-matrix print are the worst offenders: a 5 with a missing row of dots reads as 6, an 8 with a smudge reads as 3. Read the figures back against the image before you trust the sheet.

Step two: get it into columns

Copy the extracted text. In Excel, click cell A1 and paste. You will get everything in one column — this is expected.

Now use Data → Text to Columns:

If your values are separated by a consistent character — a tab, a comma, or several spaces — choose Delimited, tick the right separator, and finish. This works when the original was a clean table with fixed character spacing.

If the columns are aligned by position rather than separated by a character, choose Fixed width and click the ruler in the preview to place column breaks. This is the better choice for text read from a printed table or an invoice, because the spacing in the source was visual, not a single repeated character.

Neither route is perfect. Expect to delete a stray column or nudge a break. On a ten-row table that is two minutes, which beats typing.

The alternative that avoids all of it

Excel itself can now read images directly: Data → From Picture → From File, or Insert → Picture → right-click → Copy Text from Picture depending on your version. Excel will place the recognised values straight into cells and show you a preview to confirm.

If that works for your image, use it — it is faster than any external route. It tends to work well on clean screenshots of tables and less well on photos, low-contrast scans, or anything with merged cells. And on older versions or Excel for Mac, the feature may not exist at all.

Getting numbers to behave

Two Excel annoyances that catch people out after a paste:

Leading zeros disappear. An invoice number like 0042381 becomes 42381. Fix it by formatting the column as Text before pasting, or by prefixing an apostrophe. Do this before the paste, not after — once the zero is gone, re-typing is the only recovery.

Dates get reinterpreted. 03/04/2026 may be read as March 4th or April 3rd depending on your locale. If the totals depend on the dates, check one against the source image before you build any formulas.

Numbers arrive as text. If a column of figures will not sum, it is probably text with a stray space or a non-breaking space in it. TRIM() or the Convert to Number warning badge fixes it.

When the source is a photographed table

Photographing a printed table works, with two caveats.

Shoot straight down, square to the page. Perspective distortion makes the right-hand columns progressively narrower, and once rows misalign, Text to Columns has nothing consistent to work with.

Crop to the table only. Include the whole table, exclude the desk, the heading and the footnotes. Fewer irrelevant lines means fewer rows you have to delete afterwards.

Avoid photographing a screen if you can screenshot it instead — a screenshot of a table converts almost perfectly, because the letters have exact edges and the columns are pixel-consistent.

A word on what's in those images

Invoices and statements carry account numbers, addresses and sometimes card digits. Every site on this page reads the image inside your browser and never uploads it, which matters more here than for most conversions: a spreadsheet of financial data is exactly the sort of thing you do not want sitting on a server you know nothing about.

The summary

  1. Screenshot rather than photograph, whenever possible.
  2. Crop tightly to the table — the whole table, nothing else.
  3. Extract the text.
  4. Check the numbers against the image before doing anything else.
  5. Paste into A1, then Data → Text to Columns (Fixed width for printed tables).
  6. Try Excel's built-in From Picture first if your version has it.
  7. Set number columns to Text before pasting, so leading zeros survive.

Step 2 is the one that decides whether steps 5 and 6 can work at all. If the column gaps are too narrow, or the screen still had grid lines on, the output arrives as one undifferentiated line and no amount of splitting will recover the columns. Extracting a table from a screenshot goes deeper on the crop-per-column route and on the digit confusions that quietly wreck a column of numbers.