Js to Csv

csv.js

// Usage:
// const records = [['James', '[email protected]'], ['Steve', '[email protected]']];
// const titles = ['name', 'email'];
// generateCsv(records, titles);

// RFC 4180
// Fields containing line breaks (CRLF), double quotes, and commas should be enclosed in double-quotes.
const formatValue = value => {
  const chars = [',', '"', '\n'];
  const mustBeEnclosed = chars.some(c => value.includes(c));

  return mustBeEnclosed ? `"${value}"` : value;
}

// With an array, create a formatted csv string.
const createRow = rowData => {
  if (!rowData) {
    return '';
  }

  return rowData
    .map(col => col.toString())
    .map(formatValue)
    .join(',') + '\n';
};

const generateCsv = (data, titles) => {
  const meta = 'data:text/csv;charset=utf-8,';
  const headers = createRow(titles);

  if (!data || data.constructor !== Array || data[0].constructor !== Array) {
    console.warn('You must pass in nested arrays to generate csv data.');
    return meta + 'Error generating csv data\n';
  }

  const rows = data.map(createRow);

  return meta + headers + rows.join('');
};

export default generateCsv;