CSV to JSON

OSCC · JavaScript, String, Object · Jan 30, 2022

Converts a comma-separated values (CSV) string to a 2D array of objects. The first row of the string is used as the title row.

const CSVToJSON = (data, delimiter = ',') => {
  const titles = data.slice(0, data.indexOf('\n')).split(delimiter);
  return data
    .slice(data.indexOf('\n') + 1)
    .split('\n')
    .map(v => {
      const values = v.split(delimiter);
      return titles.reduce(
        (obj, title, index) => ((obj[title] = values[index]), obj),
        {}
      );
    });
};
CSVToJSON('col1,col2\na,b\nc,d');
// [{'col1': 'a', 'col2': 'b'}, {'col1': 'c', 'col2': 'd'}];
CSVToJSON('col1;col2\na;b\nc;d', ';');
// [{'col1': 'a', 'col2': 'b'}, {'col1': 'c', 'col2': 'd'}];

Recommended snippets

  • CSV to array

    JavaScript, String

    Converts a comma-separated values (CSV) string to a 2D array.

  • JSON to CSV

    JavaScript, Array

    Converts an array of objects to a comma-separated values (CSV) string that contains only the columns specified.

  • HSL to object

    JavaScript, String

    Converts an hsl() color string to an object with the values of each color.