Convert PDF to CSV Free
Extract tables from PDF files into CSV format for use in spreadsheets or data analysis tools. Local processing — your data never leaves your browser.
PDF to CSV conversion extracts tabular data from your PDF and outputs it as comma-separated values — the universal format accepted by Excel, Google Sheets, Python, R, SQL databases, and virtually every data tool. It works best on PDFs that were digitally created with clear table structure. Scanned PDFs require OCR first to add a text layer.
How It Works
The tool reads the text content and position data embedded in the PDF. It detects rows by grouping text elements that share the same vertical position, and detects columns by grouping elements that align vertically across multiple rows. This grid detection logic reconstructs the table structure and outputs each cell as a CSV value.
For PDFs with multiple tables on one page, the tool extracts all detected grid structures in top-to-bottom order. Some cleanup is typically needed afterward: removing header or footer text that appeared in the extraction area, fixing number formats where currency symbols were captured as text, and verifying that date columns parsed correctly.
After Extraction: Cleaning Your CSV
Remove header/footer rows. Page headers and footers often get captured as the first and last rows of each table. Delete them before importing into your data tool.
Fix number formats. Values like "$1,234.56" or "(500)" (accounting notation for negatives) are extracted as text strings. Use Excel's VALUE() function or your data tool's type-casting to convert them to numbers.
Normalise dates. Dates in different formats (01/04/26, April 1, 2026, 2026-04-01) all extract as text. Standardise them with a consistent format before analysis.
Check multi-line cells. If a table cell in the PDF wraps across two visual lines, it may appear as two separate rows in the CSV. Merge these manually or with a data transformation step.
Common Use Cases
Financial data extraction. Bank statements, transaction reports, and balance sheets exported as PDFs from accounting systems can be converted to CSV for import into Excel models or BI dashboards.
Research and academic data. Data tables published in PDF reports, government publications, or academic papers can be extracted for further statistical analysis without manual re-entry.
Database import. Structured data in PDFs can be extracted to CSV and imported directly into SQL databases or CRM systems via their CSV import features.
Competitive pricing data. Supplier and competitor price lists distributed as PDFs can be extracted, cleaned, and compared side by side in a spreadsheet.
Frequently Asked Questions
Does this work on scanned PDFs?
Scanned PDFs contain images with no text layer, so direct extraction is not possible. Use the OCR tool first to add a text layer to the scanned PDF, then upload the result here for CSV extraction.
Is my data uploaded to a server?
No. All extraction runs locally in your browser. Your PDF data — including any financial figures or business information — never leaves your device.
What if the PDF has multiple tables per page?
All tables detected on the page are extracted in top-to-bottom order. A blank row is inserted between tables to help with identification. You may need to split them into separate sheets after opening in Excel.
What encoding does the CSV use?
The output CSV uses UTF-8 encoding, which supports international characters and special symbols. When opening in Excel, use the Data → From Text/CSV import wizard and select UTF-8 encoding to ensure special characters display correctly.