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