3-part carbonless set · white · canary · pink

JSON to YAML/CSV Converter

Write on any sheet and the other two copies take the impression: JSON on the white original, YAML on the canary copy, CSV on the pink one. Tear off the copy you want and it is on your clipboard.

CSV delimiter
Data transfer set · form 3PNo. 000001
Original · white · JSONSave .json
FormatJSONRecords0Bytes0

Copy 1 · canary · YAMLSave .yaml
FormatYAMLRecords0Bytes0

Copy 2 · pink · CSVSave .csv
FormatCSVRecords0Bytes0

One record, three copies

JSON, YAML and CSV describe the same data three ways. JSON is what programs exchange; YAML is what configuration files prefer, indentation instead of braces; CSV is what spreadsheets open. A carbonless form set works the same way: you write once on the top sheet and every copy underneath gets the impression, each on its own colour so the right one goes to the right desk. Here every sheet is writable. Paste into any of them and the other two are re-pressed as you type.

What changes between formats

JSON to YAML is lossless. CSV is a flat grid, so nested objects are flattened into dotted columns (address.city) and arrays are written as JSON inside the cell; an object of objects becomes rows with a key column. Coming back from CSV, numbers and true/false are typed, everything else stays a string. Delimiters are detected from the first line (comma, semicolon or tab) unless you pick one.

Why is my CSV sheet stamped VOID?

The sheet you typed on did not parse, so nothing was pressed through. The line under the header says what went wrong; the other two sheets keep their last good copy.

How much YAML does it understand?

The YAML that configuration files use: nested maps and lists, quoted and plain scalars, comments, block scalars with | and >, and simple flow collections like [a, b]. Anchors, tags and multi-document files are not supported.

Can I convert a CSV with a header row only?

Yes; you get an empty list. The first row is always read as the column names.

Is anything uploaded?

No. The whole form runs in your browser; nothing you paste leaves the page.

Carbonless · white, canary, pinkAll tools
Suggest an improvement