Convert CSV to JSON

What the JSON looks like

Each row becomes an object whose keys are the column names:

[
  { "order_id": 1001, "customer": "Ava Chen", "unit_price": 89.99 },
  { "order_id": 1002, "customer": "Liam Brooks", "unit_price": 14.5 }
]

Numbers stay numbers: QueryLocal detects each column's type from the data, so 89.99 is exported as a number, not as "89.99". Empty numeric cells become null.

Convert only what you need

The JSON export contains the result of the current query, not necessarily the whole file. Choose and rename fields as you go:

SELECT order_id AS id,
       customer AS name,
       quantity * unit_price AS total
FROM data
WHERE country = 'USA';

The download always contains every row of the result; the screen only shows the first 1,000.

Column names

Headers are turned into safe keys: accents removed, spaces and symbols replaced by underscores (Date de création becomes Date_de_creation). Use AS in the query to choose any other name.

Other free CSV tools

Frequently asked questions