This isn't opening the csv file directly, it's importing it into an existing (though possibly not yet saved) workbook. I can attest that it works correctly though it is kind of annoying if you don't want to do more than just some simple manipulation.

Also I believe excel for mac either doesn't have this feature or it's not as feature rich as the windows counterpart.