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.