Can I merge data files to *existing* spreadsheet?
Hello,
The "Merge Data Files into Spreadsheet" feature of Acrobat Pro is great, but there is one huge issue I want to ask about. Right now, when it puts the fillable form field data into an excel .csv file, the headings look something like "topmostSubform[0].Page1[0].f1_01_0_[0]" (cell B1), "topmostSubform[0].Page1[0].f1_02_0_[0]" (cell C1), and so on. The data from each field is in the column below its corresponding heading. Obviously, these headings are not very descriptive or intuitive. Is there a way to specify the headings of each column beforehand to something more descriptive (e.g. B1 = "Name", C1 = "Age", etc.)?
Another solution, which would be even better and seemingly more plausible, is to merge the data into an existing .csv file rather than create a new one for each report. This way the form field data could simply be exported to an existing Excel spreadsheet (specifically, appended to the bottom, starting at the first blank row) with headings already defined by the user, one per column. This is the single biggest improvement I would suggest/feature I want to know about if it already exists. Right now the workaround is copying and pasting the .csv data into another spreadsheet (to the bottom, in the first available row) which does have those headings already set by me, though as you can imagine this is less than ideal.
Thanks!
