How a PDF table gets into Excel
Copy a table out of a PDF and paste it into Excel, and the whole row lands in one cell. This tool looks at where the text sits on the page, finds the rows and columns, and puts each value in its own cell.
Numbers are written as numbers, not text, so you can total, sort and chart them. The workbook has two sheets: the whole document, and the tables only.
Nested tables, merged cells and rotated text may not come out exactly. For scanned PDFs, recognise the text with the OCR tool first.