Export csv with field names and using unicode character set
I have to generate .csv exports that are then uploaded to various websites. This requires that the first row contain the field names. I also have to maintain special characters within these exports. Exporting as a merge file includes the column names, but I cannot export using the Unicode (UTF-8) character set, which is the only one that consistently includes all the special characters I need to preserve. Exporting as a .csv lets me use Unicode, but it does not include field names.
Short of adding in a dummy row at the beginning of every export to replicate the column names, is there any way to do this?