Comment by kcoddington

CSV is data only. Excel handles way more than that. XLSX is the preferred file format because it's compressed XML that can hold all kinds of things.

Also, CSVs seem to open just fine on my Excel. If it's not formatted with a standard delimiter or isn't handing quoted strings the proper way, sure maybe the data wizard is needed.

Excel is terrible in a lot of aspects, but CSVs seem to be something it handles as well as anything else in my experience.