{,} MomentA guide to tidy data

FROM ROWS TO RECORDS

A different format.
The same information.

Move a small table between CSV and JSON.
No uploads. No account. A little less manual work.

CSV & JSON converter

On your device

Up to 200,000 characters and 10,000 data rows. Some symbols count as two toward the character limit.

No output yet

No file uploads · No saved data · No hidden type guessing

KEEP THE STRUCTURE CLEAR

Tables and objects.
Two views of your data.

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.

Let quotes do their job

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.

Choose a flat shape

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.

A SMALL EXAMPLEname,code
Alex,00123

CSV 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.

A few details worth keeping.

What happens to missing values and types?

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.

Can large IDs lose digits?

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.

What does spreadsheet protection change?

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.

Which CSV dialect is supported?

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.

Is my data saved or uploaded?

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.