What does CSV stand for, and what is its purpose?

• A. XML; it is a shorthand for eXtensible Markup Language and is commonly used for structured data exports
• B. Commas Separated Values; it is a file format that separates data values with commas, allowing each value to be placed in unique cells in a spreadsheet
• C. Cross-Sectional Visuals; a charting format
• D. Comprehensive Summary View; a reporting layout

Answer: (B)

CSV stands for Comma-Separated Values, a simple plain-text format for tabular data. Each row represents a record, and within that row, fields are separated by commas so every value lands in its own cell when opened in a spreadsheet. The purpose is straightforward data exchange: you can export data from one program and import it into another with minimal fuss. Because it’s plain text, CSV is lightweight and widely supported by spreadsheets, databases, and analytics tools. It doesn’t carry formatting or complex features like multiple worksheets, but it reliably preserves the data structure, with quotes used to contain values that include commas.