OmniDocHow to Convert Image to Text in Excel
Learn how to turn a photo or scanned table into editable Excel cells, using OCR and PDF export, plus the checks that catch recognition errors.
If you have a table in a photo, a screenshot, or a scanned page, retyping it by hand is slow and easy to get wrong. Many people searching for how to image to text in excel want the same thing: the rows and columns on the page, sitting in cells they can sort, total, and edit. This guide shows how to convert image to text in Excel using OCR (optical character recognition) and the PDF export in the OmniDoc desktop client.
You will get a clear route for scanned tables, a short list of checks to run before you start, and a way to verify the result. The process has three parts: get a clean source, recognize the text, and export to Excel. Each part has a common failure point, and the checks at the end show you how to catch them.
How do you get image text into Excel cells? The short answer
Save the image as a PDF, run OCR on it in the OmniDoc desktop client, and export the recognized table to Excel. Then check every number against the original before you use the file.
| Your situation | What to do | Why |
|---|---|---|
| A photo or screenshot of a table | Save it as a PDF, run OCR, export to Excel | The PDF editor works on PDF files, so the image needs to be in that format first |
| A multi-page scanned PDF of a table | Open it in the desktop client, run OCR, export to Excel | Scanned pages have no selectable text until OCR adds a text layer |
| Running text, such as a letter or notes | Export to Word, then copy the text into Excel | Word export keeps paragraphs readable, which suits text better than a grid |
| You need the text in another language | Upload the scanned PDF on omnidoc.top for translation and choose translation-only output | Translation output keeps the layout, so the table structure carries over |
| Handwriting or a very faint copy | Rescan or retake the photo before running OCR | OCR works well on clear printed text, and poor input gives poor results |
Before you start
Check these points first. Each one prevents a problem that is hard to fix later in Excel.
- Image quality. Shoot the page flat, straight on, with even light and no shadows. A blurry or tilted photo causes misread digits, especially 1, 7, 0, and 8.
- Whether the file is already text. Open the PDF and try to select a line of text. If you can select it, the text layer already exists and OCR may not be needed. If you can't select anything, the page is probably an image.
- Which content is a table. If the data is in columns, export to Excel. If it is paragraphs, the Word route usually keeps the reading order better.
- The desktop client. OCR and Excel export are part of the desktop client for Windows, macOS, and Linux. You can download it at download.omnidoc.top.
- How precise the numbers must be. If you are copying figures for a report, budget, or invoice, plan a full comparison step. If the table is for reference only, a quick spot check may be enough.
Converting a scanned table to Excel, step by step
- Save the image as a PDF. Put your photo or screenshot in a PDF so the desktop client can open it. Use any general method you already have, such as printing to PDF from an image viewer. Keep one table per page where you can, since it makes the output easier to check.
- Open the PDF in the OmniDoc desktop client. Launch the client and open the file in the PDF editor. Confirm the page displays correctly, with the full table visible and not cut off at the edges.
- Run OCR on the scanned pages. Use the OCR option in the PDF editor to add a searchable text layer. Wait until the process finishes on every page before you move on. If a page looks wrong at this stage, rescan it instead of continuing.
- Review the recognized text. Scroll through the pages and compare the recognized text with the original image. Fix obvious typos in the PDF if the text is editable there. This step is quick and catches errors before they spread into the spreadsheet.
- Export to Excel. Use the export option in the PDF editor and choose Excel as the format. Save the file to a location you can find again, and keep the original PDF so you can compare against it.
- Open the file in Excel and reshape it. Look at column breaks, headers, and merged cells. Split or merge cells as needed, and set the number format for each column. Do this after export, because the export output is the raw material you are cleaning up.
- Recheck the numbers. Compare each figure in Excel with the original image. Only after this check should you use the totals, formulas, or charts.
Check the result
Run these checks once you have the Excel file. They take a few minutes and catch the errors that matter most.
| Check | How to see it | If it's wrong |
|---|---|---|
| Digits and symbols | Compare each value in Excel with the original, paying attention to 1, 7, 0, 8, decimal points, and minus signs | Correct the value by hand, or rescan the page at a higher clarity and run OCR again |
| Row count | Count the rows in the original and in Excel, including header rows | Look for rows that merged or split during recognition, then rebuild them by hand |
| Column alignment | Check that each value sits under the right header | Insert or delete columns in Excel, or redo the export if the layout is badly off |
| Leading zeros and dates | Look at codes like 00472 or dates like 03/04 | Format the column as text before typing or pasting the values, so Excel keeps them unchanged |
| Merged headers | Look for header cells that spanned several columns on the page | Unmerge the cells and copy the header text into each column it applies to |
OCR is a recognition step, not a guarantee. Check every figure you plan to use for decisions, totals, or payments, even if the rest of the table looks clean.
❓ FAQ
1. Can I convert a JPG or PNG straight into Excel?
The facts for the PDF editor cover PDF files, so save the image as a PDF first. That step takes a moment and gives the OCR step a page to work on. Keep the original image as a backup.
2. Why do my numbers appear as text in Excel?
Recognized values often arrive as text, which means Excel will not sum or sort them correctly. Select the column, convert the values to numbers, and check the decimal and thousands separators. If a value has a leading zero that must stay, format that column as text instead.
3. Why did OCR skip part of the page?
Usually the scan was too dark, too blurry, or cut off at an edge. Rescan or retake the image with the whole table in frame, then run OCR again on that page. Adding the fixed page to the PDF keeps the rest of your work intact.
4. Is there a free way to do this?
You can look for a few things in any free tool: file size limits, watermarks on the output, how your files are handled for privacy, and whether the table layout survives export. Check those points against your own file before you rely on any tool.
📝 Summary
To convert an image to text in Excel, save the image as a PDF, run OCR in the OmniDoc desktop client, and export the table to Excel. Clean up the layout in Excel, then compare every number against the original before you use it.
