Find Form Options and Merge Form Data in Acrobat Pro DC
Question details
The user needs to locate Form Options in Acrobat Pro DC and merge exported form data into a spreadsheet.

- Product
- Adobe Acrobat Pro DC
- Device & OS
- Windows 10
- Scenario
- The user wants to combine data exported from PDF forms into a spreadsheet.
- Observed behavior
- Form Options is not visible in the Edit menu, so the user cannot find the merge command.
Make sure you have the exported form data files you want to combine and know where they are saved. Open Acrobat Pro DC and have the relevant PDF form available.
Merge form data from the Prepare Form tool
Use Prepare Form to find the merge command when Form Options is missing from the Edit menu.
In Acrobat Pro DC, open Tools and select Prepare Form. If you cannot see it, search for Prepare Form in the Tools search field.
Open the form-data options, typically under More, and select Merge Data Files into Spreadsheet.
In the dialog, select Add Files and choose the exported form data files you want to combine.
Select Export, choose a save location and file name, and save the merged data. Open the resulting file in a spreadsheet application.

Review Merged Form Data in WPS Spreadsheets
After merging the form data in Acrobat, use WPS Office as a free, lightweight option to review and edit the exported spreadsheet. Its familiar interface and Microsoft Office format compatibility make migration easy. WPS does not replace Acrobat's form-data merge command.

Frequently Asked Questions
Why can't I find Form Options under Edit in Acrobat Pro DC?
The form-data commands are available through Prepare Form rather than necessarily appearing under Edit. Open Tools, select Prepare Form, and look for the form-data options under More.
How do I combine data from several PDF forms?
In Prepare Form, select Merge Data Files into Spreadsheet from the form-data options. Use Add Files to select the exported data files, then select Export to save the combined data.
What if Prepare Form is not visible in Acrobat?
Open Tools and search for Prepare Form using the Tools search field. Menu locations can vary between Acrobat versions.
Can WPS Office merge Acrobat form data files?
Use Acrobat's Prepare Form tool to merge the exported form data. You can then open and review the resulting spreadsheet data in WPS Spreadsheets.




