Excel ignores comma delimiters in .csv files, but invokes the Text Import Wizard for .txt files that "appear delimited". Surely it should behave the same way for .csv files?
You can always compel the Wizard to appear.
First open Excel, then, using the Ribbon, goto the Data tab and then touch From Text in the Get External Data group.
If you do not need the Wizard, then simply double-click the file's icon to open it.