Form data or tables: two ways to get data out of a PDF
Both tools turn a PDF into data you can open in a spreadsheet, but they read different things. A fillable form stores each answer in a named field, so extraction can read those values directly. A table in a report or an invoice is just text and lines positioned on the page, so extraction has to find the rows and columns. Knowing which kind of PDF you hold decides the tool.
At a glance
| Aspect | Form data | Tables |
|---|---|---|
| What it reads | The values typed into the fields of a fillable PDF. | The rows and columns of tables found on the pages. |
| Output | JSON or CSV. | A CSV file that opens in any spreadsheet. |
| Source of the data | Named form fields, with a value for each one. | Text and lines positioned on the page. |
| Accuracy | Exact: the value is stored, not guessed. | Depends on how clearly the table is laid out. |
| Works on a flat PDF | No. The file needs real form fields. | Yes, as long as the page has a recognizable table. |
| Typical use | Collecting answers from many filled-in forms. | Moving figures from a report or statement into a spreadsheet. |
When the PDF is a scan
Neither tool can read a page that is only a picture of text. A scan has no form fields and no selectable text, so run OCR first to give it a text layer, and then try table extraction. Check the CSV against the original, especially for numbers split across columns.
When to choose which
Form data
Use form extraction when you hand out a fillable PDF and need the answers of each person in a structured file.
Tables
Use table extraction when the figures sit in a table inside a report, a statement or an invoice that was not built as a form.
Free tools for both options
Guides that put it into practice
PDF terms explained
- PDF form fields (AcroForm)Fillable PDF forms use AcroForm fields: text boxes, checkboxes, lists and radio buttons. Learn how fields store answers and how to fill, list or export them.
- Table extractionTable extraction turns tables printed in a PDF into rows and columns you can edit in a spreadsheet. Learn how it works, its limits and how to check results.
Common questions
- How do I know whether my PDF is a real form?
- Open it and click a blank area: if fields highlight and you can type, it is a form. The list of PDF form fields tool also shows the name and type of every field.
- Does table extraction keep the formatting?
- It saves the content of the cells as CSV, which carries no colors, fonts or merged cells. Reapply the formatting in your spreadsheet if you need it.
- Which tools do this?
- Extract PDF form data reads the fields of a fillable PDF and exports JSON or CSV. Extract PDF tables finds the tables of a PDF and saves them as CSV.