CSV or Comma Delimited?
What is the difference between CSV files, (Comma Separated Values), and Comma Delimited files?
RE: CSV or Comma Delimited?
Answer to the question:
Both are Text files to which your Excel Spreadsheet can be saved, enabling you to share data with non Excel Users. To undertake the task choose File, Save As and from the Save In drop down option choose either Text Delimited or Text CSV.
When you import a delimited Text file, Excel will open the Text Import Wizard enabling you to follow various steps to successfully import the text into a spreadsheet format. However in respect of the CSV file; The Text Import Wizard is not displayed. Instead, the text file is parsed into separate columns, using commas as delimiters.
If you want the Text Import Wizard to be displayed for files with a .csv extension, rename the text file so that its file name extension is .txt.
Note that the file icon type is also different.
Importing and Exporting are covered on the Excel Advanced Course.
