Nelvumo TableOpen workspace

CSV to JSON

Convert a CSV to JSON

A developer or a tool asks for JSON and you have a spreadsheet. Save it as a list of records, keyed by the headings.

Open workspace

When this helps

Use this to hand data to a web tool or a script, or to check a JSON export. JSON files can be opened too, when they hold a list of records.

For example

A task you can finish here

A price list with headings id, name and price saved as JSON objects: [{"id": 1, "name": "Kalo", "price": 2.5}, …]; codes with leading zeros stay strings.

The workflow

Three clear steps

  1. 01

    Open the sheet

    Check that the first row is the headings; switch it in Edit if not.

  2. 02

    Choose the shape

    In Save, choose JSON, then objects keyed by heading or arrays with the headings first.

  3. 03

    Save a copy

    Repeated headings get “ (2)”, empty ones “Column 4”, so every key is unique.

Your files and the public site

Open files only in the separate Table workspace. Its processing runs in your browser; this public site does not receive your files, their names, what they contain or any setting.Read the privacy information.

Questions

Can it read nested JSON?

It reads a list of records; a nested value is kept as its JSON text in one cell. Other JSON is refused with the reason.

Convert a CSV to ExcelClean a CSV

Ready to make the copy?

Your files stay unchanged.

Open workspace