• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
12

How to export data from multiple forms in Adobe Pro

Community Beginner ,
Feb 23, 2024 Feb 23, 2024

Copy link to clipboard

Copied

Hi,

I have data of 100s of filled forms which i want to export in excel and then refelect that data into a dashboard.

  1. How can I find "Export data from multiple forms" in Adobe Pro Ver 2023.008.20533 64 Bit?
  2. How can I update the excell data when new PDF forms comes in?
TOPICS
Edit and convert PDFs , PDF , PDF forms

Views

166

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Feb 23, 2024 Feb 23, 2024

Acrobat has a built-in method for exporting data on the More Menu in the "Prepare Forms" tools.

It has some limitations, for example, its a one shot action. You select the forms for export and it creates a CSV file.  There is no built-in method for updating the CSV.  Another limitation is that it won't export data from some protected or signed files. 

 

The only other option is a 3rd party tool or create your own.

I've created several JavaScript automation tools for importing and exporting data.

...

Votes

Translate

Translate
Community Expert ,
Feb 23, 2024 Feb 23, 2024

Copy link to clipboard

Copied

Acrobat has a built-in method for exporting data on the More Menu in the "Prepare Forms" tools.

It has some limitations, for example, its a one shot action. You select the forms for export and it creates a CSV file.  There is no built-in method for updating the CSV.  Another limitation is that it won't export data from some protected or signed files. 

 

The only other option is a 3rd party tool or create your own.

I've created several JavaScript automation tools for importing and exporting data. You can see some of them here:

https://www.pdfscripting.com/public/Automation-Tool-Descriptions.cfm

and here:

https://www.pdfscripting.com/public/Form-Data-Handling.cfm

 

I've also created an Action (batch process) for exporting to a CSV file. This tool also keeps a log of all imported files and can update the CSV with new files at anytime. Contact me if you are interested.    

 

MergeFormsToCSV.jpg

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 23, 2024 Feb 23, 2024

Copy link to clipboard

Copied

LATEST

2. You can't do that automatically. You will have to re-run the entire process using the new files. You also can't append data to an existing spreadsheet, only create new ones. In Excel you can then import that data into your existing file.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines