How to export JavaScript array info to csv (on client side)?

You can do this in native JavaScript. You’ll have to parse your data into correct CSV format as so (assuming you are using an array of arrays for your data as you have described in the question):
const rows = [
[“name1”, “city1”, “some other info”],
[“name2”, “city2”, “more info”]
];

let csvContent = “data:text/csv;charset=utf-8,”;

rows.forEach(function(rowArray) {
let row = rowArray.join(“,”);
csvContent += row + “rn”;
});

or the shorter way (using arrow functions):
const rows = [
[“name1”, “city1”, “some other info”],
[“name2”, “city2”, “more info”]
];

let csvContent = “data:text/csv;charset=utf-8,”
+ rows.map(e => e.join(“,”)).join(“n”);

Then you can use JavaScript’s window.open and encodeURI functions to download the CSV file like so:
var encodedUri = encodeURI(csvContent);
window.open(encodedUri);

Edit: If you want to give your file a specific name, you have to do things a little differently since this is not supported accessing a data URI using the window.open method. In order to achieve this, you can create a hidden DOM node and set its download attribute as follows:

var encodedUri = encodeURI(csvContent);
var link = document.createElement(“a”);
link.setAttribute(“href”, encodedUri);
link.setAttribute(“download”, “my_data.csv”);
document.body.appendChild(link); // Required for FF

link.click(); // This will download the data file named “my_data.csv”.

Based on the answers above I created this function that I have tested on IE 11, Chrome 36 and Firefox 29
function exportToCsv(filename, rows) {
var processRow = function (row) {
var finalVal = ”;
for (var j = 0; j < row.length; j++) { var innerValue = row[j] === null ? '' : row[j].toString(); if (row[j] instanceof Date) { innerValue = row[j].toLocaleString(); }; var result = innerValue.replace(/"/g, '""'); if (result.search(/("|,|n)/g) >= 0)
result = ‘”‘ + result + ‘”‘;
if (j > 0)
finalVal += ‘,’;
finalVal += result;
}
return finalVal + ‘n’;
};

Related