Exporting a spreadsheet or database table to CSV is easy; getting that data into a shape that a JSON
API, a JS test fixture, or a config file can consume usually means a manual conversion step. This
recipe does it in two: convert, then format.
What each step does
Convert CSV to JSON.CSV to JSON reads the first row as field names and
turns every following row into one JSON object, auto-detecting comma/tab/semicolon/pipe
delimiters.
Re-format the result.JSON Formatter re-indents the output to a
specific width, independent of whatever the converter's own default produced.
Try it
Paste a CSV (with a header row) into the input above (a small sample is pre-filled) and the
pipeline runs live: the intermediate JSON array appears under the first step, and the final,
re-indented result shows in the Output panel.
When this is useful
A spreadsheet export handed off to a frontend team, a CSV dump that needs to become a JS test
fixture, or a small config table maintained in a spreadsheet but consumed as JSON at build time.
All the same shape of problem: tabular source data, JSON-consuming destination. This recipe keeps
the conversion visible and repeatable instead of a one-off paste into two separate tool tabs.
Frequently asked questions
CSV to JSON's own pretty toggle controls its output at conversion time. Chaining a second, dedicated formatting step lets you pin an exact indent width regardless of the converter's default, and makes the indent visible and editable as its own pipeline step.
Leave delimiter on auto; CSV to JSON sniffs the first line and picks the right one. You can also pin it explicitly (comma, tab, semicolon, pipe) if auto-detection ever guesses wrong on an unusual file.
Yes. The first row is treated as field names, and each subsequent row becomes one JSON object keyed by those names.
Yes. Open it in the recipe builder, paste your own CSV in place of the sample input, and use Save recipe to keep your own copy in your local recipe library.