CSV

Updated: 08/16/2021 by Computer Hope
CSV file

Short for comma-separated values, CSV is tabular data that is saved as plaintext data separated by commas.

For example, if you had a table similar to the example below, that data would be converted to the CSV data shown below the table.

Example CSV data

Data1,Data2,Data3
Example1,Example2,Example3
Example1,Example2,Example3

Example CSV table

Data1 Data2 Data3
Example1 Example2 Example3
Example1 Example2 Example3

As shown in the above example, each row is a new line, and each column is separated with a comma. Many online services, such as an online bank, allow its users to export tabular data from the website into a CSV file. These files can then be opened and viewed offline using a spreadsheet program, such as Microsoft Excel.

Why are CSV files used?

There are two primary reasons CSV files are used online.

  1. CSV files are plain-text files, which makes them easy for the website developer to create.
  2. Because the CSV is plain-text it can be imported into any spreadsheet program or database regardless of what's being used.

Comma, Computer acronyms, Delimiter, Flat file, Merge, Spreadsheet terms