Saturday, November 5, 2016

Convert xlsx to csv in Linux...

You can use Open Office for Linux to open an xlsx file and then save as csv. But this takes a bit of time to load the file in Open Office and then do convert.

Also, what if there are multiple files that you want to convert?

You need to have "ssconvert" which does convert the file in command line and does pretty good job.

Download the below two rpm's and install them using rpm -Uvh:

http://rpm.pbone.net/index.php3/stat/4/idpl/28272017/dir/fedora_21/com/goffice-0.10.18-1.fc21.x86_64.rpm.html

http://rpm.pbone.net/index.php3/stat/4/idpl/28271945/dir/fedora_21/com/gnumeric-1.12.18-1.fc21.x86_64.rpm.html

gnumeric rpm has ssconvert. Once installed, you can simply use as:
[santhosh@localhost myspark]$ ssconvert 'Member accounts 11042016.xls' memberac.csv



No comments:

Post a Comment