line breaks in javascript generated csv for excel import

Question

I generate and download a CSV from a webpage using javascript in the browser side (chrome windows)

function toCsv(arr){
    return arr.reduce(function(csvString, row){
        csvString += row.join(',') ;
    csvString += "\r\n";  //";";//"\n";
        return csvString;
    }, '');
}

function flowDataCsv(){
    document.location = 'data:Application/octet-stream,' + toCsv(flowDataGrid);
}

i have tried delimiting lines with ";", "\r\n" and "\n" but all three results in csv:s that excel imports into one line instead of as a grid. How should i terminate the lines to get excel to recognize it as a line ending and start inserting data on a new line?

Lauren3110 · Accepted Answer · 2015-04-26 23:22:42Z

13

Not sure if you still need the answer to this question. But will post the solution I found as I experienced the same problem.

Using your code above the only thing you are missing is to encode your csv string returned by your toCsv function. This would look like this in your code above:

function toCsv(arr){
    return arr.reduce(function(csvString, row){
        csvString += row.join(',') ;
    csvString += "\r\n";  //";";//"\n";
        return encodeURIComponent(csvString);
    }, '');
}

function flowDataCsv(){
    document.location = 'data:Application/octet-stream,' + toCsv(flowDataGrid);
}

Hopefully this helps anyone who comes across this issue again in the future!

answered Apr 26, 2015 at 23:22

Lauren3110

1391 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ffguven Over a year ago

not converting \n to new line and distorts float values.

Jay Dharmendra Solanki Over a year ago

Thanks for the answer. I was trying to solve this issue but had no luck, but encodeURIComponent really worked.

Delphin Rukundo · Accepted Answer · 2018-12-26 14:30:34Z

3

Try \u2028 instead of \n or \u2029 in place of \r.

src: https://github.com/zemirco/json2csv/issues/91#issuecomment-276555551

answered Dec 26, 2018 at 14:30

Delphin Rukundo

312 bronze badges

1 Comment

Mohmmad S Over a year ago

could you explain why

Collectives™ on Stack Overflow

line breaks in javascript generated csv for excel import

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related