Append PDF Form Data to an Existing Excel Ledger
Question details
The user wants PDF form submissions added to an existing Excel ledger, preferably automatically.

- Product
- Adobe Acrobat and Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collect data from completed PDF forms and add each submission to an existing workbook.
- Observed behavior
- Acrobat's Merge Data Files into Spreadsheet feature creates a separate exported spreadsheet rather than continuously appending submissions to the existing ledger.
Check that the PDF forms use consistent field names and that the ledger has corresponding columns. Identify where new submissions arrive and whether the ledger is stored in a location accessible to any automation you plan to use.
Export PDF form data and append it to the Excel ledger
Use this approach when manual updates are acceptable or you need to add a batch of submissions.
In Adobe Acrobat, use Merge Data Files into Spreadsheet to select the completed forms and save the exported data file.
In Excel, open the exported data file and the existing ledger workbook. If prompted when opening a text file, check the delimiter and column formats.
Compare the exported field headers with the ledger columns. Copy the submission rows and paste them below the existing ledger entries, aligning each field with the correct column.
Review the new rows for missing values, dates, and duplicates, then select File > Save in the ledger workbook.

Automate new submissions with a PDF extraction workflow
Use an automation workflow when new forms arrive regularly and you need rows added without manual copying.
Append exported PDF form data with WPS Spreadsheets
Open the data exported from Acrobat alongside your existing ledger in WPS Spreadsheets, then align and paste the submission rows. This is a manual append, not a continuous PDF submission workflow.
- 1. Export from Acrobat: In Adobe Acrobat, use Merge Data Files into Spreadsheet to save data from the completed PDF forms.
- 2. Open the files: In WPS Spreadsheets, use File > Open to open the exported data file and the existing Excel ledger.
- 3. Append the submissions: Compare the field headers, then copy the exported submission rows and paste them below the ledger entries in the matching columns.
- 4. Review and save: Check the appended rows for correct values and duplicates, then use File > Save to update the ledger.

Frequently Asked Questions
Can Acrobat automatically append merged form data to my existing Excel workbook?
The Merge Data Files into Spreadsheet feature creates a separate export; it does not continuously append to an existing workbook. You can copy the exported rows into the ledger or build an automation workflow.
How do I keep PDF fields aligned with Excel columns?
Use consistent field names across the PDF forms and corresponding headers in the ledger. Before pasting or configuring an automation action, match each exported field to its destination column.
Does Power Automate read fillable PDF fields by itself?
Do not assume a standard flow can extract the fields directly. Use a suitable PDF extraction connector, Acrobat integration, or custom processing step, then map its output to the Excel table.
Why does my Excel ledger need a table for Power Automate?
The Excel Online (Business) Add a row into a table action targets an Excel table. Select the ledger range in Excel and choose Insert > Table before configuring the action.




