What is a CSV file?
Learn how CSV plain text files store tabular data, how to solve delimiter or encoding errors, and when to convert raw datasets to XLSX or PDF documents. Free CSV converters included.
CSV stands for Comma-Separated Values, a universal data exchange format designed to transfer tabular information across incompatible systems. Before its emergence in the early 1970s, moving structured records between mainframe computers required custom binary parsers for each machine architecture. The format solved this friction by organizing data into plain text lines where commas separate distinct columns. Although businesses relied on these conventions for decades across diverse database systems, the Internet Engineering Task Force formally documented the standard in 2005 under RFC 4180 to establish consistent quoting and line-break rules.
Technically, a CSV file uses no built-in compression, transparency, or binary container structures. Every file consists entirely of raw text strings encoded in standards like UTF-8 or ASCII. Each physical line represents a single record, while commas or tabs divide individual fields. When a text field contains commas, quotation marks, or line breaks, standard parsers wrap that field in double quotation marks to preserve internal integrity. Because the format stores purely raw characters without styling, formulas, or cell formatting, ten thousand product rows typically consume only 2 to 5 MB of disk storage.
You encounter CSV files across virtually every digital workflow that handles structured information. Modern database engines, customer relationship management systems, and e-commerce marketplace panels export catalog data and financial logs as CSV records by default. Every desktop spreadsheet application, web browser, and data analytics environment on Windows, macOS, and Linux can parse and generate these files without specialized runtime libraries. Whether you migrate inventory numbers between retail platforms or prepare tabular metrics for statistical modeling, CSV remains the primary intermediate format for moving tabular records cleanly between applications.
Technical specification
| Extension | .csv, .tsv |
|---|---|
| MIME type | text/csv |
| Compression | None; plain text |
| Typical file size | Ten thousand product rows run to about 2-5 MB |
| Browser and system support | Every spreadsheet program, database and marketplace panel |
| Developed by / year | In use since the 1970s; RFC 4180, 2005 |
When to use it
- Choose this format when you need to transfer tabular data between different database engines or spreadsheet tools without compatibility barriers.
- Choose this format when exporting large inventory catalogs or user registries from web platforms to keep file sizes compact at roughly 2 to 5 MB per ten thousand rows.
- Choose this format when feeding structured datasets into automated command-line scripts or data analytics pipelines that process raw text rapidly.
- Choose this format when archiving raw numerical records that must remain readable across future computing platforms without requiring proprietary software.
When not to use it
- Avoid CSV when you need to preserve mathematical formulas, cell colors, or multi-sheet workbooks, and use XLSX instead.
- Avoid CSV when you must distribute read-only documents with fixed visual page layouts and printable formatting, opting for PDF instead.
- Avoid CSV when storing hierarchical nested structures or complex arrays with variable schemas, choosing JSON or XML instead.
Our tools for this format
5 tools that take CSV files in or write them out. Each one runs in your browser, so nothing is uploaded.
Convert from this format
Edit files in this format
Common problems
All my data loads into a single column instead of separate columns.
This happens when your spreadsheet application expects a comma but your file uses a semicolon or tab delimiter. You can resolve this by adjusting the delimiter settings during text import or using a separator repair tool to convert semicolons to standard commas. Once updated to match your system locale, the columns will populate correctly.
Special characters and accented letters appear as garbled symbols.
This character corruption occurs when a file saved in UTF-8 is opened by software defaulting to Windows-1252 or ANSI encoding. Save your file explicitly with UTF-8 character encoding and an optional byte order mark. Reopening the file under UTF-8 settings will restore every accented symbol and non-Latin character instantly.
Leading zeros in zip codes or identification numbers disappear automatically.
Spreadsheet programs automatically interpret numeric strings as integers and strip off starting zeros upon opening. To prevent this data loss, wrap numeric identifiers in double quotation marks or import the file through an import wizard configured to treat those specific columns as text. Converting the data structure to XLSX before sharing also protects leading zeros permanently.
Commas inside addresses and product descriptions split into extra columns.
Unquoted commas within text fields cause spreadsheet parsers to misidentify text as new column boundaries. Wrap any field containing commas, quotation marks, or line breaks inside standard double quotes according to RFC 4180. Alternatively, replace internal commas with alternative punctuation or convert your delimiter to tabs.
Frequently asked questions
What is the maximum file size or row limit for a CSV file?
The CSV format itself has no theoretical row or file size limit because it is raw text. However, standard spreadsheet applications often enforce a hard limit of 1,048,576 rows and 16,384 columns, while command-line tools and database parsers can process multi-gigabyte files with tens of millions of rows.
What is the difference between CSV and TSV files?
CSV files use commas to separate values, whereas TSV files use tab characters (ASCII code 9) as separators. TSV files prevent data splitting errors in text fields that frequently contain commas, though both formats follow identical plain text storage principles.
Can a CSV file contain multiple tabs or worksheets?
No, a CSV file can only store a single flat table of data per file. If your workbook contains multiple tabs, you must export each sheet into an individual CSV file or use multi-sheet formats like XLSX.
How much smaller is a CSV file compared to an XLSX file?
For raw tabular records without heavy metadata, a CSV file is often 30 to 50 percent smaller than an uncompressed XML workbook. A dataset of 10,000 basic product rows typically takes 2 to 5 MB in CSV format.
Can CSV files carry computer viruses or malicious executable macros?
CSV files contain pure plain text and cannot execute binary viruses or embedded macro scripts directly. However, spreadsheet software may execute formula injection if a cell starts with an equals sign, so always inspect untrusted files before opening.