How do I get a table from a PDF into Excel?
Updated:
Convert the PDF with a tool that detects tables and writes each one to its own sheet, instead of copying and pasting: a paste puts every row into a single column. ConvCC writes one sheet per table, keeps merged header cells and stores numbers as numbers.
Why copy and paste fails
A PDF table is text drawn at positions, sometimes with lines around it. When you copy it, you get lines of text separated by spaces; Excel can't tell which space is a column boundary, so everything lands in column A.
What to check after converting
- Numbers aligned right in Excel are numbers; aligned left are text (a stray symbol stayed in).
- Multi-level headers: merged cells should span the columns they cover.
- Tables split across pages: they should be one sheet, not two.
- Footnote markers inside cells («12.4¹»): remove them before calculating.
Convert a PDF to Excel
files an hour free, short or long. No account needed.