Our line-of-business software allows the user to save certain data as CSV. Since there are a lot of different formats (all called "CSV") in use in the wild, we are tying to decide what the "default format" should look like.
Regarding line/field separators and escaping, there is a standard we can use: RFC 4180.
Regarding text encoding, UTF-8 seems to have emerged in the last decade as the "default text file format", so we will use that.
The one question left open is: Should we add a BOM at the start or not? I have read multiple opinions and pros/cons on the use of BOMs in general, but is there an "official" recommendation or at least some kind of community consensus on the use of BOMs in CSV files?