Man page or keyword search:   man All Sections 1 - General Commands 2 - System Calls 3 - Subroutines, Functions 4 - Special Files 5 - File Formats 6 - Games and Screensavers 7 - Macros and Conventions 8 - Maintenence Commands 9 - Kernel Interface New Commands Server 4.4BSD AIX Alpinelinux Archlinux Aros BSDOS BSDi Bifrost CentOS Cygwin Darwin Debian DigitalUNIX DragonFly ElementaryOS Fedora FreeBSD Gentoo GhostBSD HP-UX Haiku Hurd IRIX Inferno JazzOS Kali Knoppix LinuxMint MacOSX Mageia Mandriva Manjaro Minix MirBSD NeXTSTEP NetBSD OPENSTEP OSF1 OpenBSD OpenDarwin OpenIndiana OpenMandriva OpenServer OpenSuSE OpenVMS Oracle PC-BSD Peanut Pidora Plan9 QNX Raspbian RedHat Scientific Slackware SmartOS Solaris SuSE SunOS Syllable Tru64 UNIXv7 Ubuntu Ultrix UnixWare Xenix YellowDog aLinux   25941 pages apropos Keyword Search (all sections) Output format html ascii pdf view pdf save postscript

CSV2ODS(1)			 User commands			    CSV2ODS(1)

NAME
       csv2ods - Create OpenDocument spreadsheet from comma separated values

SYNOPSIS
       csv2ods -i file.csv -o file.ods

DESCRIPTION
       This program reads a file in CSV format - table of columns delimited by
       commas, tabs or any other character. It then creates a spreadsheet. If
       a value looks like a number the cell is formatted as a number as well.

OPTIONS
       --version
	   Show program´s version number and exit

       -h, --help
	   Show help message and exit

       -i INPUT, --input=INPUT
	   File input in csv.

       -o OUTPUT, --output=OUTPUT
	   File output in ods.

       -d DELIMITER, --delimiter=DELIMITER
	   Specifies a one-character string to use as the field separator. It
	   defaults to ",".

       -c ENCODING, --encoding=ENCODING
	   Specifies the encoding the file csv. It defaults to utf-8.

       -t TABLENAME, --table=TABLENAME
	   The table name in the output file.

       -s SKIPINITIALSPACE, --skipinitialspace=SKIPINITIALSPACE
	   Specifies how to interpret whitespace which immediately follows a
	   delimiter. It defaults to False, which means that whitespace
	   immediately following a delimiter is part of the following field.

       -l LINETERMINATOR, --lineterminator=LINETERMINATOR
	   Specifies the character sequence which should terminate rows.

       -q QUOTING, --quoting=QUOTING
	   It can take on any of the following module constants: 0 =
	   QUOTE_MINIMAL means only when required, for example, when a field
	   contains either the quotechar or the delimiter. 1 = QUOTE_ALL means
	   that quotes are always placed around fields. 2 = QUOTE_NONNUMERIC
	   means that quotes are always placed around fields which do not
	   parse as integers or floating point numbers. 3 = QUOTE_NONE means
	   that quotes are never placed around fields. It defaults is
	   QUOTE_MINIMAL.

       -e ESCAPECHAR, --escapechar=ESCAPECHAR
	   Specifies a one-character string used to escape the delimiter when
	   quoting is set to QUOTE_NONE.

       -r QUOTECHAR, --quotechar=QUOTECHAR
	   Specifies a one-character string to use as the quoting character.
	   It defaults to ".

EXAMPLE
	   csv2ods -i /etc/passwd -o accounts.odt -d:

AUTHOR
       Agustin Henze <agustinhenze at gmail.com>
	   Original author of csv-ods.py

odfpy				  01/04/2009			    CSV2ODS(1)

Vote for polarhome