Getting a table out of a PDF and into Excel
Copy a table from a PDF and paste it into Excel, and you usually get one of two disasters: everything lands in a single cell, or every word lands in its own cell on its own row. Neither is what you wanted. The fix depends on what kind of PDF you're actually holding.
1. Text-based PDFs (most reports, invoices, statements)
If you can already select individual words in the PDF viewer, the text is real — it's just that PDF has no concept of "columns." When you copy it, the columns that looked aligned on screen get flattened into lines separated by varying amounts of whitespace.
The fix: paste the raw text into Paste to Table and switch detection mode to "2+ spaces." This treats any run of two or more spaces as a column break, which is usually exactly how the PDF renderer laid things out. Click a header to sort, fix any misaligned cells by hand, then copy as Excel-ready text or download as CSV.
2. Scanned PDFs (photographed or printed-then-scanned documents)
If you can't select text in the PDF, it's an image, not text — copying does nothing. You need OCR (optical character recognition) first. Adobe Acrobat, Google Drive (open the PDF with Google Docs), and most phone scanning apps can OCR a page. Once you have real text, go back to method 1.
3. Tables Excel already understands
If a PDF was exported directly from Excel or Google Sheets originally, sometimes copying the table and pasting into Sheets with Paste special → Paste values only preserves more structure than you'd expect. Worth trying before anything else — it's free and takes five seconds.
A quick checklist
- Can you select individual words? → it's text, use the spaces-detection method above.
- Looks like a photo or scan? → OCR it first.
- Columns still misaligned after conversion? → click into any cell in the result table and edit it directly; the table is live, not read-only.