Your data
Paste data above or choose a file. Everything stays in your browser.
Preview
Your table will appear here.
How to convert CSV to JSON or a Markdown table
- Paste your data into the box, drop a file onto it, or choose a
.csv,.tsv,.jsonor.mdfile. The format, delimiter and header row are detected automatically. - Check the preview table. If the columns look wrong, change the delimiter or the first-row setting under Reading.
- Optionally clean the data: trim stray spaces, remove empty rows or columns, drop duplicates or sort by any column. The preview and output update as you go.
- Pick an output tab (CSV, TSV, JSON or Markdown), then copy the result or download it as a file.
What each conversion does
| Conversion | What happens to your data |
|---|---|
| CSV to JSON | Each row becomes an object, using the header row as keys. Numbers, true/false and null become real JSON values, and columns like address.city become nested objects. ZIP codes and IDs with leading zeros stay text. |
| JSON to CSV | An array of objects becomes rows, with every key found in any object becoming a column. Nested objects flatten into dotted column names, and arrays are kept as JSON text in a single cell. If the array sits inside a wrapper like {"data": [...]}, it's found automatically. |
| CSV to Markdown | Builds a GitHub-flavored Markdown table with lined-up columns, right-aligned numbers, escaped pipe characters, and line breaks turned into <br>. It's ready to paste into a README, a GitHub issue or docs. |
| Markdown to CSV or JSON | Reads any pipe table, with or without outer pipes, and turns <br> back into line breaks. |
| CSV to TSV and back | Swaps the delimiter. Tabs or line breaks inside TSV values are replaced with spaces so every row stays on one line. |
CSV, JSON and Markdown converter FAQ
Is my data uploaded anywhere?
No. Parsing, cleaning and conversion all run in your browser. Nothing you paste or load is sent to a server, so it's safe for customer lists, exports and other private data.
Does it handle commas and line breaks inside values?
Yes. Values wrapped in double quotes can contain commas, line breaks and escaped quotes (""), following the standard CSV rules (RFC 4180). When the tool writes CSV, it adds quotes wherever a value needs them.
My CSV uses semicolons. Will it work?
Yes. Spreadsheets in many European locales export with semicolons because the comma is the decimal separator. The delimiter is detected automatically from comma, tab, semicolon and pipe, and you can set it by hand if the guess is wrong.
How does duplicate removal work?
Choose Entire row to drop rows that match another row exactly, or pick a column to keep only the first row for each value, such as one row per email address. With Ignore capitalization on, "Bob@Example.com" and "bob@example.com" count as the same value. The row count under the preview shows how many rows were removed.
Why do numbers sort correctly here when they don't in some tools?
Sorting compares numbers as numbers, so 9 comes before 10, and handles values like 1,250 or $19.99. Text sorts alphabetically with natural ordering, so "item 2" comes before "item 10". Empty cells always go last.
Will leading zeros like 00501 survive the conversion to JSON?
Yes. With Detect numbers on, a value only becomes a JSON number if converting it loses nothing, so ZIP codes, phone numbers and IDs with leading zeros stay as text. Very large numbers that JavaScript can't represent exactly also stay as text. Turn Detect numbers off to keep every value as a string.
How do I open the downloaded CSV in Excel without garbled accents?
Tick Excel-friendly download. It adds a small marker (a UTF-8 BOM) at the start of the file that tells Excel the text is UTF-8, so accented letters and symbols like é, ñ and € display correctly.