CSV Converter
A table as plain text: the lowest common denominator that every spreadsheet, database and script can read.
25 tools
Convert to CSV
Convert from CSV
Other CSV operations
Why CSV survives everything
There is no version, no vendor and no binary layout. A CSV is rows of text with a separator, and that is the whole specification. Any tool written in the last forty years can read one, which is why data leaves every serious system as CSV and enters every other system the same way. What it does not carry is anything beyond the values: no formatting, no formulas, no cell types, no multiple sheets. Exporting a spreadsheet to CSV keeps the numbers and loses the workbook.
The three things that break CSV files
Separators, encodings and quoting. Much of Europe writes CSV with semicolons because the comma is the decimal point; a file saved that way opens as one long column elsewhere. Encoding is worse: a file saved as Windows-1251 or Latin-1 shows names as mojibake in a UTF-8 world, and Excel needs a byte-order mark before it will admit a UTF-8 file is UTF-8. And any value containing a comma, a quote or a line break has to be quoted correctly or the row silently splits. The tools here handle all three explicitly rather than guessing once and failing quietly.
CSV, JSON and Excel
Convert to JSON when the data has structure that a flat table cannot express: nested objects, arrays, optional fields. Convert to Excel when a person rather than a program is going to read it, since XLSX keeps types, widths and multiple sheets. Stay in CSV when the next step is a script, a database import or a system you do not control: it is the format least likely to need explaining.
Opening a CSV in Excel without broken columns and dates
Excel splits a CSV by the list separator of your Windows region, not by looking at the file, so a comma-separated export opens as one long column on a European machine and a semicolon file does the same in the US. The lasting fix is to stop opening CSVs directly: CSV to Excel reads the separator from the file itself, keeps leading zeros and long numbers as text, and writes a real .xlsx with proper columns. Going the other way, Excel to CSV lets you pick the delimiter, the encoding (UTF-8 with or without the byte-order mark that Excel expects) and one fixed date format, so the same file does not look different on every machine that opens it.
Frequently asked questions
Why does my CSV open in one column in Excel?
The file uses a different separator from the one your Windows region expects: commas on a machine set to semicolons, or the reverse. Convert it with CSV to Excel, which detects the separator from the file, or use Excel's import wizard instead of double-clicking.
How do I keep leading zeros in a CSV?
Do not let the spreadsheet guess types. Codes like 00123 and long identifiers must stay text; the CSV to Excel and CSV to JSON conversions here keep them as text and only convert values that are really numbers.
What is the difference between CSV and XLSX?
CSV is plain text with one table and no formatting, formulas or types; XLSX is a full workbook with sheets, column widths, formulas and real dates. Send CSV to programs and imports, XLSX to people.