30-seconds-of-code/snippets/js/s/csv-to-array.md

title, type, language, tags, cover, dateModified

title	type	language	tags	cover	dateModified
CSV to array	snippet	javascript	string array	watermelon-bike	2022-01-30T12:14:39+02:00

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

• Use Array.prototype.indexOf() to find the first newline character (\n).
• Use Array.prototype.slice() to remove the first row (title row) if omitFirstRow is true.
• Use String.prototype.split() to create a string for each row.
• Use String.prototype.split() to separate the values in each row, using the provided delimiter.
• Omit the second argument, delimiter, to use a default delimiter of ','.
• Omit the third argument, omitFirstRow, to include the first row (title row) of the CSV string.

const CSVToArray = (data, delimiter = ',', omitFirstRow = false) =>
  data
    .slice(omitFirstRow ? data.indexOf('\n') + 1 : 0)
    .split('\n')
    .map(v => v.split(delimiter));

CSVToArray('a,b\nc,d'); // [['a', 'b'], ['c', 'd']];
CSVToArray('a;b\nc;d', ';'); // [['a', 'b'], ['c', 'd']];
CSVToArray('col1,col2\na,b\nc,d', ',', true); // [['a', 'b'], ['c', 'd']];