The PDF to CSV Workflow: From Document to Spreadsheet
To turn a PDF into a CSV, work in five steps: confirm the PDF has real (not scanned) text, extract the table to CSV, clean up merged or wrapped rows, keep only the columns you need, and verify the row count. Treating it as a short workflow — rather than one magic button — is what produces a clean spreadsheet. Here’s the whole path, and how to do each step in your browser without uploading the file.
This guide walks the PDF-to-CSV workflow end to end, using the PDF table extractor and the CSV column extractor.
Step 1 — Check what kind of PDF you have
Try to select a word in the table. If you can highlight it, the PDF has a real text layer and will extract cleanly. If selection grabs the whole page as an image, it’s a scan — run it through OCR first to create text, then continue. (More on this in scanned vs searchable PDF.)
Step 2 — Extract the table to CSV
Open the file in the PDF table extractor. It reads the text positions on the page, infers the rows and columns, and produces CSV — all in your browser, so the document never leaves your device. If the page has several tables, extract them one at a time so the column detection isn’t juggling two grids.
Step 3 — Clean the rough edges
Extraction gets you most of the way; a few cells usually need a hand. Open the CSV and look for the common artefacts:
- A cell split across two rows — its text wrapped in the PDF. Rejoin the two lines.
- Blank cells beside a spanning heading — fill or delete as appropriate.
- A shifted column where spacing was ambiguous — nudge the values into place.
Why this happens (and how to minimise it) is covered in PDF table extraction accuracy.
Step 4 — Keep only the columns you need
PDF tables are often wider than what you actually want. Rather than deleting columns by hand, pass the CSV through the CSV column extractor, tick the columns you need, and export a tidy file. This is also where you fix the separator if a value contained a comma.
Step 5 — Verify before you use it
Two quick checks catch most problems: does the row count match the source table (no rows lost or doubled from wrapping)? And do a few spot-checked values match the PDF exactly? Thirty seconds here saves a bad import later.
The workflow at a glance
| Step | Tool |
|---|---|
| 1. Check PDF type (text vs scan) | select-a-word test; OCR if scanned |
| 2. Extract table to CSV | PDF table extractor |
| 3. Clean merged/wrapped rows | spreadsheet |
| 4. Keep the columns you need | CSV column extractor |
| 5. Verify row count and values | spreadsheet |
Frequently asked questions
How do I convert a PDF table to CSV?
Confirm the PDF has selectable text, extract the table with a PDF table extractor, clean any merged or wrapped rows in a spreadsheet, then keep the columns you need. Run scans through OCR first.
Can I convert a scanned PDF to CSV?
Yes, but you must OCR it first to create a text layer, since a scan has no text to extract. Accuracy then depends on the scan quality.
Why does my CSV have extra rows?
Usually because cells whose text wrapped onto two lines were read as separate rows. Rejoin them, then re-check the row count against the source.
Do I need to upload my PDF to convert it?
No. Browser-based tools like the PDF table extractor read the file on your own device and never transmit it.
How do I keep only some columns from the table?
Pass the extracted CSV through a CSV column extractor and select just the columns you want.
Related reading
Last updated: 16 August 2026.