Saving a set of data in this format will removing any special Excel formatting from the data and simply place it in a list, with a comma separating each piece of data.

How to Remove CSV Formatting From a File. Files containing comma separated values (CSV) files are useful for storing data from disparate sources or from your relational database management system.