About Data Converter

Data Converter moves tabular data between the formats that tools actually use. Load a CSV and write JSON, load an XLSX sheet and write NDJSON for a log pipeline, or go the other way. Along the way you can filter to the rows you want, join a second file on a shared column, and drop duplicate rows.

The files are parsed in the page with the browser File API. Nothing is uploaded.

How to use it

  1. Open the source file. CSV, TSV, JSON, NDJSON, and XLSX are read.
  2. Check the parsed table. Set the delimiter or the sheet if it guessed wrong.
  3. Filter rows by a column value, or dedupe on one or more key columns.
  4. To join, open a second file and pick the column the two share.
  5. Choose the output format and download.

Common questions

Does it read every sheet in an XLSX?

It reads one sheet at a time. Pick the sheet after loading the workbook.

How is the CSV to JSON shape decided?

Each row becomes an object keyed by the header names. NDJSON writes one such object per line; JSON writes an array.

What kind of join is it?

An inner or left join on a single key column. Rows with no match are kept or dropped depending on the setting.

Is my data sent to a server?

No. Parsing, joining, and conversion all run in the tab.

Will large files work?

Files up to a few hundred thousand rows are fine on a typical machine. The whole file is held in memory.