Skip navigation
keebos325ic
Currently Being Moderated

Exporting a single table from an acrobat created form

Aug 17, 2012 12:11 PM

Tags: #export #table #acrobat-forms

I created a 5 page document InDesign (CS5.5), On one page I created a table that is 4 columns x 25 rows (with the first row being a header), using the table feature. I then exported to pdf and finalized the form in Acrobat 9.2 Pro. After running the Form Field Recognition the table was populated with the appropriate fields. I finalized the form and distributed. When the form is returned to me, I am trying to export JUST the information in this table to a spreadsheet (employee name, title, phone, email, ) and do not seem to be able to do so. Is this possible from a form? It doesn't seem like the pdf recognizes this table as a table any longer. It is a list of attendees, so I want to take this list from each returned form and combine them all into a master list.

 

With the selection tool I have tried to select all the text > right click > Open Table in Spreadsheet and only the header rows appear. If I choose just the text and not the headers, then nothing appears. If I export the entire document then each cell of the table is its own column in excel, which makes sense since they all have different field names, but this doesn't make the spreadsheet useful. The only thing I have been able to do is select all the cells, copy into notepad, place a tab between each piece of information > save and open that document in excel. I am hoping there is an easier way. Basically all I am trying to do is have that table appear in excel as it does the pdf. I have searched several websites and have not been able to find anything that specifically deals with exporting a single table from a completed form.

 

Perhaps I need to set the table field names differently? Any assistance would be greatly appreciated.

 
Replies
  • Currently Being Moderated
    Aug 17, 2012 12:34 PM   in reply to keebos325ic

    The "table" idea here is just a design idea, the identity as a table no longer exists in a PDF.  The feature you're trying to use is for tables which are part of the regular PDF, not form fields.

     

    You can export form data. All fields, but then process to exclude the ones you don't want.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (1)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points