/xlsx2csv

Convert xslx to csv, it is fast, and works for huge xlsx files

Primary LanguagePython

xlsx2csv convertor

Converts xslx xml excel files to csv format.
It is fast, and works for huge xlsx files.

Usage: xlsx2csv.py [options] infile [outfile]

Options:
  --version             show program's version number and exit
  -h, --help            show this help message and exit
  -s SHEETID, --sheet=SHEETID
                        sheet no to convert (0 for all sheets)
  -d DELIMITER, --delimiter=DELIMITER
                        delimiter - csv columns delimiter, 'tab' or 'x09' for
                        tab (comma is default)
  -p SHEETDELIMITER, --sheetdelimiter=SHEETDELIMITER
                        sheets delimiter used to separate sheets, pass '' if
                        you don't want delimiters (default '--------')
  -f DATEFORMAT, --dateformat=DATEFORMAT
                        override date/time format (ex. %Y/%m/%d)

Expat SAX parser used for xml parsing.

See alternatives:

Bash:
http://kirk.webfinish.com/2009/12/xlsx2csv/

Python:
http://github.com/staale/python-xlsx
http://github.com/leegao/pyXLSX

Ruby:
http://roo.rubyforge.org/

Java:
http://poi.apache.org/


All programs in this directory and subdirectories are published under the GNU General Public License.
Further information about the GNU GPL is available at: http://www.gnu.org/copyleft/gpl.html