PDF Editing Issues

How to Find Merge Data Files to Spreadsheet Tool in Acrobat

Nimra MalikNimra Malik Oct 28, 2026 869 views

Question details

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

How to Find the Merge Data Files to Spreadsheet Tool in Adobe Acrobat
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.
Before you start

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.

Solution 1Recommended

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.

1
Open a PDF Form

Launch Adobe Acrobat 2017 and open one of the PDF form files you wish to process.

2
Access the Prepare Form Tool

Navigate to the right-hand pane or the main Tools menu and click on 'Prepare Form' to enter the Forms editor.

3
Open the More Menu

In the right-hand pane of the Forms editor, look for the 'More' menu button (represented by a wrench icon or a dropdown arrow).

4
Select the Merge Command

Click on 'More' and select 'Merge Data Files into Spreadsheet' from the dropdown list to begin compiling your form data.

Locate the Merge Tool in the Forms Editor
Form Compatibility: This feature works best with standard Acrobat PDF forms. If your document uses a LiveCycle (XFA) form, the tool may behave differently or be unavailable.
WPS PDF to Spreadsheet Solution

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. 1. Open WPS Office: Launch WPS Office and open your PDF form using the built-in WPS PDF viewer.
  2. 2. Select PDF to Excel: Navigate to the 'Tools' tab and click on the 'PDF to Excel' conversion feature.
  3. 3. Convert and Save: Choose your desired output settings and click 'Convert'. The data will be extracted into a new spreadsheet.
  4. 4. Consolidate in WPS Spreadsheet: Open the converted files in WPS Spreadsheet to easily copy and consolidate your data into a single master sheet.
Seamlessly convert PDF forms to editable Excel spreadsheets.High compatibility with Microsoft Excel (.xlsx) formats.All-in-one suite to view, edit, and manage PDFs and spreadsheets.Lightweight application with an intuitive, user-friendly interface.
microsoft office alternative - wps office

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.