Documentation

The PDF Form Batch Filler reads a fillable PDF template locally in your browser, maps CSV or Excel rows to PDF form fields, and exports all generated PDFs as a ZIP file. It is useful for contracts, applications, expense forms, certificates, registration forms, and fixed-format office documents.

Core Features

  • Upload a PDF template with fillable form fields.
  • Read CSV, XLS, and XLSX data files.
  • Automatically match columns by field name, then adjust mappings manually.
  • Fill text fields, checkboxes, radio groups, dropdowns, and option lists.
  • Choose a data column for output filenames, or use row numbers.
  • Optionally flatten form fields and export all PDFs as one ZIP file.
  • Process files locally in the browser without actively uploading PDF or spreadsheet data.

Steps

  1. Upload the PDF form template.
  2. Upload a CSV or Excel data file with headers in the first row.
  3. Check the field mappings between PDF fields and data columns.
  4. Set the filename prefix, filename column, and flattening option.
  5. Build the ZIP and download it from the result area.

Data File Rules

  • The first row must contain column names.
  • Each row after the header creates one filled PDF.
  • Columns with names matching PDF field names are mapped automatically.
  • Checkboxes accept 1, true, yes, on, checked, and Chinese checked values.
  • Option lists can split multiple values with commas, semicolons, vertical bars, or Chinese separators.

Flattening

Flattening turns form fields into static PDF page content. The exported fields usually cannot be edited as form controls afterward. Use it for archives, submissions, external delivery, and preventing accidental field changes. Keep flattening disabled when the PDF must remain editable.

Use Cases

  • Generate contracts, quotes, applications, and registration forms in batches.
  • Create certificates, notices, or receipts from Excel lists.
  • Fill fixed PDF forms with CSV data exported from business systems.
  • Prepare standard PDF forms for submission, archiving, or printing.

Privacy

This tool reads the PDF template, spreadsheet data, and generated ZIP locally in your browser. It does not actively upload the original files or generated results.