Setting the BOM on write

[bizarrochris]

Hi, we use the npm module to create csv exports and are generally very happy, however we still have the issue with utf-8 encoding, that excel does not recognise the files as utf-8 immediately.

According to: http://stackoverflow.com/questions/155097/microsoft-excel-mangles-diacritics-in-csv-files
adding the BOM would be the quickest fix.
Is there a way to add this to the stream. Our code looks like this (we use express.js):

const csvOptions = {
            headers: true,
            delimiter: ';',
            transform: function(entry) {
//do stuff
            }
          };
          response.set('Content-Type', 'text/csv; charset=utf-8');
          response.set('Content-Disposition', 'attachment; filename="export.csv"');
          csv.write(transactions, csvOptions).pipe(response);

If there is no way to do it, an option would be amazing to set the BOM.
Thx in advance.

[dustinsmith1024]

I am not quite sure how to do this. Maybe you can do it like adaltas/node-csv#84 (comment)?

You might have to make an extra stream and pipe one through the other though. Maybe someone else can provide a better example.

[dustinsmith1024]

Or see: keystonejs/keystone#748 (comment)

[bizarrochris]

Thank you for the options - will check them out asap.
However, having a BOM in the options, and adding the BOM to the document in the background) would still make a lot of sense inmho.

[harryluo91]

Hi @bizarrochris did you find a way to work around this? We are also having the same issue but couldn't get it working with a stream.

[doug-martin]

Added in v3.4.0 there is a new option called writeBOM that you can set to true to have the BOM character written.