Excel Guides

Comma-Delimited and MS-DOS CSV Variations in Excel

There are a few variations of CSV files, which can be confusing when trying to open them in Excel. This article will explain the differences between comma-delimited and MS-DOS CSV files, and how to open each type in Excel.

Comma-Delimited CSV Files

Comma-delimited CSV files are the most common type of CSV file. They are supported by almost all spreadsheet programs, including Microsoft Excel. Comma-delimited CSV files use commas to separate values, and each row is stored on a separate line. For example:

Name,Age,Gender
John,20,Male
Jane,21,Female

In this example, the values in each row are separated by commas. The first row contains the column headers, while the subsequent rows contain data. Note that there is no space after the commas.

MS-DOS CSV Files

MS-DOS CSV files are less common than comma-delimited CSV files, but they are still used by some programs. MS-DOS CSV files use commas to separate values, but each row is stored on a single line. For example:

"Name","Age","Gender"
"John","20","Male"
"Jane","21","Female"

In this example, the values in each row are separated by commas. The first row contains the column headers, while the subsequent rows contain data. Note that there is a space after the comma in each value.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.