Data Import & Export

Append PDF Form Data to an Existing Excel Ledger

Aamir Naveed AkramAamir Naveed Akram Nov 19, 2026 870 views

Question details

The user wants PDF form submissions added to an existing Excel ledger, preferably automatically.

How to Append PDF Form Data to an Existing Excel Ledger
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.
Before you start

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.

Solution 1Recommended

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.

1
Export the form data

In Adobe Acrobat, use Merge Data Files into Spreadsheet to select the completed forms and save the exported data file.

2
Open both files

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.

3
Match and append columns

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.

4
Check and save

Review the new rows for missing values, dates, and duplicates, then select File > Save in the ledger workbook.

Export PDF form data and append it to the Excel ledger
Exporting is not a recurring append: Repeat the export and append process for new submissions. Acrobat's merge feature does not continuously update the existing workbook.
Work with PDF form data

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. 1. Export from Acrobat: In Adobe Acrobat, use Merge Data Files into Spreadsheet to save data from the completed PDF forms.
  2. 2. Open the files: In WPS Spreadsheets, use File > Open to open the exported data file and the existing Excel ledger.
  3. 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. 4. Review and save: Check the appended rows for correct values and duplicates, then use File > Save to update the ledger.
Append exported PDF form data to an existing ledgerOpen and edit Microsoft Excel XLSX workbooksReview exported rows and ledger columns side by sideUse a familiar spreadsheet interface for routine updates
microsoft office alternative - wps office

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.