Formats/CSV
What Is a CSV File? The Simple Data Format Explained
CSV stands for Comma-Separated Values, and it is about as simple as a file format gets: a plain-text file where each line is a row of data and commas separate the columns. It has no formatting, no formulas, no colors, no fonts — just the raw values. That radical simplicity is exactly why CSV is the universal language for moving tabular data between programs that otherwise share nothing.
What a CSV file looks like
Open a CSV in a text editor and you will see something like: a first line of column headers such as `name,email,age`, followed by one line per record like `Alex,[email protected],34`. Each comma marks a boundary between fields, and each new line marks a new row. That is essentially the whole format. When a value itself contains a comma, it is wrapped in double quotes so the comma inside is not mistaken for a column break.
Because it is just text, a CSV can be created and read by practically anything — spreadsheets, databases, programming languages, analytics tools — with no special software and no licensing. It is the lowest common denominator that everyone agrees on.
Why CSV is everywhere
CSV is the default “export” and “import” format across the software world. Export contacts from an email service, download a bank statement, pull a report out of an analytics platform, or hand a dataset to a colleague using different software, and CSV is usually the option that just works. Its plain-text nature means it survives being emailed, version-controlled or opened decades from now, with no dependency on the program that made it.
It is also compact and fast to process, which makes it a favorite for large datasets and for feeding data into scripts and programs.
The quirks to watch for
CSV’s simplicity is also its weakness. Because it carries no type information, a spreadsheet program opening a CSV has to guess: it may turn a ZIP code like `01234` into the number `1234`, mangle a long ID into scientific notation, or misread dates in a different regional order. Not every “CSV” uses commas either — in regions where the comma is a decimal separator, files often use semicolons instead, and tab-separated (TSV) files are a close cousin.
There is also no single official standard for edge cases like line breaks inside a field or which character encoding to use, so a CSV that opens perfectly in one program can occasionally look garbled in another. Saving as UTF-8 and being deliberate about the separator avoids most of the trouble.
How to open and work with CSV
The easiest way to read or edit a CSV is in a spreadsheet: it parses the rows and columns into a familiar grid you can sort, filter and total. OfficePad’s spreadsheet editor opens CSV data in the browser and lets you export back to .xlsx when you need formulas and formatting, or keep it as a plain table. Because CSV is plain text, you can also open it in any text editor to inspect the raw values directly — useful when a file is not importing the way you expect and you want to see exactly what the separators and quoting look like.
Frequently asked questions
How do I open a CSV file?
Open it in a spreadsheet program, which lays the data out as rows and columns. OfficePad’s spreadsheet editor opens CSV in the browser and can export to .xlsx.
Why did my CSV mangle a ZIP code or ID?
CSV stores no type information, so spreadsheets guess and may treat a value like 01234 as the number 1234. Formatting the column as text, or importing rather than double-clicking, prevents it.
Are CSV files always comma-separated?
Not always. In some regions they use semicolons, and the closely related TSV format uses tabs. The separator depends on the software and locale that created the file.
Work with CSV on OfficePad
See also in the glossary: Character encoding, UTF-8, Metadata.