Recipe 04: Convert between CSV, TSV, and NDJSON

Current version: 3.1.0

Goal

Convert between CSV and TSV, and output NDJSON for streaming pipelines.

CSV <-> TSV (Node.js)

const { csvToJson, jsonToCsv } = require('jtcsv');

const csv = 'id,name
1,Jane
2,John';
const rows = csvToJson(csv, { delimiter: ',' });

const tsv = jsonToCsv(rows, { delimiter: '	', includeHeaders: true });
console.log(tsv);

CSV -> NDJSON (CLI)

npx jtcsv csv-to-ndjson data.csv output.ndjson --stream

Notes

• For NDJSON in code, use jsonToNdjsonStream or the CLI.

Navigation

• Previous: Transform CSV (rename, filter, map)
• Next: Performance for large files