A PDF table extractor for when copy-paste breaks
Select the table, hit copy, paste into Excel — and every column collapses into one line, or the rows come out in the wrong order. That’s a PDF’s text layer not matching what you see on the page. This reads the table visually instead, the way a person would.
Last updated: September 2026
5 of 5 extractions left this month on the free plan
You can also paste with Ctrl / Cmd + V · JPG, PNG, WEBP up to 10 MB · PDF (Premium) · Select several at once (Premium)
How it works
- 1
Upload the PDF, or a screenshot of it
Premium can upload the PDF directly and pick which page has the table. On Free or Pro, screenshot the page and upload that instead.
- 2
The table is read by position, not by text order
Rows and columns are rebuilt from where things actually sit on the page — the same way you’d read it, not the way the PDF’s internal text stream happens to be ordered.
- 3
Review and export
Fix any misread cell, then download a genuine .xlsx workbook or .csv.
Copy-paste vs. reading the table visually
This is the actual failure mode worth understanding, not just working around.
| Select & copy from the PDF | ShotToSheet | |
|---|---|---|
| Columns stay separated | Often collapses into one line | Rebuilt as real columns |
| Row order matches what you see | Not guaranteed — follows the PDF’s internal text order | Follows visual position on the page |
| Works on a scanned PDF (no real text layer) | No — nothing to select | Yes, read the same as a photo |
| Result is ready to paste into Excel | Needs manual cleanup, often row by row | Yes, direct export |
Why this happens
A PDF doesn’t actually store a grid — the visual alignment you see is a rendering result, but the underlying text is stored as a sequence of positioned fragments. A simple copy-paste follows that internal sequence, not the visual layout, which is exactly why multi-column tables, especially ones with merged cells or unusual spacing, come out scrambled. Reading the page as an image sidesteps the problem entirely by working from what you actually see.
Frequently asked
The PDF’s internal text order doesn’t always match its visual layout — a copy-paste follows that internal order, collapsing separate columns into one run of text.
Yes — a scanned PDF is read the same way as a phone photo, since there’s no real text layer to rely on either way.
Yes — Premium’s page picker lets you choose exactly which page to convert, instead of guessing or converting the whole file.
The page itself, rendered as an image — that’s what makes it immune to the text-order problem that breaks copy-paste.
Multiple tables are detected separately — you’ll be asked which one to convert if more than one is found.
Related
PDF to Excel
The core PDF converter, including multi-page and scanned-PDF handling.
PDF to Google Sheets
Send the extracted table straight to a new Google Sheet.
Table Image to Excel
For images with multiple or structurally complex tables.
Excel Get Data From PDF Alternative
How this compares to Excel’s own PDF import feature.
Pricing
Free tier, plus Pro and Premium for direct PDF upload.