While Compass can output UTF-8 encoded CSV files, this request is to add a toggle to enable prepending the UTF-8 Byte Order Mark (BOM) to that output for legacy software. Ideally, this button would explain what this means when hovered over or with a (?) type icon.
This will be particularly helpful for those who need to produce Excel-compatible files at some point in the development cycle.
For other developers who stumble across this while Compass does not support it, you can open the file in Excel's import wizard, or use your favourite text editor. Opening a CSV file directly will often result in easy to miss encoding errors.
- In Notepad++, you would open the "Encoding" menu, select "UTF-8-BOM", then save the file.
- In VS Code/VS Codium, you can select the encoding in the bottom right of the window (which normally has the text "UTF-8"). Click the current encoding, select "Save with Encoding", then select "UTF-8 with BOM".