I am having trouble opening csv files correctly in MicroSoft Excel for Mac 2011, Version 14.1.0. The files will open but the dialog box to set the delimeter as a comma does not come up and thus all the columns are concatenated with commas. Is there a way to get Excel to recognize the comma delimeter? Thanks!

Are you also the person creating the .csv file? Or simply been given the file? I ask because when you save a .csv in Excel you have the option of saving as CSV (Comma delimited) (.csv) CSV (Macintosh) (.csv) CSV (MS-DOS) (*.csv)
–
ColoradoRockieSep 10 '12 at 21:44

3 Answers
3

The trick is that you have to create a new workbook and then import the CSV file (i.e., via File / Import). In the CSV import dialog you can select things like the delimiter, encoding, etc.; whereas, you don't have the option of setting the delimiter character, etc. if you just open the existing CSV file directly.