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
- Drop one file, or two if you want to join them. The type is detected from the name and the content.
- Flatten nested JSON if you need to. Keys become dotted paths like
user.address.city. Arrays become a JSON string in the cell. - Shape the table: filter rows, sort, pick and rename columns, set a row limit.
- Join the second file by choosing the key column on each side and the join type.
- 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
- Parquet and SQLite are not supported. They need a database engine compiled to WebAssembly, which is on the list.
- There is no SQL box. Filtering, sorting, and joining are done through the controls.
- Very large files run on the main thread. A gigabyte-scale file may be slow or run out of memory.
Files are parsed in your browser. Nothing is uploaded.
Back to Data Converter