How to Convert a PDF to CSV for Free: Tables to Spreadsheet Data

Quick summary: To convert a PDF to CSV for free, open the PDF, select and copy the table, then paste it into Google Sheets — Sheets usually splits the pasted text into columns automatically. Clean up any misaligned rows, then File → Download → Comma Separated Values (.csv). For scanned or complex tables, a free online PDF-to-CSV converter can extract the data directly.

A CSV file stores table data as plain, comma-separated rows — the format almost every spreadsheet, database, and data tool can import. Converting a PDF table to CSV lets you sort, filter, and analyze data that was locked inside a fixed PDF layout. You can also upload the PDF to our free AI PDF reader to ask questions about the data before extracting it.

How to convert a PDF table to CSV with Google Sheets (free, no install)

This is the most reliable free method for text-based PDFs with a simple table:

1. Open the PDF and select the table (click and drag over the rows and columns you need).
2. Copy it (Cmd+C / Ctrl+C).
3. Open a new Google Sheets spreadsheet.
4. Click cell A1 and paste (Cmd+V / Ctrl+V).
5. Google Sheets usually splits the data into separate columns automatically. If it pastes as one column, select the column → Data → Split text to columns → choose the delimiter (usually space or tab).
6. Check each row for misalignment — PDF tables sometimes shift columns when spacing is irregular. Fix any rows manually.
7. Go to File → Download → Comma Separated Values (.csv).

How to convert a PDF table to CSV with Microsoft Excel

1. Open Excel.
2. Go to Data → Get Data → From File → From PDF (Excel 2021, Microsoft 365).
3. Select your PDF file.
4. The Navigator pane shows detected tables — click one to preview it.
5. Click Load to import it directly into a worksheet, or Transform Data to clean it up first (remove blank rows, fix headers).
6. Once the table looks correct, go to File → Save As → choose CSV (Comma delimited) (*.csv).

This built-in “From PDF” import (available in Excel 2021 and Microsoft 365) reads table structure automatically — it works well for PDFs with clean, gridded tables and less well for tables without visible borders.

How to convert a PDF to CSV online (free, no install)

For PDFs with many tables or when you don’t have Excel/Sheets handy:

1. Search for a free “PDF to CSV” or “PDF to Excel” online converter.
2. Upload the PDF.
3. The tool detects tables automatically and lets you preview the extracted data.
4. Download the result as .csv (or .xlsx, then re-save as CSV).

Privacy note: Online converters upload your file to a remote server. For financial statements, medical records, or other sensitive data, use the Google Sheets or Excel method locally instead.

How to convert a scanned PDF table to CSV

Scanned PDFs have no selectable text — you cannot copy-paste the table directly. Run OCR first:

1. See how to OCR a PDF for free to make the scanned PDF searchable and selectable.
2. Once OCR’d, select and copy the table as described above.

OCR accuracy for tables depends heavily on scan quality — check every row carefully after extraction, since OCR sometimes merges or drops columns in tight table layouts.

How to convert a PDF to CSV using Python (for large or repeated files)

If you regularly convert similar PDFs, a script saves time. The free, open-source pdfplumber library extracts tables directly:

import pdfplumber
import csv

with pdfplumber.open("input.pdf") as pdf:
    for i, page in enumerate(pdf.pages):
        table = page.extract_table()
        if table:
            with open(f"output_page{i+1}.csv", "w", newline="") as f:
                writer = csv.writer(f)
                writer.writerows(table)

Install it with pip install pdfplumber. This approach handles multi-page PDFs and repeatable table layouts far faster than manual copy-paste.

Common problems when converting PDF tables to CSV

Problem	Fix
Columns merge into one	Use “Split text to columns” in Sheets/Excel, or try a dedicated PDF-to-CSV tool
Numbers lose leading zeros	Format the CSV column as Text before pasting numeric codes (ZIP codes, IDs)
Table spans multiple pages	Extract each page separately, then stack the CSV rows together
Headers repeat on every page	Delete the duplicate header rows after combining pages
Table has merged/spanning cells	Manual cleanup is usually required — automated tools often misalign these

Frequently Asked Questions (FAQ)

Can I convert a PDF to CSV without any table structure (just text)?

Yes, but the result needs manual cleanup — see PDF to text: extract text from any PDF for free to pull out the raw text first, then manually organize it into columns in a spreadsheet.

Why does my CSV have extra blank rows after converting?

PDF tables often contain empty cells or subtotal rows that get imported as blank lines. Open the CSV in a spreadsheet and use Data → Sort/Filter or a Find & Replace to remove empty rows quickly.

Does converting to CSV keep the formulas from an Excel-based PDF?

No — CSV stores only values, never formulas. If the original PDF was exported from a spreadsheet with formulas, only the calculated results carry over.

Can I convert a CSV back to PDF?

Yes — open the CSV in Excel or Google Sheets, format it as a table, then use File → Print → Save as PDF, or File → Download → PDF in Google Sheets.

What’s the difference between CSV and Excel (XLSX) when exporting from a PDF?

CSV is plain text with commas separating values — smaller, universally compatible, but no formatting, formulas, or multiple sheets. XLSX keeps formatting, multiple tabs, and formulas. Use CSV for importing into databases or other software; use XLSX if you want to keep working in Excel with formatting intact.

Related guides

• How to copy text from a PDF for free — copy specific sections of a PDF
• How to convert a PDF to Google Doc for free — convert the whole document to an editable format
• How to convert a PDF to PowerPoint for free — turn PDF content into slides instead of spreadsheet rows