How do you get your data to put into CSV format for new user creation?

I want to go from some type of data input form where a manager enters first name, last name, department, phone#, etc. Then that data will be 'processed' to find appropriate values for other fields. Example:

These values are entered:

• Pat 
• Smith
• Accounting
• Accountant
• 123-456-7890

From that information I want to end up with:

1. If Dept = Accounting then Company = Alpha; Email extension = @alpha.com; staff folder belongs in \\alpha\accounting\staff\@username; profile location = \\alpha\profiles\@username
2. If Dept = HR then Company = Delta; email extension = @delta.org; staff folder belongs in \\delta\accounting\staff\@username; profile location = \\delta\profiles\@username

Does that make sense? I have a number of questions I want to ask a manager and I want a way take their responses, evaluate them and create values which will ultimately end up looking like: 

I'm looking to see if anyone uses some type of form to gather this data from managers, and what they use. And second to see if anyone then has some way to process the data to dump it into a csv file?