When text and numbers are saved in a CSV file, it's easy to move them from one program to another. Rather than storing information in columns, CSV files store information separated by commas. At this point you will have your original Excel workbook (in Excel format) and the CSV file, which contains the information you wanted in CSV format.A CSV (Comma Separated Values) file is a special type of file that you can create or edit in Excel. I generally find it a good idea to close the workbook, without saving. Click on Yes to continue saving the information in CSV format.Īt this point your worksheet is saved in CSV format. Excel may display a dialog box telling you that not all Excel features can be maintained in the format you have chosen.Use the other controls in the dialog box to specify a file name and location.In the Save As Type drop-down list at the bottom of the dialog box, choose the CSV (Comma delimited) option.In order to save your workbook data in CSV format, follow these steps: If you have information in Excel that you want to get into a different data-oriented program, chances are good that the other program will accept CSV files. The importing program knows that when it sees a comma, it can toss it out but it needs to get ready to accept a new value. In the file, each value is separated by a comma. It means 'comma-separated values.' It refers to a type of file that is often used for transferring simple data from one program to another.

CSV is one of those over-abundant computer acronyms.

Create csv file from excel