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.
How to convert a PDF to CSV
- Open the tool and add your PDF — drag and drop it, or click “Add PDFs.”
- Review the tables LambiPdf found and choose whether the first row is a header.
- 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
- Text PDFs with tables convert directly.
- Scanned PDFs are read with built-in OCR in the same step — check the recognized cells.
- Going the other way? Turn a CSV back into a document with the free CSV to PDF converter.
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.
- 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.
- 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.
- 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
- Everything appears in one column: use an import dialog and select the delimiter instead of relying on double-click defaults.
- Codes lose leading zeros: import that column as text. Numeric display formatting does not restore a code after it has changed.
- The first item is missing: check whether a data row was incorrectly treated as the header.
- Extra rows or tables appear: restrict the conversion range or select the table region, then compare the exported record count with the PDF.
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.