CSV Converter

Convert CSV or TSV into JSON, XML, SQL, an HTML or Markdown table, or another delimiter. Quoted fields, embedded commas and line breaks are handled correctly. Nothing is uploaded.

How to convert CSV

  1. Paste CSV or TSV, or copy a range of cells from Excel or Google Sheets (they paste as tab-separated text).
  2. Pick the output in Convert to. The delimiter is detected automatically from the first lines; override it for unusual files.
  3. Click Convert, check the preview table, then Copy or Download the result.

Each output has a shareable link: CSV to JSON, CSV to XML, CSV to SQL, CSV to HTML table, CSV to Markdown, CSV to TSV, and for tab-separated input TSV to CSV and TSV to JSON.

Parsing that survives real files

Spreadsheet exports are rarely clean, so the parser follows RFC 4180, the CSV standard: a field in double quotes may contain the delimiter ("Hopper, Grace"), a doubled quote stands for one quote ("Alan ""Prof"" Turing"), and a quoted field may even span several lines. A UTF-8 byte-order mark from Excel is removed, Windows and Unix line endings both work, blank lines are skipped and short rows are padded so every record has the same columns. Duplicate or empty header names are made unique (name, name_2, column_3) so no value is overwritten in JSON.

What each output looks like

From this input:

id,name,active
1,"Hopper, Grace",true
2,Ada,false
OutputResult
JSON[{"id": 1, "name": "Hopper, Grace", "active": true}, ...] with numbers and booleans typed (values with leading zeros such as ZIP codes stay strings; untick Detect numbers to keep everything as text)
XML<records><record><id>1</id><name>Hopper, Grace</name>...; the root comes from Table / root name, header names are made into valid element names
SQLA CREATE TABLE with INTEGER, NUMERIC, BOOLEAN or TEXT columns inferred from the data, then one INSERT per row with quotes escaped ('O''Brien') and empty cells as NULL
HTML table<table> with <thead> and <tbody>, all values HTML-escaped
MarkdownA GitHub-flavoured table; pipes are escaped and line breaks become <br>
TSV / CSVChange the delimiter: TSV replaces tabs and line breaks inside values with spaces; CSV re-quotes only the fields that need it
One record per blockid: 1, name: Hopper, Grace... one block per row, easy to read or paste into notes

Tips

FAQ

Is my CSV uploaded?

No. Parsing and conversion run in your browser, so you can convert customer exports and other private data safely.

Will ZIP codes and IDs keep their leading zeros?

Yes. Values such as 02134 are never turned into numbers, because that would change them. Untick Detect numbers to keep every value, including plain numbers, as text.

Which SQL dialect is generated?

Standard SQL with double-quoted identifiers, which PostgreSQL, SQLite and Oracle accept as is. For MySQL, enable ANSI_QUOTES or replace the double quotes around names with backticks.

How big a file can it handle?

Tens of thousands of rows convert in well under a second on a laptop; the preview shows the first 50 rows to keep the page responsive.