Step 5: Click the OK button at the bottom of the window to apply your changes. If you know that you need to use one of those formats, choose that option instead. Note that there are two other CSV file type options. Step 4: Click the drop-down menu to the right of Save files in this format, then choose the CSV (comma delimited) option. Step 3: Click the Save option in the column at the left side of the Excel Options window. Step 2: Click the File tab at the top-left corner of the window, then click Options at the bottom of the column on the left side of the window. Fortunately Excel will let you know if a document that you are creating has any formatting that is not compatible with CSV, and that that formatting will be lost if you continue saving the file in the CSV format. One important thing to consider when you are saving to the CSV file type is that Excel has a number of options and objects that are not compatible with CSV.

Set CSV as the Default Excel 2010 File Type Many database and other Web-based applications use the CSV file format because of its’ versatility and, if you frequently need to create CSV files to upload to those applications, it might be easier for you if Excel saves to that file format by default.

This is very helpful when you are dealing with spreadsheet-compatible document types like comma separated value (CSV) files. It also has the ability to convert spreadsheet documents that are not in the Excel file format, while simultaneously permitting you to save your own created files to non-Excel file formats. Excel 2010 is a very versatile program that lets you perform a number of spreadsheet-related activities.

Create csv file from excel