What is CSV?
A plain-English definition, and the tools that work with it.
CSV (Comma-Separated Values) is a plain-text format for tabular data: each line is a row and commas separate the columns. It's the simplest, most universal way to move spreadsheet data between programs, databases and code.
- Because it's plain text, almost every spreadsheet, database and programming language can read and write CSV.
- The 'comma' isn't guaranteed: some files use semicolons or tabs, which is the most common cause of a mangled import.
- CSV holds only values, not formatting or formulas. Convert it to JSON for code, or open it in a viewer when it's too big for a spreadsheet.
Tools for CSV
Free, private and in your browser. No sign-up.
CSV Viewer
View CSV files online as a fast, sortable spreadsheet, search across every cell, sort any column, and read a live per-column profile with row/column counts and numeric stats. Read-only, so you never touch the data. Nothing is uploaded.
CSV to JSON
Convert CSV to JSON in your browser. Paste or drop a.csv and get a clean array of objects or arrays with a header toggle, optional number/boolean type inference and pretty or minified output. Nothing is uploaded.
CSV Editor
Open, edit and clean CSV files in your browser as a real spreadsheet, fix cells, add or delete rows and columns, sort, find, and export to CSV, JSON or Excel. Nothing is uploaded.
Excel to CSV
Convert Excel to CSV in your browser. Drop an.xlsx or.xls, pick the sheet you want and download a clean, correctly-quoted CSV. Multi-sheet workbooks, commas inside cells and quoted fields are all handled. Nothing is uploaded.
CSV problems we solve
Hit one of these? Here's the fix.
Frequently asked questions
Keep exploring
Problems we solve
Definitions
From the blog
Common tasks
Try CSV Viewer
Free, private and instant. Everything runs in your browser.