CSV TO JSON

Which JSON Shapes Can You Export?

• Array of objects: one object per row, with header names as keys. The most common shape for APIs and scripts.
• Array of arrays: one array per row, values in column order. Compact and order-preserving.
• JSON Lines: one object per line, with no surrounding array. Good for streaming and log tools.

Header names that are empty or repeated are made unique as keys, as column_N or name_2, so no value is overwritten by another column with the same name. Pretty print adds indentation for reading; leave it off for the smallest file.

How Are Numbers and True/False Detected?

Detect numbers and true/false decides column by column. A column becomes numbers only if every value in it is a plain number. That is why ZIP codes such as 00501 stay as text: one leading zero is enough to keep the whole column as strings, so no value is quietly changed. Empty cells can be written as null.

1. Clean money columns first with the column type converter, so $1,250.00 becomes 1250.
2. Turn on Detect numbers and true/false.
3. Turn on Empty cells as null if your code expects null rather than an empty string.
4. Check the live preview of the real first rows.

How Do You Go Back From JSON to CSV?

The reverse direction has its own page, JSON to CSV, which flattens nested objects into dotted column names. The same export bar also writes TSV and SQL, so one open file can become several formats in a row. For formats other than CSV and JSON, 2convert handles the conversion in the same browser-only way.

What Else Can You Do With a CSV Here?

• CSV viewer: Open a CSV of any size, scroll every row, and see a profile of each column.
• Sort CSV: Sort rows by one or more columns, as text, numbers, or dates, ascending or descending.
• Filter CSV: Show only the rows that match an expression such as price > 10 AND state = "NY".
• CSV validator: Find ragged rows, broken quotes, bad headers, encoding problems, and values of the wrong type.
• Remove duplicates from CSV: Find and remove duplicate rows, comparing whole rows or only the columns you choose.
• Trim CSV whitespace: Trim leading and trailing spaces, collapse double spaces, and drop invisible characters and empty rows.
• Find and replace in CSV: Find text in one column or every column and replace it, with match case, whole cell, and regex options.
• Remove rows from CSV: Delete rows by number or range, the first or last rows, empty rows, or rows that match a rule.
• CSV editor: Edit cells, add or delete rows, and add, delete, rename, or move columns.
• Split CSV column: Split one column into several at a delimiter, such as a full name into first and last.
• Merge CSV columns: Join two or more columns into one with the separator you choose, skipping empty values.
• CSV column type converter: Convert a column to clean numbers, ISO dates, true/false, or upper, lower, or title case.
• JSON to CSV converter: Convert a JSON array or JSON Lines to CSV, flattening nested objects into dotted column names.
• CSV to SQL converter: Turn a CSV into SQL INSERT statements, with an optional CREATE TABLE, for PostgreSQL, MySQL, SQLite, or SQL Server.
• CSV to TSV converter: Convert a comma-separated file to tab-separated values that paste cleanly into spreadsheets.
• TSV to CSV converter: Convert a tab-separated file to a standard, properly quoted comma-separated CSV.
• CSV splitter: Split a large CSV into smaller files of a set number of rows, with the header repeated in each.

All eighteen tools are on the 2csv home page, and once a file is open you can switch between them without reloading it. Part of the 2suite.io privacy-first ecosystem.