Saving in csv format of MS Excel 2007

Asked By 30 points N/A Posted on -

There are 3 (three) CSV format available at save in Excel Options of MS Excel 2007. Please see the attached picture.

My question is which one should I use to save the excel file in CSV format?

Answered By 0 points N/A #120520

Saving in csv format of MS Excel 2007



Hello Larry.

If you are going to use the CSV file for a Mac then you should definitely select "CSV (Macintosh)".  For Windows use, you can choose either "CSV (Comma delimited)" or "CSV (MS-DOS)".  There is some debate among Excel users on what the difference between comma delimited and MS-DOS is.  

Most agree that either format works fine on Windows.  Tests also show that choosing either one produced byte-for-byte identical files.  The similarity, however, is there only when common ASCII characters (such as the English alphabet, numbers, common punctuations and symbols, etc.) are used.  Some special ASCII characters (such as foreign letters) can result to some differences that are not easy to spot.  Therefore, I recommend you just use "CSV (Comma delimited)" every time you need to save as CSV. 

Login/Register to Answer

Related Questions