Data Converter help

Move a table between formats and change its shape on the way. Turn an API's nested JSON into a flat CSV. Pull two exports together on a shared key. Drop the columns you do not need.

Steps

  1. Drop one file, or two if you want to join them. The type is detected from the name and the content.
  2. Flatten nested JSON if you need to. Keys become dotted paths like user.address.city. Arrays become a JSON string in the cell.
  3. Shape the table: filter rows, sort, pick and rename columns, set a row limit.
  4. Join the second file by choosing the key column on each side and the join type.
  5. Pick an output format and export. The recipe log shows every step you applied.

Formats

Reads

CSV, TSV, JSON, NDJSON, XLSX.

Writes

CSV, TSV, JSON, NDJSON, XLSX.

Limits

Files are parsed in your browser. Nothing is uploaded.

Back to Data Converter