OmniDocScanned PDF Tables to Excel: OCR First, Then Export
Scanned PDF tables have no text to copy, so run OCR first, then export to Excel. Steps and checks for clean rows and numbers.
You open a scanned PDF, try to select a table so you can paste it into a spreadsheet, and nothing highlights. The table is a picture of a table. Excel cannot read the cells until the text is there, so a direct export produces an empty file or a single column of garbage.
If you need to know how to extract a table from a PDF to Excel when the file is a scan, the fix is a fixed order: run OCR first, then export. OCR reads the characters in the image and adds a text layer, and the export step can then place each value in a cell. This article covers that order, the checks to run before and after, and what to do when a few cells come out wrong.
How do you get a table from a scanned PDF into Excel? The short answer
Run OCR on the scanned pages so the text becomes selectable, then export the PDF to Excel from the OmniDoc desktop client and check the result against the original.
| Your situation | What to do | Why |
|---|---|---|
| You can select the table's text normally | Skip OCR and export directly | The PDF already has a text layer |
| The table is an image you cannot select | Run OCR first, then export | The export needs text to place in cells |
| Only one page holds the table | Run OCR on that page only | Long scans take longer to process |
| You need Word instead of Excel | Run the same OCR, then export to Word | The OCR step is identical for both formats |
| Every figure must match the source | Export, then compare each number with the scan | OCR can misread blurry or small digits |
Before you start
- Use the desktop client. OCR and PDF-to-Excel export are part of the desktop client's PDF editor. Download it from download.omnidoc.top for Windows, macOS or Linux.
- Keep the original scan. OCR adds a text layer to the file you run it on. Save a copy first so you can go back to the untouched scan if something goes wrong.
- Look at the scan quality. Straight, sharp pages with strong contrast give OCR a good starting point. Skewed, faded or photographed pages often produce more errors in the digits.
- Decide which pages you need. If the table sits on pages 12 to 14 of a 40-page report, OCR only those pages. You will finish sooner and have fewer pages to check.
- Have the original open beside the output. You will compare numbers, headers and row order, and that is much faster with both on screen.
Extracting a table from a scanned PDF to Excel, step by step
- Check whether the PDF has a text layer. Try to select one line of text in the table with your cursor. If the line highlights and you can copy it, OCR is optional. If nothing highlights, the table is an image and you need OCR.
- Open the PDF in the OmniDoc desktop client. Use the PDF editor and load the scanned file you saved a copy of.
- Run OCR on the table pages. Apply OCR to the scanned pages. This adds a text layer that Excel export can read. Pages without the table can be left out if you only need one section.
- Test the text layer on one cell. Select a single number or word from the table. If it highlights as text, the OCR worked for that area. If it does not, run OCR again on that page before you export.
- Export the PDF to Excel. Use the export option in the PDF editor and choose Excel as the output format. Save the .xlsx file to a folder you can find again.
- Compare the spreadsheet with the scan. Open the file in Excel and go row by row against the original. Confirm that the number of rows and columns matches the table in the scan.
- Fix the remaining cells in Excel. Correct any misread digits, split or merged headers, and stray characters directly in the spreadsheet. Fixing cells in Excel is usually quicker than running OCR again with different settings.
- Save the corrected workbook. Keep the scan and the .xlsx file together, so anyone who checks the numbers later can trace them back to the source.
Check the result
Run these checks once the Excel file is open. Work through them in order, because a row-count problem will affect every check after it.
| Check | How to see it | If it's wrong |
|---|---|---|
| Row and column count | Count the rows and columns in the scan and in Excel | Go back and run OCR on the page again, then re-export |
| Numbers and decimal points | Compare each figure with the scan, starting with totals | Correct the cell by hand in Excel |
| Headers and labels | Read the header row against the scan | Rename the header cells and check that data still lines up under them |
| Row order | Pick three rows at random and match them to the scan | If rows are shuffled, re-export from a cleaner OCR pass |
| Text in blurry cells | Look for symbols like stray punctuation or letters where digits belong | Retype the value from the scan and mark it for a second review |
| Formulas that depend on the table | Recalculate any totals and compare with the printed totals | Fix the source value first, then check the formula results |
OCR output may contain errors, so treat the spreadsheet as a draft until you have checked every figure that matters, especially in financial, medical or legal tables.
❓ FAQ
1. Can I export a scanned PDF to Word instead of Excel?
Yes. Run OCR on the scanned pages first, then choose Word as the output in the PDF editor. Word suits tables that hold mainly prose, while Excel suits tables with numbers you want to sum or sort.
2. Why does my exported table come out as one column?
A common cause is that the PDF has no text layer and the export read it as a single block. Test a line of text, run OCR on the table pages, and export again. If the table still collapses, the scan may be too skewed or low-contrast for reliable OCR.
3. Can I extract a table from a scanned PDF without installing anything?
Online converters can handle simple scans, but check how they treat your file before you upload anything sensitive. Look at file size limits, whether the output keeps the table layout, and whether the service states what happens to uploaded files. For tables with many columns, the desktop client gives you the OCR and Excel export steps described above.
4. Is OCR accurate enough for tables with financial figures?
OCR can misread digits, especially on small print or faded pages. Compare every total and key figure with the original scan before you use the spreadsheet. A quick check of row totals against the printed totals will catch the errors that matter most.
📝 Summary
A scanned PDF table only becomes usable in Excel after OCR adds a text layer, so run OCR first and export second. Check the row count, the numbers and the headers against the original, and fix blurry cells in the spreadsheet before you rely on the data.
