Skip to content
Answer

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.

Convert a file free

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.

Size and page limits per plan

FAQ

How do I get a table from a PDF into Excel?

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.

Every tool

Every tool uses the same engine, and every one is free every day.

See all tools

Feedback