Start with named columns
For CSV, the first row provides the JSON keys. Give every column a unique, nonblank name. A header and each data row must have the same number of fields.
FROM ROWS TO RECORDS
Move a small table between CSV and JSON.
No uploads. No account. A little less manual work.
No file uploads · No saved data · No hidden type guessing
KEEP THE STRUCTURE CLEAR
For CSV, the first row provides the JSON keys. Give every column a unique, nonblank name. A header and each data row must have the same number of fields.
A comma inside a field belongs inside double quotes. Write a double quote as two quotes inside that field. Quoted line breaks stay part of the cell, rather than starting a new row.
For JSON, use an array of objects with simple values. Columns include every key encountered, in first-seen order. Nested objects and arrays need to be flattened before conversion.
name,code
Alex,00123CSV values stay strings in JSON, so a code such as 00123 keeps its leading zeros. The converter does not guess whether a cell is a number or date.
CSV to JSON keeps every cell as text, including empty strings. JSON to CSV writes strings, numbers and booleans as text; null and missing fields become empty cells. CSV does not preserve JSON types. Duplicate JSON keys follow the usual last-value-wins behavior, so make keys unique before converting.
CSV text values are preserved. In JSON, put large identifiers and values requiring exact decimal representation in quotes. Unsafe integers and numbers outside the supported range are rejected. Ordinary JSON numbers use standard numeric precision and may lose insignificant formatting, such as trailing decimal zeros.
When enabled for JSON to CSV, cells starting with a formula marker such as =, +, - or @, or a leading tab or line break, receive an apostrophe. Headers are checked too. The change is visible in the output and may be retained by other software. It reduces common formula risks but cannot guarantee how every spreadsheet application will import a file. Inspect untrusted data before opening it.
Choose comma, semicolon or tab explicitly. Double quotes escape delimiters, quotes and line breaks. Windows and Unix line endings are accepted; output CSV uses Windows-style line endings. A trailing line ending is allowed. Blank rows count as rows and may fail the column-count check. Spaces in cells and nonblank header names are retained.
Your input and output stay in this browser tab. This page sends no entered data to a server and uses no storage, analytics or advertising scripts. Refreshing clears your work. The hosting provider may process connection information to serve and secure the page. Any future advertising will be disclosed before it is enabled.