Write a CSV file using Ruby 2.2.2 which can open in Excel, properly displaying accents.

csv_for_excel.rb

require 'csv'
module DownloadService

  OPEN_MODE = "w+:UTF-16LE:UTF-8"
  BOM = "\xEF\xBB\xBF" #Byte Order Mark

  def student_list
   File.open("#{file_name}.tsv", OPEN_MODE) do |f|
      csv_file = CSV.generate({:col_sep => "\t"}) do |csv|
        # header row 
        csv << ['First_Name', 'Middle_Name', 'Last_Name']
        # put lots of rows in the csv file here
      end
      f.write BOM
      f.write(csv_file)
    end
  end
end
 

This helped lot. Thank you @aghuddleston

Thanks for providing a very useful example including the BOM, @aghuddleston.