Convert an xls or xlsx file to csv
Ruby
Switch branches/tags
Nothing to show
Latest commit 94227aa Mar 25, 2015 @scpike scpike Merge pull request #2 from celon/master
Code fixed for newer gem.
Permalink
Failed to load latest commit information.
src Fix code with roo at 2015 Mar 24, 2015
.gitignore initial commit May 5, 2012
Gemfile Initial commit May 5, 2012
Gemfile.lock Initial commit May 5, 2012
README.md Fix code with roo at 2015 Mar 24, 2015

README.md

excel2csv

Very simple command line interface to the roo library, converts .xls or .xlsx files to .csv.

I have to do a lot of text parsing on spreadsheets. Opening them in excel and saving to csv is time consuming and Excel often munges accented characters. This utilty should convert Excel files to UTF-8 encoded CSV.

Installation

excel2csv uses the roo gem

gem install roo

Usage

Print the usage with:

excel2csv

Print the csv to std out

excel2csv file.xls

Write the csv to file

excel2csv file.xls out.csv