OmniDocTable Split Across PDF Pages? Rejoin Rows in Excel
Fix a PDF table that runs across several pages in Excel by removing repeated headers, rejoining split rows, and checking totals against the source.
A table that runs across several PDF pages is a frustrating thing to bring into a spreadsheet. You export the file, open it in Excel, and find the same header row repeated every few rows, a single record cut in half at a page break, and a total that appears in the middle of the data. Sorting and summing then give you wrong answers, and you may not notice until a report is already wrong.
This guide is for anyone who needs the table as usable spreadsheet data: analysts, students pulling figures from a report, or office staff working with invoices or price lists. It shows how to tell which problem you have, how to clean up each one, and how to confirm the result matches the original.
The core method is simple: get the text out of the PDF, delete the repeated headers, rejoin the split rows, and then check the totals against the source pages. The steps below walk through each part.
How do you extract a table from a PDF in Excel when it spans pages? The short answer
Export the PDF to an Excel file, remove the repeated header rows, rejoin the rows that were split at page breaks, and then check the row count and totals against the original pages.
| Your situation | What to do | Why |
|---|---|---|
| The PDF is digital and you can select its text | Export it to Excel, then clean up page breaks | The text is already there, so you only fix structure |
| The pages are scanned images | Run OCR in the PDF editor, then export | Excel cannot read text that is only a picture |
| The header repeats on every page | Delete all copies except one | Duplicate headers break sorting, filtering and totals |
| A row is split across two pages | Join the fragments into one row | Each record should appear once with all its values |
| The table has merged or irregular columns | Check the column count on each page before joining | Mismatched columns push values into the wrong fields |
Figure out which problem you have
Multi-page tables usually show one or more of the symptoms below. Check the sheet against the PDF before you start editing, so you fix the right thing.
| Symptom | Likely cause | How to confirm |
|---|---|---|
| The same header row appears every few rows | The table repeats its header at the top of each page | Scroll to each page boundary in the sheet and compare it with the page top in the PDF |
| A row's text is cut off, and the rest sits in the next row with blank cells | The row crosses a page break | Look at the bottom of one PDF page and the top of the next, and find the same record |
| A total or subtotal appears in the middle of the data | Each page has its own subtotal, or the total row falls at a break | Check the page footer in the PDF for a running total |
| Values shift one column to the right after a certain page | Column boundaries were read differently, or merged cells are present | Count the columns on a page before and after the shift |
| The sheet holds one long text column, or nothing useful | The PDF is scanned and has no text layer | Try selecting a line of text in the PDF; if it will not highlight, the page is an image |
| Numbers will not add up in a sum formula | Numbers were exported as text | Check whether the cells are left-aligned or show a small warning marker |
Fix it step by step
- Check whether the text is selectable. Open the PDF and try to highlight a line in the table. If you can, the export will carry the text across. If you cannot, the pages are scanned, so run OCR in the PDF editor in the OmniDoc desktop client first. Download it from download.omnidoc.top if you do not have it yet. Check the recognized text against the page, because OCR can misread digits and punctuation.
- Export the PDF to Excel. Use the PDF editor's Excel export to create the spreadsheet. Save the output as a separate working copy, and keep the original PDF untouched so you can compare against it later.
- Remove the repeated headers. Filter the first column by the header text, or sort so the header rows group together. Keep one header at the top and delete the rest. Then clear the filter and confirm the data rows are continuous.
- Find the split rows. A common sign of a broken row is a row where the ID or date column is blank, but the description or amount columns hold text. Filter for blanks in the key column to list these fragments quickly.
- Rejoin each fragment. Working from the bottom up, add the fragment's text to the row above it. In a helper column, a formula such as joining the two cells with a space gives the combined text. Copy the result, paste it as values over the original cell, and then delete the fragment row. Work upward so row numbers above your current position do not shift while you edit.
- Fix the number formats. Select the amount and quantity columns and convert text that looks like numbers into real numbers. Then add a temporary sum formula to a column. If it returns zero or an error, some cells still hold text. Remove the temporary formula when you are done.
- Match the result to the PDF. Count the data rows per page in the PDF and compare them with your sheet. Check every page total or the grand total against the sum in Excel. If anything differs, go back to the page boundary where the gap starts.
- Save the workbook. Save the cleaned version as an Excel workbook, and note the source page range in a comment or a cell at the top so anyone using the file can trace it back.
If the cleaned table needs to be read in another language, you can upload the .xlsx file to OmniDoc for translation. Choose translation only or bilingual output, then review the translated cells for terminology before use, because machine translation can misread technical terms.
Prevent it next time
- Ask for the source spreadsheet when one exists. A table exported from its original workbook avoids page breaks entirely. Requesting it up front is often faster than cleaning a PDF.
- Check for selectable text before you export. A quick highlight test tells you whether to run OCR, which saves a round of confusion about empty columns.
- Record the column count on the first page. If later pages have a different number of columns, you know a shift has happened before you sort anything.
- Compare totals early. Add a sum check as soon as the data is in, not after you finish editing. It catches a missing or doubled row while the cause is still easy to find.
- Keep the original PDF next to the workbook. Notes on which page each block came from make later audits much quicker.
❓ FAQ
1. Do I need OCR if the PDF table looks clear on screen?
Not always. A table can look sharp and still be an image. Try highlighting a line of text in the table. If the highlight works, the text layer exists and you can skip OCR.
2. Why does my Excel sheet show blank rows between data rows?
Blank rows usually come from the page break itself, such as a footer or a spacer line in the PDF. Delete any row where every cell is empty, then recheck the row count against the PDF.
3. Will merged cells in the PDF survive the export?
It depends on the PDF. Merged header cells often export as a single value in the first column and blanks elsewhere. Unmerge them in Excel and fill the values down, then check that each column still means the same thing on every page.
4. Can I skip the cleanup if I only need a few columns?
You can copy only the columns you need, but you still need to remove repeated headers and rejoin split rows in those columns. Otherwise, a single broken row can still throw off your totals.
📝 Summary
A table that spans PDF pages becomes usable in Excel once you remove the repeated headers, rejoin the rows that were split at page breaks, and check the totals against the source. Start by confirming the text is selectable, then compare your final sheet with the PDF before you rely on it.
