Extract Form Data
Open the app: Extract form data → (products.documentize.app)
In one sentence
Extract Form Data reads the fields and values of a filled-in PDF form (text boxes, checkboxes, radio buttons, drop-downs) and gives them to you as CSV spreadsheets.
What makes it unique
- It reads the form's real fields, with their names, instead of guessing from how the page looks. You get "Surname = Smith", not a block of text.
- It writes CSV, ready for Excel or any database import, and can process many forms at once, which is what you need to collect answers from a stack of returned forms.
- Compared with Parser, which also exports a form file (
formdata.xfdf) inside a bigger ZIP, this app produces the spreadsheet-friendly CSV and summaries. - Compared with Extract Text: text extraction would give you the labels and the typed answers mixed into running text, with no link between a label and its value.
When to use it / when not to
- Use it for surveys, applications, registration or order forms filled in as PDFs and returned to you.
- Do not use it on scanned or printed-and-filled forms; there are no fields to read. The site's FAQ says such forms may need OCR first and that extraction "works best with fillable PDF forms that contain actual form fields". Use Searchable, then Extract Text.
- Do not use it on a flattened form: flattening turns fields into static content, and the fields come back empty. Keep a copy before using Flatten.
Before you start
- The PDF must be an interactive (fillable) form that has been filled in. An empty form returns empty values.
- Unlock it if it is password-protected (Unlock).
- Make sure the forms you upload together are the same template, otherwise their columns will not line up.
Step by step
- Open Extract Form Data and upload one or more filled PDF forms ("Upload a PDF form to extract data").
- Press Extract.
- Download the result (a ZIP when there are several files) and open the CSV in a spreadsheet. Extract again starts over.
📷 Screenshot placeholder: the result ZIP content
Options explained
| Option | What it does | Default | Recommended |
|---|---|---|---|
| (none) | The app has no settings; each form is exported with a comma-separated layout and a header row | - | - |
What you get
- For each PDF, a CSV with the same name (field names in the header row and the values below).
- form_data_summary.csv: a readable report per file (status, number of fields and rows, the field list and a sample of the first values).
- form_data_export.csv: a simple overview of the successful files, one line per item, using a semicolon between name and value.
- A form that cannot be read is marked as failed in the summary, and the others continue.
- The original PDFs are not modified.
Quality & limits
- Values come exactly as typed into the fields: nothing is recognized or guessed.
- Empty fields appear empty, which is usually correct (not filled) or means the form was flattened or built from plain text instead of real fields.
- The site's FAQ lists text fields, checkboxes, radio buttons and drop-downs; signatures and unusual widgets may not give useful values (verify with your own form).
- Results are kept for about two days.
Works well with
- Use before: Unlock, Splitter if a returned file contains several forms, Searchable for scanned forms (then read the text instead).
- Use after: open the CSV in a spreadsheet; keep a clean copy of the form with Flatten for the archive.
- Recipes: Fillable form, To spreadsheet.
Common mistakes & fixes
- "The CSV has headers but no values" → the form was not filled in, or it was flattened.
- "Nothing was found" → it is a scan, or the "form" is a normal PDF with lines drawn on it.
- "Columns do not line up between files" → the forms come from different templates; process each template separately.
- "Odd characters in Excel" → the CSV is UTF-8; import it with that encoding.
Same thing elsewhere
- CLI plugin: Documentize.ExtractFormData (it describes reading AcroForm and XFA field data).
- MCP tool: ExtractFormData.
- See Beyond the browser.
Try it
Open a fillable PDF form in your viewer, type a name, tick a box, choose a drop-down value, and save it under a new name. Upload it here and open the CSV: you should see a header with the field names and your answers underneath. Then flatten the form with Flatten and extract again to see why order matters.