Please allow "compose CSV" step to specify encoding (or add a BOM)

[Rachael]

Hi, 

I have a recipe that creates a csv file from JSON and emails it as an attachment. 
The intended recipient is a windows user, so the attachment is opened in excel by default. 

Excel defaults to ANSI, so quite a few of the accented letters come out in weird characters, and there is no opportunity to specify it. 

In the Parse Json action, there is field that allows the recipe to specify the encoding if required, could you add a similar option the compose CSV. If I could add a UTF-8 BOM to the file it would solve all my problems. 

[gary1 · Accepted solution]

You can try to use .as_utf8 on your CSV output, or you can encode the UTF-8 BOM marker manually like this:

"\xEF\xBB\xBF" + [csv output]

[Rachael]

pure gold - amazing gary1, thank you!