topic Re: Please allow "compose CSV" step to specify encoding (or add a BOM) in Workato Pros Discussion Board

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

Rachael — Thu, 08 May 2025 05:39:05 GMT

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.

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

gary1 — Thu, 08 May 2025 17:58:52 GMT

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]

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

Rachael — Mon, 12 May 2025 12:48:52 GMT

pure gold - amazing gary1, thank you!