How to Combine Multiple Fillable PDFs Without Overwriting Data
Question details
The user wants to merge several copies of the same fillable PDF form without the form fields sharing values and overwriting each other.
- Product
- Device & OS
- not provided
- Scenario
- Merging multiple filled PDF forms that contain different data into a single document.
- Observed behavior
- When combining the forms, fields with identical names share values, causing the data from one form to overwrite the data in the others.
Ensure you have saved backup copies of your original filled PDF forms before flattening or merging them, in case you need to edit the field data later.
Flatten PDF Forms Before Merging
Flattening converts interactive form fields into standard page text, preventing data from being overwritten when files are merged.
When form fields have the exact same name across different PDF files, PDF editors link them together. By flattening the forms first, you remove the interactive fields entirely while keeping the visible data intact.
Open each filled PDF document individually in your preferred PDF editor.
Locate the 'Flatten' or 'Print to PDF' option. If using Print to PDF, go to Menu > Print, select 'Microsoft Print to PDF' or your system's default PDF printer, and save the newly generated file.
Once all individual forms are flattened into standard PDFs, use the 'Merge PDF' or 'Combine' feature to join the flattened files into a single, continuous document.
Combine into a PDF Portfolio
A PDF Portfolio bundles multiple files together in a single container without actually merging their pages, keeping the interactive fields separate.
Rename Form Fields in Each Copy
If you need the merged document to remain a single, continuously scrolling file with editable fields, you must give every field a unique name before combining.
Easily Flatten and Merge PDFs with WPS Office
WPS Office provides robust PDF tools that allow you to quickly print to PDF to flatten documents and seamlessly combine multiple PDF files in just a few clicks.
- 1. Flatten the Form: Open the filled PDF in WPS Office, go to Menu > Print, choose 'WPS PDF' as the printer, and click Print to save a flattened copy.
- 2. Access Merge Tool: Open WPS Office, navigate to the 'Tools' tab on the top ribbon, and click on 'Merge PDF'.
- 3. Add Files and Combine: Click 'Add Files' to import all your flattened PDF copies, arrange them in the desired order, and click 'Merge' to export your final compiled document.
Frequently Asked Questions
Why do my PDF form fields overwrite each other when merged?
PDF forms use field names to identify data. When multiple forms with identically named fields are merged, the PDF viewer assumes they are intended to be the same field and applies the value of the most recently merged document to all of them.
Can I unflatten a PDF after merging it?
No, flattening a PDF permanently converts the interactive form fields into static text on the page. You cannot revert this process to make the fields interactive again, which is why keeping original backups is highly recommended.
Is it possible to lock PDF fields instead of flattening them before merging?
Yes, in some PDF editors, you can set form fields to 'Read-Only' in their properties. However, flattening is generally considered safer and more universally supported when merging multiple files with the exact same field names.
