# Problem to open with excel with csv file generated from nodered

**URL:** <https://discourse.nodered.org/t/problem-to-open-with-excel-with-csv-file-generated-from-nodered/60887>\
**Category:** General\
**Tags:** function-node\
**Created:** [6 April 2022 15:09 UTC](https://discourse.nodered.org/t/problem-to-open-with-excel-with-csv-file-generated-from-nodered/60887 "2022-04-06T15:09:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![bertaud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bertaud/32/80981_2.png) [@bertaud](https://discourse.nodered.org/u/bertaud)\
**Post date:** [6 April 2022 15:09 UTC](https://discourse.nodered.org/t/problem-to-open-with-excel-with-csv-file-generated-from-nodered/60887/1 "2022-04-06T15:09:02Z")

</div>

i have a problem with a flow. I use a file node to save a csv content on disk  
i use utf8 encoding  
if i open the file with notepad the content is ok and character with accent are well displayed.  
if i open with excel directl i observed excel change the character with accent.  
i understand to solve this issue the encoding used should be utf8 with bom but this format is not available in nodered file node .  
Is there a fix for this ?

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [6 April 2022 16:22 UTC](https://discourse.nodered.org/t/problem-to-open-with-excel-with-csv-file-generated-from-nodered/60887/2 "2022-04-06T16:22:50Z")

</div>

What version of Node-red are you running?  
UTF8 is an option for the file-out node on my Node-red v2.2.0

An example of text saved using that option:

```auto
Icaraí é um bairro da área

```

---

<div class="post-metadata">

**Author:** ![bertaud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bertaud/32/80981_2.png) [@bertaud](https://discourse.nodered.org/u/bertaud)\
**Post date:** [6 April 2022 16:38 UTC](https://discourse.nodered.org/t/problem-to-open-with-excel-with-csv-file-generated-from-nodered/60887/3 "2022-04-06T16:38:03Z")

</div>

sure but utf8 option is not enough...  
to be able to open the file directl in excel with need to be able to save with format utf8 with BOM.

the paliative solution i have put in place is a function node before to download the file  
var stringutf8 = msg.payload  
var universalBOM = "\uFEFF";  
msg.payload= universalBOM+stringutf8  
return msg;

But i think it can be usefull to have utf8 with BOM format in the list for encoding

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [6 April 2022 16:44 UTC](https://discourse.nodered.org/t/problem-to-open-with-excel-with-csv-file-generated-from-nodered/60887/4 "2022-04-06T16:44:07Z")

</div>

OK. I don't have Excel, my CSV imports fine into LibreOffice Calc.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [5 June 2022 16:44 UTC](https://discourse.nodered.org/t/problem-to-open-with-excel-with-csv-file-generated-from-nodered/60887/5 "2022-06-05T16:44:39Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.