You've got a photo of a price list, an invoice, a schedule, or some other table, and retyping every row and column by hand sounds like a genuine waste of an afternoon. OCR can pull the text out for you automatically. Getting that text into clean spreadsheet columns takes one extra step, but it's a fast one, not a manual retyping job.

Here's a realistic, honest walkthrough of how to do it.

What OCR Actually Gives You

Most OCR tools, including simple browser-based ones, read text in order, left to right, top to bottom, and hand it back to you as plain text. For a table, that usually means each row comes out as a line of text with the values separated by spaces, not dropped into neat spreadsheet columns automatically.

That's genuinely fine. It still saves you from retyping every number and label by hand, you just need one more step to turn that plain text into structured columns, and Excel already has a built-in tool that does exactly that.

Step-by-Step: From Photo to Spreadsheet

  1. Get a clear photo or screenshot of the table. Straight-on angle, good lighting, and the full table visible in frame all make a real difference in accuracy.
  2. Run it through an OCR tool like OCRTool.net to extract the raw text.
  3. Copy the extracted text and paste it into a single column in Excel or Google Sheets.
  4. Use Excel's Text to Columns feature (Data tab → Text to Columns) to split each line into separate columns, based on spaces, tabs, or commas, whichever separator matches how your text came out.
  5. Clean up any misaligned rows. OCR occasionally merges or splits a line unexpectedly, so a quick scan through the result catches anything that landed in the wrong column before you rely on it.
  6. Double check the numbers specifically. Prices, quantities, and dates are exactly the kind of thing where a small misread (a 5 read as an S, a 0 read as an O) actually matters, so give those a second look.

What This Is Actually Useful For

  1. Turning a photographed price list or menu into an editable spreadsheet
  2. Pulling line items off a photographed invoice or receipt
  3. Digitizing a printed schedule, roster, or timetable
  4. Converting a scanned form with tabular fields into structured data
  5. Getting data out of an old paper record that was never digital to begin with

Getting a Clean Result

Tables are less forgiving than plain paragraphs when it comes to image quality, since misaligned rows or blurry cell borders can cause the structure itself to get misread, not just individual characters. A few things help:

  1. Shoot the photo straight on, not at an angle, so rows and columns don't appear skewed
  2. Make sure all four edges of the table are visible in the frame
  3. Avoid shadows falling across part of the table, which can make rows harder to distinguish
  4. For tables with very fine print, a higher resolution photo or scan will noticeably improve results

A Quick Word on Accuracy

OCR isn't flawless, especially on dense tables, unusual formatting, or handwriting mixed in with printed text. Simple tables with a clear grid and printed text will come out close to perfect, and the Text to Columns step usually splits them cleanly. Complex or messy tables may need a bit more manual cleanup afterward. Either way, it's still dramatically faster than retyping everything from scratch.

You don't need specialized software or a data entry service to get a photographed table into a usable spreadsheet. OCR handles the tedious part, reading the text, and Excel's Text to Columns feature handles the rest, splitting it into rows and columns in a couple of clicks. For most everyday tables, invoices, price lists, schedules, that combination gets you a usable spreadsheet in a couple of minutes, not a couple of hours.