« Goodbye Bruce
Assessing Viewer Versions »

Collecting form data

You may have seen some tips on using the Distribute Form feature in Acrobat 8 or played around with it. Once the form is distributed you can easily combine data and export to a spreadsheet.

You may have another need for exporting form data from PDF forms that were created in earlier versions of Acrobat where you didn’t have the Distrubute Form feature available. Can you assemble this data and export to an Excel worksheet. The answer is YES, and it’s quite simple in Acrobat 8.

Just open the Forms menu and select Manage Form Data. From the submenu select Merge Data Files into Spreadsheet . A dialog opens and prompts you to add the forms you want to merge. Select the forms and click Export and a dialog opens permitting you to export the form data to a .csv file you can open in Microsoft Excel.

This entry was posted on Tuesday, January 9th, 2007 at 10:27 am and is filed under Forms Tips. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

6 Responses to “Collecting form data”

  1. StevenD Says:
    March 16th, 2007 at 2:34 pm

    Ted,

    I have read several articles and things about doing this but just how do I use the data once I get it into an Excel spread sheet? I have tried playing around with saving the datat from a form and opening it up in Excel but then I get this table with one row that stretches for miles horizontaly and I’m wondering how I use the data.

    Steven

  2. tedpadova Says:
    March 18th, 2007 at 3:13 pm

    There are virtually unlimited uses for working with data in Excel. You might have an event where people fill out registration forms and pay fees. When you export the form data to an Excel spreadsheet, you can sort individual columns and rows to view the data in various sorted orders, thus making processing payments and organizing events much easier than trying to had tabulate responses on all the returned forms.

    Merging files into a spreadsheet exports the data to a .csv file that can be read by Excel. The data are properly delimited and records appear on individual rows in the spreadshetet file. If you don’t export the data properly, you’ll see all the data appear in one long record.

    ted

  3. tolga Says:
    June 11th, 2008 at 10:58 am

    good news

    mirc

  4. tolga Says:
    June 11th, 2008 at 10:58 am

    yeah

    mirc indir

  5. tolga Says:
    June 11th, 2008 at 10:59 am

    best regards

    kız msn adresleri

  6. tolga Says:
    June 11th, 2008 at 10:59 am

    yes

    mırc indir

Leave a Reply

You must be logged in to post a comment.