Hi Davis
For my clients who need to manipulate CSV files, I recommend a great utility program called Killink CSV by White Peak Software. For a small price, it does amazing things.
Excel can supposedly handle CSV files, but it often mangles them. Killink looks and works like Excel but preserves the integrity of CSV files.
Steve