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

Assigning specific PDF Form Fields to Specific Excel SS Column

Jeremy82many
Registered: Aug 21 2008
Posts: 3

Hello!
I'm using Acrobat Pro 8, and I'm learning the functionality of designing forms. I've got the forms I need created and functioning the way I'd like them to. Now on the forms, we have certain info that needs to be documented, but that we do not really enter into our database system at all.
We have other info that we have to manually enter sometimes hundreds of pages of info. Of course there is human error.

Now that we have these PDF forms, and I know that they can be exported into Excel spreadsheets (I'm using Office 2003, and I actually did export a data set from the forms into an Excel spreadsheet already). When I did the export into Excel from my forms, it seemed like the information was a bit jumbled.

My question is this - Can I identify certain fields in the PDF, and tie them to a column in an Excel spreadsheet? i.e. for every form, the information in "field 1" will tie to "Column A" on the spreadsheet.

This way I can import the spreadsheets into our database system. Any help is greatly appreciated!

My Product Information:
Acrobat Pro 8.0, Windows
lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
There isn't a straightforward way to tie form fields to specific cells in Excel; however this is a useful suggestion about how to order spreadsheet output in the following post for Acrobat 8 at:
http://www.acrobatusers.com/forums/aucbb/viewtopic.php?id=282

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

Jeremy82many
Registered: Aug 21 2008
Posts: 3
Thanks very much that looks like it will work exactly like I want it to, but I admit my ignorance...I am not too familiar with that kind of Excel coding, would I be able to find info on it in the Help tab in Excel? Anywhere helpful for a newbie would be appreciated. many thanks!
lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
BTW -- the capability to filter form field information was added in version 9. You can filter responses and then export the information to Excel.

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