PDF to CSV

Extract tables from a PDF into CSV files for free — entirely in your browser, ready to import into spreadsheets, databases and other software. Your file is never uploaded.

Open the PDF to CSV tool →

How to convert a PDF to CSV

  1. Open the tool and add your PDF — drag and drop it, or click “Add PDFs.”
  2. Review the tables LambiPdf found and choose whether the first row is a header.
  3. Download. Get one .csv, or a .zip with one CSV per table when there are several — saved straight to your Downloads folder.

Clean CSV that imports anywhere

The CSV is UTF-8 with a byte-order mark so accented characters and symbols survive, fields are quoted correctly, and any cell that starts like a spreadsheet formula is escaped to prevent CSV injection. When a PDF holds several tables you get a ZIP with one CSV each, so nothing is jammed into a single messy file.

Import into Google Sheets, Excel or a database

In Google Sheets choose File → Import → Upload and pick the CSV; in Excel use Data → From Text/CSV. For databases and accounting or budgeting tools, a plain CSV is the universal exchange format. Because the file is built on your device, sensitive rows never pass through anyone else's server.

What converts well

Worked example: prepare a CSV import you can reconcile

Use the same fictional supply order to practice extracting data for an import. Download the CSV produced by LambiPdf for comparison. The expected records are Notebook, Pen set and Desk tray, with line totals of 37.50, 9.50 and 18.00: 65.00 in total.

  1. Choose the table and conversion pages. On this sample, select the area around the header and three items to leave out the title and footer. The matching area is Left 5%, Top 14%, Width 90%, Height 17%. Review columns in the editor; viewing a PDF page alone does not restrict the export.
  2. Set the first row as a header if it contains labels. Decide whether identifiers, dates and amounts should remain text or be interpreted as values.
  3. Save and download the CSV, then use your destination application's import dialog. Inspect the delimiter, encoding, column types and first data row before accepting the import.

The downloadable example is generated from the PDF by the working converter. Check its three item rows and reconcile the line totals. Do not assume that a successful download proves that the receiving application interpreted those values correctly.

CSV is data, not a formatted workbook

A CSV holds rows and fields. It does not preserve Excel formulas, cell styling, multiple worksheet tabs or PDF page geometry. Use PDF to Excel when a workbook is the better handoff. If the PDF has several separate tables, a ZIP can keep them in separate CSV files rather than mixing unrelated headers.

Encoding, separators and spreadsheet formulas

LambiPdf writes UTF-8 with a byte-order mark to help applications recognize the encoding. Fields containing commas, quotes or line breaks must remain quoted when another program reads them. A decimal comma inside a value is not automatically a column separator; your import settings still need to match the file.

Text that begins with a spreadsheet formula marker is escaped to reduce formula-injection risk. As a result, some text-based importers may show an added leading apostrophe. Inspect those fields rather than stripping escaping blindly. The meaning of negative numeric amounts is separate from text that happens to start with a minus sign.

Troubleshoot an import before using the data

More free PDF tools

PDF to CSV — FAQ

Is the PDF to CSV converter free?

Yes — completely free, no sign-up, no watermark.

Are my files uploaded?

No. Extraction runs entirely in your browser; file contents are not uploaded for processing.

What encoding does the CSV use?

UTF-8 with a byte-order mark (BOM), with correct quoting so commas, quotes and line breaks inside cells are preserved.

What if the PDF has several tables?

You get a ZIP containing one CSV per table, so each table stays clean and separate.

Can I import it into Google Sheets?

Yes — use File → Import → Upload and select the CSV. It also imports into Excel and databases.

Does it work on scanned PDFs?

Yes. Pages with no selectable text are read with built-in OCR (45 languages) during the conversion, on your device — you don’t need to run OCR and add the file again. Check the recognized cells against the original.