What is a .csv file?
A .csv file is a CSV document. Its registered MIME type is text/csv, which places it in the text family of formats.
CSV stands for Comma Separated Values.
Technically it is a specialised form of text/plain (the .asc format), so tools that understand that format can often read at least part of it.
CSV is a text-based format: the contents are readable characters, so any text editor can open it, and it compresses well.
CSV file format details
| Extension | .csv |
|---|---|
| Format | CSV document |
| MIME type | text/csv, text/x-comma-separated-values, text/x-csv |
| Category | Text |
| Text or binary | Text |
| Based on | text/plain |
| File signature | None fixed |
| Registered with IANA | Yes |
| Other extensions | None |
How to open CSV files
| Windows | CSV files are plain text, so Notepad opens them: right-click the file, choose Open with, then Notepad. Notepad++ and VS Code are free and show long files more comfortably. |
|---|---|
| Mac | TextEdit opens plain text files. For code or data files, a free editor such as BBEdit or VS Code keeps the formatting intact. |
| iPhone and iPad | Save the file to the Files app and tap it; iOS previews most plain text. Or drop it on the viewer above, which shows the text right in the browser. |
| Android | Most file manager apps open plain text files in a built-in viewer. The viewer above also works in Chrome. |
Convert CSV files
TapToConvert converts CSV files in your browser, without uploading them. Open the CSV converter, or go straight to a conversion:
CSV file FAQ
What is a .csv file?
A .csv file is a CSV document, with the MIME type text/csv.
How do I open a .csv file?
With any text editor, such as Notepad on Windows or TextEdit on a Mac, or with the viewer on this page.
Is a .csv file safe to open?
CSV files hold data rather than programs, but any file from an unknown source can be crafted to exploit the software that opens it. Keep that software up to date. The viewer on this page only reads the bytes and never runs anything.
What is the MIME type of .csv?
text/csv, and it is also seen as text/x-comma-separated-values or text/x-csv. Web servers send this type so browsers know how to handle the file.
Is CSV a text or binary format?
Text. Its contents are readable characters.
File type facts come from the IANA media type registry, the mime-db project and the freedesktop.org shared MIME database.