These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

exporting to .csv from form, need only certain data imported

Forum Index > Forms: Acrobat > exporting to .csv from form, need only certain data imported
2008-02-09 16:03:02
Chris01
Registered: Feb 9 2008
Posts: 10
Answered

I am running Acrobat 8 Pro. I have created a form in Acrobat and there are about 20 or so fields. This is an injury report form and I am the one filling all of these forms out throughout the year.

I wanted to compile the data into an excel spreadsheet so that I could better analyze it. What I did was to create a pdf package with a couple of the injury reports already filled out and then exported it to excel. It looks ok, but there are many fields from the form that I don't need imported into the spreadsheet.
1. Is there a way to only import certain fields into the spreadsheet?
2. Am I going about this the right way; by creating a pdf package and such

Thanks in Advance,
Chris

My Product Information:
Acrobat Pro 8.0, Macintosh
Top
2008-02-11 06:10:39
#1
lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
It's relatively easy to control form field data when you use a Submit (or email) button on your form but not when you're directly exporting to Excel. You might try the suggestion on the following post for formating your form data in Excel:
http://www.acrobatusers.com/forums/aucbb/viewtopic.php?id=282

Also, are you using the "Manage Form Data" command in Acrobat 8 Pro.? This is probably the easiest way to manage the process.

Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.

Top
2008-02-11 07:51:54
#2
Chris01
Registered: Feb 9 2008
Posts: 10
Thank you for the reply. Is adding a submit button the easiest way? From what I understand, the submit button is for emailing the completed form back to the author. I am the both the author and the person filling out this form. I fill out the forms and just save them in a file on my desktop to be added to my pdf package.

Also, I just tried the Manage Form Data - Merge Data Files into a Spreadsheet. It did export my forms to a .csv but it didn't give me a option of exporting only certain fields.


P.S. I guess I didn't even really need to create the package to begin with.
Top
2008-02-11 09:03:47
#3
lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
Submit buttons are used for both email and web based form applications, which doesn't necessarily fit your scenario. You might want to try using the Manage Form Data feature and then follow the suggestion in the link mentioned above where you create another sheet in Excel to format the data from the forms.

Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.

Top
2008-02-11 09:12:40
#4
Chris01
Registered: Feb 9 2008
Posts: 10
oh ok, that makes more sense to me now - manipulate the data once it is in excel.
Thanks a lot lkassuba.
Be prepared for more questions from me in the near future...
Top