What is the difference between different CSV files?

Are there different types of CSV files?

There are different CSV formats available because there are different ways of creating CSV files. (Makes sense, huh?) Actually, there are many, many ways of creating CSV files, but Excel supports only these four. Each format affects character encoding in slightly different ways.

What kind of CSV file should I use?

csv extension. CSV files can be used with most any spreadsheet program, such as Microsoft Excel or Google Spreadsheets. They differ from other spreadsheet file types because you can only have a single sheet in a file, they can not save cell, column, or row. Also, you cannot not save formulas in this format.

What's the difference between CSV MS DOS CSV Macintosh CSV comma delimited?

@KeithThompson CSV (Macintosh) saves with CR as the new-line character, whereas CSV (Comma delimited) and CSV (DOS) both use CR/LF. I found this out by saving a small spreadsheet and opening it in Notepad++ with "Show All Characters" enabled.

Is there a difference between CSV and CSV?

There are two things going on. The abbreviation (and suffix) "CSV" can mean character-separated values or it can mean comma-separated values. "Microsoft Office Excel comma separated values file" is a disambiguation, and means that you have a number of values in a record, with the field values separated by a comma.