Skip to content
/ xlsx2csv Public
forked from dilshod/xlsx2csv

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

License

GPL-3.0, Unknown licenses found

Licenses found

GPL-3.0
LICENSE.txt
Unknown
COPYING
Notifications You must be signed in to change notification settings

hcw70/xlsx2csv

This branch is 234 commits behind dilshod/xlsx2csv:master.

Folders and files

NameName
Last commit message
Last commit date

Latest commit

f7323d4 · Jan 12, 2015
Oct 13, 2012
Oct 2, 2014
Dec 7, 2013
Feb 20, 2014
Oct 13, 2012
Dec 7, 2013
Dec 7, 2013
Apr 15, 2014
Oct 2, 2014
Jan 12, 2015

Repository files navigation

xlsx to csv converter (http://github.com/dilshod/xlsx2csv)

Converts xslx files to csv format.
Handles large XLSX files. Fast and easy to use.

Installation:
  sudo easy_install xlsx2csv
  or
  pip install xlsx2csv

Usage:
  xlsx2csv.py [-h] [-v] [-a] [-d DELIMITER] [-f DATEFORMAT] [-i] [-e]
              [-p SHEETDELIMITER] [-s SHEETID] [--hyperlinks]
              [-I INCLUDE_SHEET_PATTERN] [-E EXCLUDE_SHEET_PATTERN]
              xlsxfile [outfile]

  xlsxfile              xlsx file path
  outfile               output csv file path

optional arguments:
  -h, --help            show this help message and exit
  -v, --version         show program's version number and exit
  -a, --all             export all sheets
  -d DELIMITER, --delimiter DELIMITER
                        delimiter - columns delimiter in csv, 'tab' or 'x09'
                        for a tab (default: comma ',')
  -f DATEFORMAT, --dateformat DATEFORMAT
                        override date/time format (ex. %Y/%m/%d)
  -i, --ignoreempty     skip empty lines
  -e, --escape          Escape \r\n\t characters
  -p SHEETDELIMITER, --sheetdelimiter SHEETDELIMITER
                        sheet delimiter used to separate sheets, pass '' if
                        you do not need delimiter (default: '--------')
  -s SHEETID, --sheet SHEETID
                        sheet number to convert
  --hyperlinks          include hyperlinks
  -I INCLUDE_SHEET_PATTERN, --include INCLUDE_SHEET_PATTERN
                        only include sheets named matching given pattern, only 
                        effects when -a option is enabled.
  -E EXCLUDE_SHEET_PATTERN, --exclude EXCLUDE_SHEET_PATTERN
                        exclude sheets named matching given pattern, only effects
                        when -a option is enabled.
  

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
license GNU GPL version 2 or (at your option) any later version. For
more information, see COPYING or visit <http://www.gnu.org/copyleft/gpl.html>.

About

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

Resources

License

GPL-3.0, Unknown licenses found

Licenses found

GPL-3.0
LICENSE.txt
Unknown
COPYING

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Python 89.2%
  • Perl 6.3%
  • Makefile 4.5%