Save your file in XLSX or XLS format, depending on whether you only work with other users of Excel 2010 or you send files to people who use older versions of the software.

Select "CSV (Comma delimited) (*.csv)" in the Save As Type drop-down box and then click "Save" to save the file as a CSV file. Click "OK" when Excel warns you that only the selected sheet will be ...