Annual reports, quarterly statements, public statistics — the tables are locked inside PDFs. Select-and-copy almost always gives you one long blob of text. Here is the way around it, with every column landing where it should.
Updated August 2026 · 4 minute read
The problem is not Excel — it is the clipboard. A PDF has no real table structure to hand over.
PDF viewers render text in reading order, not table order. The result is typically every value stacked column-wise, one per line.
OCR reads pixels, and digits are exactly what it gets wrong most often. One wrong digit in a financial statement is worse than no data.
Fine for three rows. Not fine for a 40-page annual report with twenty tables.
When a PDF opens in Chrome or Firefox, the text is real text on the page — which is what the Clean Copy extension works with. It has a dedicated Copy Table mode that finds the table under your cursor and puts genuine table structure on the clipboard.
Chrome Web Store or Firefox Add-ons — search for "Clean Copy", install, done.Drag the PDF file into a Chrome or Firefox window,
then scroll to the table.Click anywhere inside the table, click the Clean Copy
icon and choose "Copy table".Click cell A1 and press Ctrl+V (Cmd+V on Mac).
Every value lands in its own cell — headers included.The clipboard carries real table structure, so Excel maps each value to the right cell.
No page headers, footer page numbers or running text — only the table you pointed at.
The same paste works in Google Sheets, Numbers and LibreOffice Calc.
| Method | Keeps structure? | Catch |
|---|---|---|
| Select + copy in the PDF viewer | Rarely | Text arrives in reading order, columns collapse |
| Screenshot + OCR | After cleanup | Number errors are hard to spot |
| Acrobat "Export to spreadsheet" | Yes | Paid subscription required; slow with many tables |
| Excel Data tab "Get Data From PDF" | Yes | Requires Microsoft 365; struggles with complex layouts |
| Clean Copy — Copy Table | Yes | Free browser extension required; PDF opened in the browser |
If you already have Microsoft 365 or Acrobat, their built-in exports can be fine for occasional large tables. For quick copies — and for free — the browser route is the simplest.
A PDF stores text as positioned blocks, not as a table. When you select and copy, you usually get each column as its own line of text — all content from row 1 first, then everything from row 2. The text has to be rebuilt into a real table before it can be pasted into Excel.
In most cases, yes. If the PDF was generated digitally (from Excel or a reporting tool), the text is already in the file. Clean Copy rebuilds the table from the page structure instead of reading pixels.
Scanned PDFs contain images rather than text, so they require OCR (Adobe Acrobat or an online OCR tool). Always check the numbers afterwards — OCR typically fails on digits.
Yes. The clipboard contains ordinary table structure, so it pastes correctly into Google Sheets, Excel, Numbers and LibreOffice Calc.
No. Clean Copy runs entirely in your browser. The table never leaves your machine until you paste it somewhere yourself.
Related: Copy a Website Table Into Excel · Table From Website to Google Sheets · Same guide in Danish
More like this: The Copy & Clean Guide Collection