Javascript to csv export encoding issue

Question

I need to export javascript array to excel file and download it I'm doing it in this code. data is a javascript object array.

var csvContent = "data:text/csv;charset=utf-8,"; data.forEach(function(dataMember, index) {     dataString = dataMember.join(",");     csvContent += index < data.length ? dataString+ "\n" : dataString; });   var encodedUri = encodeURI(csvContent); var link = document.createElement("a"); link.setAttribute("href", encodedUri); link.setAttribute("download", "upload_data" + (new Date()).getTime() + ".csv"); link.click(); 

All this stuff works fine till I have string properties that have non-english characters, like spanish, arabic or hebrew. How can I make an export with all this non-ASCII values?

Answer 1

You should add the UTF-8 BOM at the start of the text, like:

var csvContent = "data:text/csv;charset=utf-8,%EF%BB%BF" + encodeURI(csvContent); 

It worked for me with Excel 2013.

Demo Fiddle

Answer 2

You can add the BOM at first, use this code and try

var BOM = "\uFEFF";  var csvContent = BOM + csvContent; 

and then crate the file headers with the data: "text/csv;charset=utf-8"