CSV

THE-Spellchecker's avatar
Published Jul 31, 2021Updated May 15, 2024
Contribute to Docs

Comma-Separated Values (CSV) is a text file format where individual values are separated by commas. It is normally used to store tabular data and is favored for its simple structure allowing for straightforward parsing and data exchange.

To store tabular data, CSV files usually represent each line as a new row within the table and the values delimited by commas as the cells within each row. However, this practice is not formalized so the interpretation of the cell’s contents is normally application-specific.

For example, some applications use quotation marks (") or a backslash (\) to denote literal characters that allow the cells themselves to also contain the comma character.

  • Start your programming journey with an introduction to the world of code and basic concepts.
    • Includes 5 Courses
    • With Certificate
    • Beginner Friendly.
      4 hours
  • Looking for an introduction to the theory behind programming? Master Python while learning data structures, algorithms, and more!
    • Includes 6 Courses
    • With Professional Certification
    • Beginner Friendly.
      75 hours

Example CSV with Corresponding Tabular Representation

An example CSV file containing data about large animals and a common rendering of its tabular form can be found below:

Animal,Average Length (Feet),Average Weight (Tons)
African Bush Elephant,19.7,5.4
Indian Rhinoceros,13.8,2.1
Hippopotamus,16.5,2.0
Giraffe,16.9,1.1
Gaur,12.5,1.0
Animal Average Length (Feet) Average Weight (Tons)
African Bush Elephant 19.7 5.4
Indian Rhinoceros 13.8 2.1
Hippopotamus 16.5 2.0
Giraffe 16.9 1.1
Gaur 12.5 1.0

All contributors

Contribute to Docs

Learn General on Codecademy

  • Start your programming journey with an introduction to the world of code and basic concepts.
    • Includes 5 Courses
    • With Certificate
    • Beginner Friendly.
      4 hours
  • Looking for an introduction to the theory behind programming? Master Python while learning data structures, algorithms, and more!
    • Includes 6 Courses
    • With Professional Certification
    • Beginner Friendly.
      75 hours