Export form fields data into excel file

[stefan1580]

Hello,

I have created a pdf form.

This form will be used by several people and we need to collect data from those fields into an excel file.

Can this be done automatically? I mean the person after filling the form just to push a button and the data to be sent to the server and added to this excel file?

It should not overwrite existing data but add to it as a new row.

I have tried with merge data files into spread sheet but it does not work the way I like it.

Thank you.

[rayek.elfin]

Yes, this can be done. For example, you would write a PHP script and put it on a web server, and the data is captured by this script when a user submits the form as a FDF file. You would then generate a CSV file and append the new data to the existing data as a new row.

The CSV file is opened in Excel.

In practice it requires more than this, of course: error validation, and the user should be informed that the info has been transferred correctly. And the user should not be able to send the same form twice by mistake.

And you will need a web server set up as well, if you haven't already got one.

I am sure this can be done with other server tech as well, such as sharepoint. Lots of work, though.

[Thom Parker]

Have you tried using the Form Distribution service in Acrobat? 

Its in the button panel in "Prepare Form" mode.