Exporting to Excel problem

[Johnthomp2]

I am not sure whether this is a Microsoft Excel problem or a problem with LiveCycle.  I have a job application that I created in livecycle.  When people submit it it sends it to me as a pdf.  I then keep a copy of the pdf as well as save it as an xml file.  I then want to import that xml file into excel.  In excel I want all of the components to appear in one row for each applicant.  Right now when I import into excel, the information for only one applicant uses about 25 rows.  Anyone know how to fix this?

[Former Community Member]

Try this: in Acrobat, go to Forms: Manage Form Data: Merge Data Files into Spreadsheet.

This will give you one row for each file and a column for each data field.