Export 100000 rows to CSV in Javascript

Question

I have 100 000 lines and i want to export them to CSV, i did manage to export it for few lines but many thousands of lines return network error to my browser and i cannot download it.

        let csvContent = "data:text/csv;charset=utf-8,";
        csvContent += [
            Object.keys(payload[0]).join(";"),
            ...payload.map(item => Object.values(item).join(";"))
        ]
            .join("\n")
            .replace(/(^\[)|(\]$)/gm, "");

        const data = encodeURI(csvContent);
        const link = document.createElement("a");
        link.setAttribute("href", data);
        link.setAttribute("download", "export.csv");
        link.click();

I think you have to work with `wait time out to take back response from server` — Dupinder Singh, Jun 25 '19 at 01:21
Possibly this solution, using a Blob, might help? https://stackoverflow.com/a/35251739/11683772 — Mark, Jun 25 '19 at 01:25
it does not show an error but it does not download it, i think because javascript cannot handle that amount of data ? — Zouheir lin, Jun 25 '19 at 01:28

score 1 · Accepted Answer · answered Jun 25 '19 at 01:57

You can not encodeURI with 100000 rows

Use FileSaver.js

var blob = new Blob([csvContent], {type: "text/plain;charset=utf-8"});
saveAs(blob, "export.csv");

Maybe also split the string with Blob.slice() and save several chunks.

Export 100000 rows to CSV in Javascript

1 Answers1