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. Select the table (or click inside it) and copy as Markdown — the converter turns the table into structured Markdown that Excel, Sheets and Notion paste back into real rows and columns.
Install Clean Copy from the install guide (Chrome or Firefox):
cleancopy.tools/clean-copy#installDrag the PDF file into a Chrome or Firefox window,
then scroll to the table.Select the table, click the Clean Copy icon and copy as Markdown.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 — Markdown table conversion | 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
The complete guide is available as a free EPUB — no signup required.
Get the free e-book →Want all six guides? Complete EU Compliance Bundle — combined PDF + all EPUBs, $29.
Keeping websites online? DeskUptime is a free desktop uptime & SSL-expiry monitor for macOS, Linux and Windows.
Need to copy a table or code from a website — not just PDFs? Clean Copy strips formatting, scripts and junk, and outputs clean Markdown. Available as a browser extension and web tool.
Dansk version: Kopiér en tabel fra PDF til Excel
More like this: The Copy & Clean Guide Collection