Why the usual methods fail
The problem is not Excel — it is the clipboard. A PDF has no real table structure to hand over.
Direct copy destroys the structure
PDF viewers render text in reading order, not table order. The result is typically every value stacked column-wise, one per line.
Screenshot + OCR = number errors
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.
⌨️ Retyping does not scale
Fine for three rows. Not fine for a 40-page annual report with twenty tables.
The method: open the PDF in your browser
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.
1. Install
Install Clean Copy from the install guide (Chrome or Firefox):
cleancopy.tools/clean-copy#install2. Open the PDF in the browser
Drag the PDF file into a Chrome or Firefox window,
then scroll to the table.3. Copy the table
Select the table, click the Clean Copy icon and copy as Markdown.4. Paste into Excel
Click cell A1 and press Ctrl+V (Cmd+V on Mac).
Every value lands in its own cell — headers included.Cells stay cells
The clipboard carries real table structure, so Excel maps each value to the right cell.
No junk included
No page headers, footer page numbers or running text — only the table you pointed at.
Works elsewhere too
The same paste works in Google Sheets, Numbers and LibreOffice Calc.
Your options compared
| 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.
Frequently asked questions
Why does copying directly from a PDF turn into a mess?
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.
Can I avoid using OCR?
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.
What about scanned PDFs?
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.
Does it work with Google Sheets too?
Yes. The clipboard contains ordinary table structure, so it pastes correctly into Google Sheets, Excel, Numbers and LibreOffice Calc.
Do my data leave the browser?
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
Free e-book: Build Your First Chrome Extension
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