Is there an foss command line program that can convert between Excel (.XLXS) and Comma Separated Value (.CSV) files?
1 Answer
Yes! Use the PowerShell Excel Module. A full discussion of its features and uses is well beyond a simple Q/A, but the knowledge of its existence will get you in the right direction.
A cross-platform means of doing this without Excel being installed would be the Python tool [xlsx2csv][2]
. The Gnumeric package can also do Excel to CSV conversions in a terminal, but it will not be cross-platform and will also require the GNOME office package to be installed.
-
Although @mcandre doesn't specify whether it's a requirement or not, note that this PS module will require Excel to be installed.– KaranNov 9, 2012 at 22:25
-
-
@mcandre: The only thing I can think of is a Java program that uses either Apache POI or the OpenDocument API. A quick search for "java program xlsx to csv" will turn up lots of interesting results, and if you need help there's always StackOverflow. Here's a .Net program too, if you need it.– KaranNov 10, 2012 at 13:31