Seems to be topic of the day 
If you're truly an expert you've probably overcome them, but I've been annoyed too many times by Excel's idiosyncrasies wrt generic CSV processing, it seems to reflect MS's arrogance about it knows better than the user and doesn't respect the standard out of the box.
See this post and this one (also linked in the former) for my preferred toolset ATM, but of course feel free to ignore this if you really prefer to work in Excel that much.
But even then you may want to have a look at CSVed's "export to XLS" feature set - just the fact of its complexity is quite an eye-opener.