PDF Editing Issues

Find Form Options and Merge Form Data in Acrobat Pro DC

Chanuka GeekiyanageChanuka Geekiyanage Nov 19, 2026 868 views

Question details

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

Find Form Options and Merge Form Data in Acrobat Pro DC
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Prepare Form

In Acrobat Pro DC, open Tools and select Prepare Form. If you cannot see it, search for Prepare Form in the Tools search field.

2
Find the merge command

Open the form-data options, typically under More, and select Merge Data Files into Spreadsheet.

3
Select the exported data

In the dialog, select Add Files and choose the exported form data files you want to combine.

4
Export the spreadsheet data

Select Export, choose a save location and file name, and save the merged data. Open the resulting file in a spreadsheet application.

Merge form data from the Prepare Form tool
Menu names can vary: The location of the form-data options may differ between Acrobat versions. Use the Tools search field to find Prepare Form if it is not immediately visible.
Free Microsoft Office alternative

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.

Open and review exported spreadsheet data from PDF formsCompatible with Microsoft Excel formats, including XLSXFamiliar spreadsheet interface for easy migrationFree and lightweight office suite
microsoft office alternative - wps office

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.