power-csv

Handle CSV with power

Features

• Fast and powerful (based on PapaParse)
• Handles nested CSV
• Extends Express response (res.csv)
• Sane defaults
• Dynamic typing (automatically cast integers et al)

Install

npm i power-csv

Usage

Convert CSV to JSON

import { csv2json } from 'power-csv';

const csv = 'field;object.field;object.anotherField;object.numericField;array.0;array.1;array.2\r\nfoo;bar;foo;123;1;2;foo\r\nbar;;;456;3;4;bar';
const json = csv2json(csv);

// [
//   {
//     field: 'foo',
//     object: {
//       field: 'bar',
//       anotherField: 'foo',
//       numericField: 123,
//     },
//     array: [1, 2, 'foo'],
//   },
//   {
//     field: 'bar',
//     object: {
//       field: '',
//       anotherField: '',
//       numericField: 456,
//     },
//     array: [3, 4, 'bar'],
//   },
// ]

Convert JSON to CSV

import { csv2json } from 'power-csv';

const json = {
  foo: 'bar',
  bar: {
    foo: 'bar',
  },
};
const csv = json2csv(json);

// foo;bar.foo\r\nbar;bar

Express middleware

import csv from 'power-csv';
import express from 'express';

const app = express();

app.use(csv);

app.get('/convert-to-csv', (req, res) => {
  res.csv({foo: bar}, 'filename.csv');
});

License

MIT © Gowento