Convert a JSON object to CSV

json2csv.js

import { flatten, keys, startCase, uniq } from 'lodash';


const json2csv = (rows = []) => {
    const columns = parseCSVColumns(rows);
    return [parseCSVHeaders(columns), ...rows.map(row => parseCSVRow(row, columns))].join('\n');
};

const escapeCSVString = (str = '') => {
    const value = str ? JSON.parse(JSON.stringify(str)) : '';
    return `"${value.replace(/(\r\n|\n|\r)/gm, '').replace(/"/g, '"""')}"`;
};

const parseCSVColumns = (rows) => uniq(flatten(rows.map(keys)));

const parseCSVHeaders = (columns) => columns.map(column => `"${startCase(column)}"`).join(',');

const parseCSVRow = (row, columns) => columns.map(key => escapeCSVString(row[key])).join(',');


export default json2csv;