How to Find Merge Data Files to Spreadsheet Tool in Acrobat
Question details
The user is unable to locate the 'Merge Data Files to Spreadsheet' tool in the main Tools menu of Adobe Acrobat 2017.

- Product
- Adobe Acrobat 2017
- Device & OS
- not provided
- Scenario
- Extracting and merging data from multiple PDF forms into a single spreadsheet.
- Observed behavior
- The 'Merge Data Files to Spreadsheet' command is missing from the main Tools menu.
Ensure you have the PDF form files you want to extract data from saved in an easily accessible folder. Confirm that your documents are standard Acrobat forms, as LiveCycle forms may have different compatibility requirements.
Locate the Merge Tool in the Forms Editor
Access the hidden command through the Forms editor's extended menu options.
In Adobe Acrobat 2017, the interface was updated, moving several specific form-related tools out of the main dashboard. The data extraction tool now lives exclusively inside the 'Prepare Form' environment.
Launch Adobe Acrobat 2017 and open one of the PDF form files you wish to process.
Navigate to the right-hand pane or the main Tools menu and click on 'Prepare Form' to enter the Forms editor.
In the right-hand pane of the Forms editor, look for the 'More' menu button (represented by a wrench icon or a dropdown arrow).
Click on 'More' and select 'Merge Data Files into Spreadsheet' from the dropdown list to begin compiling your form data.

Easily Convert PDF Forms to Spreadsheets with WPS Office
Instead of navigating complex menus to merge form data, you can use WPS Office to quickly convert your PDF forms directly into Excel spreadsheets for easy data management and analysis.
- 1. Open WPS Office: Launch WPS Office and open your PDF form using the built-in WPS PDF viewer.
- 2. Select PDF to Excel: Navigate to the 'Tools' tab and click on the 'PDF to Excel' conversion feature.
- 3. Convert and Save: Choose your desired output settings and click 'Convert'. The data will be extracted into a new spreadsheet.
- 4. Consolidate in WPS Spreadsheet: Open the converted files in WPS Spreadsheet to easily copy and consolidate your data into a single master sheet.

Frequently Asked Questions
Why is the Merge Data Files to Spreadsheet option missing in Acrobat?
In newer versions like Acrobat 2017 and Acrobat Pro DC, Adobe reorganized the interface to streamline the main dashboard. The merge tool was moved from the main Tools menu into the 'More' options specifically within the 'Prepare Form' editor.
Can I merge data from LiveCycle forms into a spreadsheet?
Merging data from LiveCycle (XFA) forms can be problematic as they use a different architecture than standard Acrobat forms. It is highly recommended to use standard Acrobat PDF forms to ensure full compatibility with the data extraction tool.
What format does Acrobat export the merged form data to?
When you use the Merge Data Files into Spreadsheet tool, Acrobat typically exports the consolidated form data as a CSV (Comma Separated Values) file. This file type can be easily opened and formatted in Microsoft Excel or WPS Spreadsheet.
Do all PDF forms need to have the same fields to merge data properly?
Yes, for the data to align correctly into neat columns in the resulting spreadsheet, all the PDF forms you are merging must be identical in structure and contain the exact same form field names.




