A VBA macro in Excel definitely sounds like the way to go. Load the CSV file, load your template spreadsheet, and shuffle the values around. It's pretty straightforward stuff.