function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Noelia MarinNoelia Marin 

Export to csv - UTF-8

I exporting data to csv but when I read Excel file I see these characters:

Número factura
Logística
�rea factura

My code, controller:

var hiddenElement = document.createElement('a');         
hiddenElement.href = 'data:text/csv;charset=utf-8,' + encodeURIComponent(csvStringResult);
hiddenElement.target = '_self';

What should I do to see the characters correctly?

Thanks,

Noelia
Raj VakatiRaj Vakati
try this
  
var hiddenElement = document.createElement('a');
    hiddenElement.href = 'data:text/csv;charset=utf-8,' + encodeURIComponent(csvStringResult);
    hiddenElement.target = '_blank';
    hiddenElement.download = 'example.csv';

 
Noelia MarinNoelia Marin
I have tried but is has not worked:

var hiddenElement = document.createElement('a');         
hiddenElement.href = 'data:text/csv;charset=utf-8,' + encodeURI(csvStringResult);
hiddenElement.target = '_blank';
var rightNow = new Date(); var fileName = objectName.split("__c").join("") + "_" + rightNow.toISOString().slice(0,19).replace(/-|:|T/g,"");
                                
hiddenElement.download = fileName+".csv";
document.body.appendChild(hiddenElement);
hiddenElement.click();
Noelia MarinNoelia Marin
I solved my problem. I include %EF%BB%BF near the utf-8.

var hiddenElement = document.createElement('a');         
                hiddenElement.href = 'data:text/csv;charset=utf-8,%EF%BB%BF' + encodeURI(csvStringResult);
                hiddenElement.target = '_self'; // 
ItruItru
Thanks @Noeila! Very helpful solution! I spent hours on the web trying to find a solution for this issue.