Javascript to csv export encoding issue

javascript csv export-to-csv
Boltosaurus picture Boltosaurus · Oct 21, 2013 · Viewed 92.3k times · Source

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

Gergő Nagy picture Gergő Nagy · Jan 6, 2014

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";

It worked for me with Excel 2013.

Demo Fiddle

Related questions

Export JSON to CSV or Excel with UTF-8 (e.g. Greek) encoding using JavaScript

I am trying to export and download a JSON object to CSV file and I have problem with Greek characters. My code works; it is not perfect, but it works. The problem is that Greek characters looks like junk. Here …

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

I know there are lot of questions of this nature but I need to do this using JavaScript. I am using Dojo 1.8 and have all the attribute info in array, which looks like this: [["name1", "city_name1", ...]["name2", "city_name2", ...]] …

Read More
Example JavaScript code to parse CSV data

Where could I find some JavaScript code to parse CSV data?

Read More