What is form data export in a PDF?
Form data export means reading the values that people have typed or ticked in the fields of a PDF form and returning them as a list of field names and answers. Instead of opening each completed form and copying the content by hand, you obtain the information in a shape that a spreadsheet or another program can use. The form itself is not changed, and its appearance does not matter, because only the stored answers are read.
Where it helps
The need appears whenever the same form is returned by many people: a registration sheet, a survey, an application or an order form. Fifty completed forms would take an afternoon to retype, and retyping brings mistakes. With export, each form becomes one row of data, and you can sort, count and check the answers at once. It is also useful for a single form when you want to confirm what is stored in a particular field.
Things to keep in mind
Only real form fields can be read. If somebody printed the form and scanned it back, or typed over a flat page, there are no fields to export, and character recognition would be needed instead. Field names matter too: a form with clear names gives a tidy result, while a form with names such as Text1 and Text2 is harder to interpret. Look at the list of fields first and check that each answer ends up in the right column.
Using AuraDoc for it
The AuraDoc tool for form data reads the answers from a filled form, the field list tool shows the names and types of the fields, and the form flattening tool turns the answers into fixed page content when you only want to keep a final copy.
Tools that use this
Guides that put it into practice
Common questions
- Does exporting the data change the form?
- No. The PDF stays untouched and you receive the data separately, so the form can still be used or sent on.
- What if the form was printed and scanned?
- Then the answers are part of a picture, not fields, and nothing can be exported. Character recognition can read the text, but it is less precise than stored values.
- Is exporting the same as flattening?
- No. Exporting reads the answers out of the form, while flattening fixes the answers on the page so that they can no longer be edited.