OmniDocFix PDF to Excel Formatting Issues After Conversion
Find out why a PDF converted to Excel has shifted columns, merged cells, or broken text, then fix it in Excel or re-export it correctly.
You exported a PDF to Excel and the result looks wrong. Columns are shifted by a cell on some rows, headers are merged across the wrong columns, numbers sit left-aligned as text, and some words are cut in half. If you searched for pdf to excel not formatting correctly, you are probably at the point where you need to know whether to fix the spreadsheet or go back to the PDF.
This guide helps you find the cause first, then fix it. You will learn how to tell a scanned page from a digital one, which symptoms point to which problem, and which repairs you can make in Excel. For the stubborn cases, you will also see when re-exporting from a cleaned PDF works better than editing the sheet.
Converting a PDF to a spreadsheet is a guess about structure. A PDF stores text and lines as positioned marks on a page, not as rows and cells, so the converter has to infer the table. When that inference is off, the errors show up in predictable patterns. Recognizing the pattern tells you which fix to try.
Why do PDF to Excel formatting issues happen? The short answer
Usually the problem starts in the PDF, not in Excel. Identify the cause first, then choose a repair that addresses it.
| Your situation | What to do | Why |
|---|---|---|
| The page is an image, and you cannot select its text | Run OCR on the file in the OmniDoc PDF editor, then export again | An image has no text layer for the export to read |
| Rows are shifted or merged in a table with no grid lines | Fix the affected columns in Excel, or re-export a cleaned copy | Without lines, the converter guesses cell boundaries from spacing |
| Only a few cells are wrong | Correct them by hand after checking the source | Small errors are faster to fix directly than to re-process |
| Most rows are wrong in the same way | Clean the PDF pages, then export only those pages again | One source problem repeats across the whole table |
| The table shares a page with paragraphs | Split out the table pages before exporting | Body text mixed into the grid confuses the column layout |
Figure out which problem you have
Match what you see in the spreadsheet against this table. Each symptom has a likely cause and a quick test to confirm it. Do the tests before you change anything.
| Symptom | Likely cause | How to confirm |
|---|---|---|
| No text appears in the cells, or the content is garbled | The PDF is scanned, so the page is only an image | Click into the page text and try to select a line. If nothing highlights, the page is an image. |
| Values slide one or two columns to the right on some rows | Uneven spacing or wrapped cells in the source table | Compare one shifted row in the PDF with the same row in Excel. |
| Merged cells appear where the PDF has none | A header in the PDF spans several columns | Look at the header row in the PDF. If one label covers several columns, the merge is inherited. |
| Numbers are left-aligned and totals show zero | Numbers were stored as text | Select the column and check whether a sum returns zero. |
| A word is split between two cells | A line break in the PDF was read as a column break | Zoom in on the PDF and check whether the word breaks at the end of a line. |
| Accented letters or symbols appear as odd characters | The font or text layer was read incorrectly | Search the PDF for the same word. If the search fails, the text layer is damaged, so re-run OCR. |
Fix it step by step
Work from the easiest fix to the hardest. Keep the original PDF untouched, and save each change as a new Excel file so you can go back if a step makes things worse.
- Save a working copy. Keep the original PDF and the first export. Make all edits in a new file so you can compare against the original at any point.
- Open the PDF and the spreadsheet side by side. Find the first row where the layout breaks. Fixing the first broken row often shows you the pattern for the rest.
- Convert text numbers to values. Select the affected column and use Excel's option for converting text to numbers. Check a total before and after. If the total was zero before, the fix worked.
- Split text that landed in one cell. Insert empty columns to the right of the affected column first, so nothing gets overwritten. Then use Excel's text-to-columns tool with the separator that matches the source, such as a space or a tab.
- Unmerge header cells and fill them down. Unmerge the cells, then copy each header label into the blank cells below or beside it. Merged headers are the main reason sorting and filtering fail.
- Repair isolated shifted rows. For a few rows, move the values back by hand. If you have to repair more than a handful of rows this way, stop and go to the next step.
- Run OCR if the PDF is scanned. Open the file in the OmniDoc desktop client (download at https://download.omnidoc.top). Use its PDF editor to run OCR on the scanned pages, then export to Excel again. OCR can misread characters, so check every number against the page.
- Re-export from a cleaned PDF. Use the PDF editor's page operations to split out only the table pages, or delete the pages with paragraphs that sit inside the grid. Export that file to Excel and review the result against the original.
After any step, check at least one total or count against the source. Formatting problems often hide wrong values, and those are harder to spot than a misaligned column.
Prevent it next time
Most of the errors above can be avoided with a few habits before you export.
- Check whether the PDF has selectable text before you start. If it does not, run OCR first.
- Test one page before you convert a 30-page report. If the first page is clean, the rest is more likely to be clean.
- Remove body text from table pages when you can, so the converter only sees the grid.
- Avoid merged cells in data areas. Merge only in titles, and keep data columns one value per cell.
- Check totals against the source every time, not just the layout. A wrong number with clean formatting is still a wrong result.
❓ FAQ
1. Will OCR make the Excel file match the PDF exactly?
No. OCR reads characters from an image, so it can misread letters or digits, and it cannot always rebuild a table's grid. Check the numbers and the table structure against the original page after every export.
2. Should I fix the spreadsheet or re-export the PDF?
Fix the spreadsheet when only a few cells are wrong. Re-export when the same error repeats across many rows, because a single source problem will keep producing it.
3. What if a table continues across several PDF pages?
Export the pages together if the column layout is identical, then check the rows where one page ends and the next begins. A header row repeated at the top of each page may need to be deleted from the spreadsheet.
📝 Summary
Most PDF to Excel formatting issues start with the source: a scanned page, uneven spacing, or body text mixed into the table. Identify the cause with the symptom table, repair the spreadsheet for small errors, and clean the PDF and export again when the problem repeats. Always check totals against the original to confirm the fix.
