CSV Format Data type

What is CSV?

CSV (Comma-Separated Values) is a plain text file format that stores tabular data. Each line is a row, and values are separated by commas.

Structure

Column1,Column2,Column3
value1,value2,value3
value4,value5,value6

Requirements for CMMI-DCC

  • First row must be column headers
  • Values separated by commas
  • Text with commas should be quoted
  • UTF-8 encoding recommended

Creating CSV Files

  • Excel: Save As -> CSV
  • R: write.csv()
  • Python: pandas.to_csv()
  • Text Editor: Manual creation

Common Issues

  • Incorrect delimiter (semicolons instead of commas)
  • Missing headers
  • Encoding problems with special characters

Related Terms

  • Bulk Upload: Uses CSV files
  • Export: Downloads data as CSV