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

Source: https://convcc.com/answers/pdf-table-to-excel/ (updated 2026-11-17)

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.
