ssconvert is a command line utility to convert spreadsheet files
between various spreadsheet file formats. It is a companion utility to
Gnumeric, the powerful spreadsheet program created by the GNOME
ssconvert accepts either file names or URIs as infileoutfile. The special URIs fd://0 and fd://1 can be
used for standard input and standard output respectively.
This program follows the usual GNU command line syntax, with single
letter options starting with a single dash (`-') and longer options
starting with two dashes (`--').
Recalculate all cells before writing the result.
List the available exporters (file formats that can be written).
Specify which exporter to use; see below for a list. This is only
necessary when the right format does not follow from the output file
Specify parameters for the chosen exporter.
optionsstring is a list of parameter=value pairs, separated
The parameter names and values allowed are specific to the exporter and are
documented below. Multiple parameters can be specified
List the available importers (file formats that can be read).
Specify which importer to use; see below for a list. This is only
necessary when the right format does not follow from the input file
Specify an encoding for imported content.
Merge a collection of workbooks into one. Sheet size will expand
to the largest in all the workbooks. Names in the scope of
individual workbooks will end up in the scope of the merged
workbook. The merge will be aborted if there are name conflicts.
Export a file for each sheet if the exporter only supports one sheet at a
Display ssconvert's version.
-h, --help, --usage
Display a brief usage message.
Show all help options.
Show Gnumeric options.
Set the root library directory.
Adjust the root data directory.
LIST OF IMPORTER/EXPORTER IDS
The following IDs can be can be used both for import (reading) and export
OPTIONS FOR THE PORTABLE DOCUMENT FORMAT (*.pdf) EXPORTER
Name of the workbook sheet to operate on.
Paper size. Valid values include "A4" for ISO A4 and
"na_letter_8.5x11in" for US Letter.
OPTIONS FOR THE CONFIGURABLE TEXT (*.txt) EXPORTER
Name of the workbook sheet to operate on.
End Of Line convention; how lines are terminated.
"unix" for linefeed,
"mac" for carriage return;
"windows" for carriage return plus linefeed.
The character encoding of the output. Defaults to UTF-8.
The locale to use for number and date formatting.
Defaults to the current locale as reported by locale(1).
Consult locale -a output for acceptable values.
The character or string used for quoting fields. Defaults to "\""
(quotation mark / double quote).
The string used to separate fields. Defaults to space.
How cells should be formatted.
"automatic" (apply automatic formatting; default),
"raw" (output data raw, unformatted), or
"preserve" (preserve the formatting from the source document).
This deals with the difference between a cell's contents and the way those
contents are formatted.
Consider a cell in a Gnumeric input document that was
input as "4/19/73" in a US locale, with a format set to "d-mmm-yyyy" and
thus formatted as "19-Apr-1973".
With the default format setting of "automatic" it will be output
as "1973/04/19". With "preserve", the formatting will be preserved and
it will be output as "19-Apr-1973". With "raw" it will be output as
"26773" (Gnumeric's internal representation: days since an epoch).
How to handle unrepresentable characters (characters that cannot be
represented in the chosen output character set).
When does data need to be quoted?
"auto" (puts quotes where needed), or
"always". Defaults to "never".
Controls whether initial or terminal whitespace forces quoting. Defaults to
To convert the Gnumeric file foo.gnumeric to a Microsoft Excel(TM)
The export format can be specified explicitly, to override the default
(which is based on the file extension):
ssconvert is licensed under the terms of the General Public
License (GPL), version 2. For information on this license look at the
source code that came with the software or see the
GNU project page <URL: http://www.gnu.org >.
The copyright on the Gnumeric software and source code is held
by the individual authors as is documented in the source code.
ssconvert's primary author is Jody Goldberg <firstname.lastname@example.org>;
ssconvert builds on the Gnumeric codebase.
The initial version of this manpage was written by J.H.M. Dassen (Ray)