These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

How can I export data to Excel in the other than alphabetical sequence

Forum Index > Forms: Acrobat > How can I export data to Excel in the other than alphabetical sequence
2009-08-16 05:57:39
CarolinaPower
Registered: Mar 26 2009
Posts: 43

...of form field names? Put another way, fields found on the first page of my form might should up in the last column of my spreadsheet simply because the field name begins with "Z".

I am using the Forms feature in Acrobat 9 Pro

My Product Information:
Acrobat Pro 9.1.3, Windows
Top
2010-11-02 14:11:58
#1
jmason
Registered: Jun 22 2007
Posts: 73
I have the same question...I've been searching through tons of forum questions to find my answer, and this is exactly what my question is.
Here's my situation:
I have built a PDF form that will be used by several different people in our company, each day. They will be entering data into it, and using a button I set with a "Save As" action, so that they can save the completed form on our network drive.
An employee in another department will be gathering this info daily. I have tested the Forms > Manage Form Data > Merge Data Files into Spreadsheet function, which works exactly how I want it to, except it doesn't keep the fields in the same order as they appear on the form. It organizes the form field data into alphabetical order across the top of the spreadsheet.
I am trying to figure out how I can keep the data in the order it appears on the PDF, when it is converted to Excel.
Any help is appreciated. Thank you!
Top
2010-11-02 14:36:37
#2
jmason
Registered: Jun 22 2007
Posts: 73
jmason wrote:
I have the same question...I've been searching through tons of forum questions to find my answer, and this is exactly what my question is.
Here's my situation:
I have built a PDF form that will be used by several different people in our company, each day. They will be entering data into it, and using a button I set with a "Save As" action, so that they can save the completed form on our network drive.
An employee in another department will be gathering this info daily. I have tested the Forms > Manage Form Data > Merge Data Files into Spreadsheet function, which works exactly how I want it to, except it doesn't keep the fields in the same order as they appear on the form. It organizes the form field data into alphabetical order across the top of the spreadsheet.
I am trying to figure out how I can keep the data in the order it appears on the PDF, when it is converted to Excel.
Any help is appreciated. Thank you!
OK! So, I just discovered a way to (sort of) get around the alphabetical order thing. I tried naming my fields with numbers in front (i.e. 01Name; 02Date; 03Branch; etc.) and this put the data in the order I wanted it in Excel. The only weird thing is that the numbers are also included in the column headers, but for us, I think that's fine, as long as the columns are in a logical order as they appear on the PDF form. BUT you have to use two-digit numbers for 1-9 (01-09), otherwise it will put fields 10+ first. WOO HOOO!!!

Top