Account

What new tool do you want?

PDF Tools

PDF Form Data Extractor (Filled Forms to CSV / Excel)

Drop in a stack of filled PDF forms (applications, surveys, registrations) and get one spreadsheet: one row per PDF, one column per field, as CSV, Excel or JSON.

How to use

  1. 1Drop all the filled-in PDF forms at once (they can be different versions of the form).
  2. 2Choose how ticked boxes are written, then press Extract.
  3. 3Check the preview table and download CSV, Excel or JSON.

Frequently asked questions

What kinds of fields are read?

Text boxes, check boxes, radio buttons, drop-down lists, list boxes and signature fields (shown as 'signed' when signed). Push buttons hold no data and are skipped.

The forms aren't all identical. Does that matter?

No. Columns are the union of all field names, in the order they first appear, so a field that only exists in some files is blank for the others.

Why are some files listed as having no fields?

The form was flattened (the fields were turned into plain page content), printed to PDF or scanned. There's nothing left to read except the page text; try the PDF to text or OCR tools instead.

Is it safe to open the CSV in Excel?

Yes. Values starting with =, +, @ or a minus sign followed by letters are prefixed with an apostrophe, so a malicious form entry can't run as a spreadsheet formula. Normal negative numbers are kept as they are.

Sources

Example: 40 course registration forms

A school emails out a fillable registration PDF and gets back 40 completed copies. Dropping them all here gives a table with the columns student_name, date_of_birth, course, photo_consent and so on, and one row per student with the file name in the first column. Excel opens the download directly, ready to sort or mail-merge.

Field names, not labels

Columns use the internal field names the form's author chose (like txtFirstName or Check Box 3), because that's what the PDF stores; the printed label next to a box isn't linked to it. If the names are unclear, rename the header row in your spreadsheet once and reuse it.

Related tools

More: PDF Tools