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

Batch Processing of Acrobat Fillable Forms to Excel Spreadsheet

New Here ,
Jan 26, 2024 Jan 26, 2024

Copy link to clipboard

Copied

It has been many years since I have had to do this. I will be sending a pre-publication book reservation form to more than 500 who have indicated interest in my forthcoming book. Some may no longer be interested and others may want multiple copies. So... I will create a fillable form that I will email to the list. Respondents will return the completed form by email.  Can I batch-process those PDFs which will all have the same filename and could come in in large numbers at a time? I will use the resulting spreadsheet to bath-generate PayPal invoices.

 

Thanks in advance, Lauren P.

TOPICS
PDF forms

Views

357

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 ,
Jan 26, 2024 Jan 26, 2024

Copy link to clipboard

Copied

LATEST

One way to do this is with the "Merge data files into spreadsheet" option. Which is on the "More" menu in Prepare Forms. This does not append data to an Excel file. It merges all the PDFs into CSV file, which you can import into Excel. 

 

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