Data Format Converter

JSON, YAML, CSV, TOML and JSONL, in any direction.

FREE - NO SIGN-UP - RUNS ON YOUR DEVICE

Runs in your browser tab

  • 5formats
  • 20directions
  • 0uploads
  • 1 tapto save
Specification

Data Format Converter at a glance

Formats
JSON YAML CSV TOML JSONL
Input
Pasted text
Output
Text, copy or download
CSV options
Delimiter and header switch
Nested data into CSV
Flattened to dotted paths
Errors
Sentence with the line number
Price
Free
Account needed
None
Where processing happens
On your device
How to

How to use Data Format Converter

  1. 1

    Choose the two formats

    Set from and to.

  2. 2

    Paste your data

    Paste over the sample.

  3. 3

    Copy or download

    Copy or download.

Questions

Frequently asked questions

Which directions are supported?

All of them. Any of JSON, YAML, CSV, TOML and JSONL converts into any other, and the two selectors move independently, so you are never locked to one pair.

What happens to nested data in CSV?

A table has no nesting, so every leaf becomes its own column named by its dotted path. An address object with a city field becomes a column called address.city.

Why does my CSV come out wrong?

Almost always the delimiter. Set it to comma, semicolon or tab to match the file, and check whether the first row really holds the field names.

Can TOML hold a plain list?

Not at the top level. TOML needs a named table there, so a list is written under a key called rows and the panel tells you it did that.

Is my data uploaded?

No. The parsers run in this browser tab and the text you paste is never sent to a server. Close the tab and nothing is left behind.

Background

Getting a clean conversion

Pick the format you have and the one you want. The result appears as you type, and a parse error tells you the line. Reverse puts the result back in the box so you can turn it straight back.

  • YAML is a superset of JSON, so valid JSON can be read as YAML too.
  • JSONL wants a list at the top level: one complete JSON value on each line.
  • Use Reverse to convert the result back and check that nothing was lost.
  • Numbers and true or false in CSV are read as numbers and booleans, not as text.

Full specification

Specification of the Data Format Converter tool
FormatsJSON, YAML, CSV, TOML and JSONL, in either direction between any pair.
InputPasted text, with a sample already loaded for whichever format you choose.
OutputThe converted text, with a copy button and a download in the right extension.
CSV optionsComma, semicolon or tab, and a switch for whether the first row holds headers.
Nested data into CSVFlattened to one column per leaf, named by its dotted path: address.city, not address.
ErrorsReported as a sentence naming the line and, where the format gives one, the column.
PriceFree. Supported by clearly labelled ads outside the working area.
Account neededNo.
Where processing happensIn your browser tab. Nothing is uploaded.
Next step

Keep going with the same files

All developer tools: Developer tools on SPOTTOOLS