export html table to csv javascript

1function downloadCSV(csv, filename) {
2    let csvFile;
3    let downloadLink;
4
5    // csv file
6    csvFile = new Blob([csv], { type: 'text/csv' });
7
8    // Download link
9    downloadLink = document.createElement('a');
10
11    // File name
12    downloadLink.download = filename;
13
14    // Create a link to the file
15    downloadLink.href = URL.createObjectURL(csvFile);
16
17    // Hide download link
18    downloadLink.style.display = "none";
19
20    // Add the link to DOM
21    document.body.appendChild(downloadLink);
22
23    // Click download link
24    downloadLink.click();
25}
26
27function exportTableToCSV(filename, separator) {
28    const csv = [];
29    const rows = document.querySelectorAll("table tr");
30
31    for (let i = 0; i < rows.length; i++) {
32
33        let row = [];
34
35        const cols = rows[i].querySelectorAll("td, th");
36
37        for (let j = 0; j < cols.length; j++)
38            // Add double quote to make the value stay in the same column if is separated by comma
39            row.push(`"${cols[j].innerText}"`);
40
41        csv.push(row.join(separator));
42    }
43
44    // Download CSV file
45    downloadCSV(csv.join("\n"), filename);
46}
47
48document.querySelector('button').addEventListener('click', () => {
49    exportTableToCSV('filename.csv', ',');
50});