Why PDF tables break in Excel, and how to fix them
If you've pasted a PDF into Excel and ended up with text piled into one cell, or numbers that won't sum, this guide explains why and what to do.
1. Why it breaks: a PDF has no "table"
An Excel file knows "row 3, column 2 holds 1,200". A PDF usually only stores:
- "draw this text at this position (x, y) in this font"
- "draw a line at this position"
What looks like a table is just text and lines placed at coordinates. A program has to guess where the cells are. When the guess is off, the table breaks.
2. Five common problems and likely causes
| Symptom | Likely cause |
|---|---|
| Several words land in one cell | Columns are close together or have no lines, so two cells read as one |
| One cell's text splits across rows | Wrapped text inside a cell is read as separate lines |
| A merged heading disappears or sits in one cell only | The PDF stores no merge information, only lines and text positions |
| Numbers won't sum | Formats like 1,200, (300), 12.5% are imported as text |
| Repeated header rows appear mid-table | The same header is printed on every page |
3. What to do, easiest first
- Ask for the original file. If the sender can give you the spreadsheet, that is the most reliable fix — the structure is intact.
- Make sure it is a text PDF. Scanned pages store text as a picture, so no tool can read the table. → How to tell a scanned PDF from a text PDF
- Set the converter options. For a table running over several pages, choose "Combine into one sheet" (repeated headers and page numbers are removed). Use "Values only" if you will sort or filter, "Keep original formatting" if you want it to look like the PDF. Check the preview first.
- Check number cells. A green triangle in a cell's corner means Excel sees text. → Fix numbers stored as text
- Check the totals. → How to check a converted table
4. How this converter handles it
TableIntact reads text coordinates and table lines (horizontal/vertical lines and rectangles). For tables with lines it finds the grid and merged cells; for tables without lines it splits columns by text spacing. Numbers with separators, parentheses and percent signs are turned into real numbers.
There are limits: tables without lines and with uneven spacing can shift columns, which is why the converter asks you to check the preview.
Your PDF files and results are not uploaded to a server. This site collects visit information (such as cookies) for advertising and statistics.
Open the converter · Related: Moving PDF tables into older Excel · How to check a converted table
Last updated: