PDF to Excel builds columns from the horizontal positions of text, because the PDF holds no table structure to copy. When a page has irregular spacing, wrapped cells or centered headings, the guess can be off by a column.
The fixes are simple spreadsheet edits once you know what went wrong.
On this page
Key takeaways
- Columns are detected by matching the left edge of text, within a small tolerance.
- Right-aligned numbers and centered text can fall into the wrong column.
- Cells with wrapped lines become separate rows.
- Every PDF page is a separate sheet, so a table that spans pages is split across sheets.
Problems at a glance
| What you see | Cause | Fix in Excel |
|---|---|---|
| A value sits one column to the right | Text was right-aligned or centered | Cut and paste into the correct column |
| Extra empty columns | Slightly different left edges | Delete the empty columns |
| One row split into two | A wrapped cell in the PDF | Join them with a formula or manual edit |
| Header over the wrong column | A centered header | Move the header cell |
| Table split across sheets | Each PDF page is its own sheet | Copy the sheets into one |
| Amounts are text | Symbols and separators | Convert with Text to Columns |
How the columns are found
Text pieces that start at nearly the same horizontal position, within about 8 points, are placed in the same column. A new column is created for any piece that does not match an existing one. Numbers aligned on their right edge start at different positions depending on their length, so they can end up in neighboring columns.
Quick cleanup in Excel
- Check the first sheet against the PDF before you correct anything. Patterns repeat across pages.
- Delete empty columns by selecting them and using Delete.
- Fix right-aligned numbers by sorting out which column they belong to, then moving whole ranges at once.
- Convert text to numbers with Data, then Text to Columns, finishing without splitting. Or multiply the column by 1 in a helper column.
- Combine sheets by copying each page's rows below the previous page.
When another route is faster
- Only a few lines: copy them from the PDF viewer into Excel by hand.
- Plain list without columns: use PDF to Text and paste it.
- A scanned table: read it with Image to Text, then split the text into columns in Excel.
Simplify the PDF first
Fewer pages mean fewer sheets. Remove cover pages and notes with Remove Pages, or pull out only the table pages with Extract Pages, then convert. The overview is in how to convert PDF to Excel.
Preventing problems before converting
Use the original PDF produced by the system that created the data, rather than a copy that was printed and scanned. Remove covers and legal pages so that only table pages are converted. If a layout has complicated headers, accept that you will fix the first sheet by hand and apply the same corrections to the rest.
PDF to Excel layout problems: FAQ
Why are my PDF to Excel columns shifted?
Columns are inferred from text positions, so right-aligned or centered text can land in a neighboring column.
Why are there empty columns?
Text starting at slightly different positions creates extra columns. Delete the empty ones.
Why is one table row split into two?
A cell with wrapped text in the PDF is read as two lines.
Can the tool keep table borders?
No. It reads text only.
Why is my table on several sheets?
Each PDF page is converted to its own sheet.
How do I turn text amounts into numbers?
Use Text to Columns in Excel, or remove currency symbols and separators.
Does it work on scanned tables?
No. Read them with Image to Text first.
Can I convert only the table pages?
Yes. Extract those pages into a new PDF first.
A grid you can fix in minutes
The converter gets text into cells quickly. A short cleanup pass finishes the job.
