Convert a CSV file to Shift-JIS for use in Japanese versions of Microsoft Excel in ruby-1.8.7

shiftjis-csv.rb

require "iconv"

encoding = "SHIFT-JIS"
# Open a file for writing in the Shift-JIS format
File.open("output.csv", "w:#{encoding}") do |io|
  # Read the CSV file, and convert CRs to CRLFs.
  csv = File.open("input.csv").read.gsub("\r", "\r\n")
  # Convert the CSV to the correct encoding
  io.write Iconv.iconv(encoding, "UTF-8", csv).join
end