PDFs aren't built for editing, so copy-pasting a table usually mangles the columns. The reliable path is to let AI read the page structure and rebuild the table — or, for a born-digital PDF, use Excel's own Get Data importer. Either way you end up with real cells you can sort, filter, and add formulas to.
Do it with AI insteadUpload the PDF to AI
Drop the PDF into ExcelGPT and ask it to extract the table. AI handles merged cells, multi-column layouts, and headers that span pages.
Check the column mapping
Confirm each column landed where you expect, and that numbers came through as numbers, not text.
Or use Excel Get Data
For a digital (non-scanned) PDF: Data ▸ Get Data ▸ From File ▸ From PDF, then pick the detected table.
Clean and export
Trim stray spaces, fix any split rows, then save as .xlsx.
Scanned PDFs are images, so you need OCR. Upload it to an AI extractor like ExcelGPT, which reads the text and rebuilds the table — Excel's built-in PDF import only works on digital PDFs.
PDF text has no real column structure, so a plain copy collapses it. AI extraction or Excel's PDF importer reconstructs the grid instead.