Skip to content

Instantly share code, notes, and snippets.

@dthyresson
Forked from enriclluelles/csv_to_json.rb
Created December 14, 2016 17:26
Show Gist options
  • Save dthyresson/1e1cafa406f02bd88013ba01fc74d45d to your computer and use it in GitHub Desktop.
Save dthyresson/1e1cafa406f02bd88013ba01fc74d45d to your computer and use it in GitHub Desktop.
CSV to JSON
#!/usr/bin/env ruby
require 'csv'
require 'json'
if ARGV.size != 2
puts 'Usage: csv_to_json input_file.csv output_file.json'
puts 'This script uses the first line of the csv file as the keys for the JSON properties of the objects'
exit(1)
end
lines = CSV.open(ARGV[0]).readlines
keys = lines.delete lines.first
File.open(ARGV[1], 'w') do |f|
data = lines.map do |values|
Hash[keys.zip(values)]
end
f.puts JSON.pretty_generate(data)
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment