How to Use Excel to Parse Text. Computer programmers often use parsing programs to convert text into formats that other applications can use. Parsers split items in a text string into separate fields.

Learn how to parse data in Microsoft Excel easily using our step-by-step guide.

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.