Share:
Glossary Data & Encoding

CSV

CSV (comma-separated values) is a plain-text format for tables, with one row per line and values separated by commas.

Last reviewed:

AdSense Placeholder
Slot: header_reference_page

In more detail

Values containing commas, quotes or line breaks are wrapped in double quotes, and quotes inside are doubled. Some regions use semicolons because the comma is their decimal mark. CSV has no types, so spreadsheet programs may guess wrongly, for example dropping leading zeros from ZIP codes.

Try these tools

CSV to JSON Converter

Convert Comma Separated Values (CSV) to structured JSON data easily.

JSON to CSV Converter

Flatten JSON arrays into Comma Separated Values (CSV).

CSV to SQL Converter

Paste CSV and get a CREATE TABLE with inferred column types plus batched INSERT statements for PostgreSQL, MySQL, SQLite or SQL Server.

See also

  • Glossary JSON
    JSON (JavaScript Object Notation) is a lightweight text format for structured data, built from objects, arrays, strings, numbers, true.
  • Glossary MIME type
    A MIME type (media type) names the format of content as type/subtype, such as text/html or image/png, so software knows how to handle it.
Back to Glossary
AdSense Placeholder
Slot: footer_leaderboard