1SSCONVERT(1)                         GNOME                        SSCONVERT(1)
2
3
4

NAME

6       ssconvert - a command line spreadsheet format converter
7
8

SYNOPSIS

10       ssconvert [OPTIONS] infile outfile
11
12       ssconvert [OPTIONS] --merge-to outfile infile1 infile2 ...
13
14

DESCRIPTION

16       ssconvert  is  a  command  line  utility  to  convert spreadsheet files
17       between various spreadsheet file formats. It is a companion utility  to
18       Gnumeric,  the  powerful  spreadsheet  program  created  by  the  GNOME
19       project.
20
21       ssconvert accepts either file names or URIs as infile outfile. The spe‐
22       cial URIs fd://0 and fd://1 can be used for standard input and standard
23       output respectively.
24
25

OPTIONS

27       This program follows the usual GNU command  line  syntax,  with  single
28       letter  options  starting  with  a single dash (`-') and longer options
29       starting with two dashes (`--').
30
31
32   Main options
33       --recalc
34              Recalculate all cells before writing the result.
35
36       -v, --verbose
37              Be slightly more verbose about what is going on.
38
39       --list-exporters
40              List the available exporters (file formats that can be written).
41
42       -T, --export-type=ID
43              Specify which exporter to use; see below for  a  list.  This  is
44              only  necessary  when  the right format does not follow from the
45              output file name.
46
47       -O, --export-options=optionsstring
48              Specify parameters for the chosen exporter.  optionsstring is  a
49              list of parameter=value pairs, separated by spaces.  The parame‐
50              ter names and values allowed are specific to  the  exporter  and
51              are documented below. Multiple parameters can be specified
52
53       --list-importers
54              List  the  available  importers (file formats that can be read).
55              -I, --import-type=ID Specify which importer to  use;  see  below
56              for  a  list.  This is only necessary when the right format does
57              not follow from the input file name.
58
59       -E, --import-encoding=STRING
60              Specify an encoding for imported content.
61
62       -M, --merge-to=FILENAME
63              Merge a collection of  workbooks  into  one.   Sheet  size  will
64              expand  to the largest in all the workbooks.  Names in the scope
65              of individual workbooks will end up in the scope of  the  merged
66              workbook.   The  merge  will  be  aborted if there are name con‐
67              flicts.
68
69       -S, --export-file-per-sheet
70              Export a file for each sheet if the exporter only  supports  one
71              sheet  at  a time.  The output filename is treated as a template
72              in which sheet number is substituted for %n and/or sheet name is
73              substituted for %s.  If there are no substitutions, a default of
74              ".%s" is added.
75
76
77   Help options
78       --version
79              Display ssconvert's version.
80
81       -h, --help, --usage
82              Display a brief usage message.
83
84       --help-all
85              Show all help options.
86
87       --help-libspreadsheet
88              Show Gnumeric options.
89
90

LIST OF IMPORTER/EXPORTER IDS

92       The following IDs can be can be used  both  for  import  (reading)  and
93       export (writing).
94
95       Gnumeric_XmlIO:sax
96              Gnumeric's XML file format (*.gnumeric)
97
98       Gnumeric_OpenCalc:openoffice
99              OpenDocument ⟨http://en.wikipedia.org/wiki/OpenDocument⟩ or
100              OpenOffice Calc ⟨http://en.wikipedia.org/wiki/
101              OpenOffice.org_Calc⟩  (*.sxc,  *.ods)  format.   As an exporter,
102              this is ODF/OpenOffice without foreign elements (*.ods).
103
104       Gnumeric_dif:dif
105              Data Interchange Format ⟨http://en.wikipedia.org/wiki/
106              Data_Interchange_Format⟩ (*.dif)
107
108       Gnumeric_paradox:paradox
109              Paradox database ⟨http://en.wikipedia.org/wiki/
110              Paradox_%28database%29⟩ or primary index file (*.db, *.px)
111
112       Gnumeric_stf:stf_assistant
113              Text (configurable)
114
115       Gnumeric_sylk:sylk
116              MultiPlan ⟨http://en.wikipedia.org/wiki/Multiplan⟩ Symbolic Link
117              (SYLK)   ⟨http://en.wikipedia.org/wiki/SYmbolic_LinK_%28SYLK%29
118              (*.slk)
119
120       Gnumeric_Excel:xlsx
121              Microsoft Excel (tm) 2007 ("Office Open XML", OOXML ⟨http://
122              en.wikipedia.org/wiki/XLSX⟩ ) format
123
124

LIST OF IMPORTANT IMPORTER IDS

126       Gnumeric_stf:stf_csvtab
127              Comma or tab separated values (CSV/TSV) (*.csv)
128
129       Gnumeric_html:html
130              HTML (*.html, *.htm)
131
132       Gnumeric_Excel:excel
133              Microsoft Excel (tm) (*.xls)
134
135       Gnumeric_Excel:excel_xml
136              Microsoft Excel (tm) 2003 SpreadsheetML
137
138

LIST OF OTHER IMPORTER IDS

140       Gnumeric_QPro:qpro
141              Quattro  Pro  ⟨http://en.wikipedia.org/wiki/Quattro_Pro⟩ (*.wb1,
142              *.wb2, *.wb3)
143
144       Gnumeric_applix:applix
145              Applix (*.as)
146
147       Gnumeric_lotus:lotus
148              Lotus 1-2-3  ⟨http://en.wikipedia.org/wiki/Lotus_1-2-3⟩  (*.wk1,
149              *.wks, *.123)
150
151       Gnumeric_mps:mps
152              MPS (Mathematical Programming System) format ⟨http://
153              en.wikipedia.org/wiki/MPS_%28format%29⟩ Linear  programming  and
154              mixed integer programming file format (*.mps)
155
156       Gnumeric_oleo:oleo
157              GNU Oleo ⟨http://en.wikipedia.org/wiki/GNU_Oleo⟩ (*.oleo)
158
159       Gnumeric_plan_perfect:pln
160              PlanPerfect Format (PLN)
161
162       Gnumeric_psiconv:psiconv
163              Psion (*.psisheet)
164
165       Gnumeric_sc:sc
166              SC/xspread
167
168       Gnumeric_xbase:xbase
169              xBase ⟨http://en.wikipedia.org/wiki/XBase⟩ (*.dbf) file format
170
171

LIST OF IMPORTANT EXPORTER IDS

173       Gnumeric_OpenCalc:odf
174              ODF/OpenOffice with foreign elements (*.ods)
175
176       Gnumeric_glpk:glpk
177              GLPK Linear Program Solver
178
179       Gnumeric_html:html40
180              HTML 4.0 (*.html)
181
182       Gnumeric_html:html40frag
183              HTML (*.html) fragment
184
185       Gnumeric_html:xhtml
186              XHTML (*.html)
187
188       Gnumeric_html:xhtml_range
189              XHTML range - for export to clipboard
190
191       Gnumeric_pdf:pdf_assistant
192              Portable Document Format (*.PDF)
193
194       Gnumeric_stf:stf_csv
195              Comma separated values (CSV)
196
197       Gnumeric_Excel:excel_dsf
198              Microsoft Excel (tm) 97/2000/XP & 5.0/95
199
200

LIST OF OTHER EXPORTER IDS

202       Gnumeric_Excel:excel_biff7
203              Microsoft Excel (tm) 5.0/95
204
205       Gnumeric_Excel:excel_biff8
206              Microsoft S Excel (tm) 97/2000/XP
207
208       Gnumeric_GnomeGlossary:po
209              Gnome Glossary PO file format
210
211       Gnumeric_html:html32
212              HTML 3.2 (*.html)
213
214       Gnumeric_html:latex
215              LaTeX 2e (*.tex)
216
217       Gnumeric_html:latex_table
218              LaTeX 2e (*.tex) table fragment
219
220       Gnumeric_html:roff
221              TROFF ⟨http://en.wikipedia.org/wiki/Troff⟩ (*.me) format.
222
223       Gnumeric_lpsolve:lpsolve
224              LPSolve ⟨http://sourceforge.net/projects/lpsolve/⟩ Mixed Integer
225              Linear Programming (MILP) solver
226
227

OPTIONS FOR THE PORTABLE DOCUMENT FORMAT (*.pdf) EXPORTER

229       sheet  Name of the workbook sheet to operate on.  You can specify  sev‐
230              eral  sheets  by  repeating this option.  This is ignored if the
231              object option is given.
232
233
234       active-sheet
235              Select the active sheet to  operate  on.   The  value  for  this
236              option is irrelevant, but the equal sign is mandatory.
237
238
239       object Name  of  the sheet object to print. If this option is given any
240              sheet option  is  ignored.   Only  the  first  object  given  is
241              exported.
242
243
244       paper  Paper  size.  Valid  values include "A4" for ISO A4 and "na_let‐
245              ter_8.5x11in" for US Letter. If an individual graph is specified
246              through  the  object  option, then a paper size of "fit" reduces
247              the size of the paper to the size of the graph.
248
249

OPTIONS FOR THE CONFIGURABLE TEXT (*.txt) EXPORTER

251       sheet  Name of the workbook sheet to operate on.  You can specify  sev‐
252              eral sheets by repeating this option.
253
254
255       active-sheet
256              Select  the  active  sheet  to  operate  on.  The value for this
257              option is irrelevant, but the equal sign is mandatory.
258
259
260       eol    End Of Line convention; how lines are  terminated.   "unix"  for
261              linefeed,  "mac"  for  carriage  return;  "windows" for carriage
262              return plus linefeed.
263
264
265       charset
266              The character encoding of the output. Defaults to UTF-8.
267
268
269       locale The locale to use for number and date formatting.   Defaults  to
270              the  current locale as reported by locale(1).  Consult locale -a
271              output for acceptable values.
272
273
274       quote  The character or string used for  quoting  fields.  Defaults  to
275              "\"" (quotation mark / double quote).
276
277
278       separator
279              The string used to separate fields. Defaults to space.
280
281
282       format How  cells  should be formatted.  Acceptable values: "automatic"
283              (apply automatic formatting; default), "raw" (output  data  raw,
284              unformatted),  or  "preserve"  (preserve the formatting from the
285              source document).
286
287              This deals with the difference between a cell's contents and the
288              way those contents are formatted.
289
290              Consider  a  cell in a Gnumeric input document that was input as
291              "4/19/73" in a US locale, with a format set to "d-mmm-yyyy"  and
292              thus formatted as "19-Apr-1973".
293
294              With the default format setting of "automatic" it will be output
295              as "1973/04/19". With "preserve", the formatting  will  be  pre‐
296              served  and  it  will  be output as "19-Apr-1973". With "raw" it
297              will be output as "26773" (Gnumeric's  internal  representation:
298              days since an epoch).
299
300
301       transliterate-mode
302              How to handle unrepresentable characters (characters that cannot
303              be represented in the chosen output character set).   Acceptable
304              values: "transliterate", or "escape".
305
306
307       quoting-mode
308              When  does data need to be quoted?  "never", "auto" (puts quotes
309              where needed), or "always". Defaults to "auto".
310
311
312       quoting-on-whitespace
313              Controls whether initial or terminal whitespace forces  quoting.
314              Defaults to TRUE.
315
316
317

EXAMPLE

319       To convert the Gnumeric file foo.gnumeric to a Microsoft Excel(TM) for‐
320       mat file foo.xls:
321
322       ssconvert foo.gnumeric foo.xls
323
324       The export format can be specified explicitly, to override the  default
325       (which is based on the file extension):
326
327       ssconvert --export-type=Gnumeric_stf:stf_csv foo.xls foo.txt
328
329       To convert an Excel format file statfuns.xls to a text file, specifying
330       the semicolon as the separator character:
331
332       ssconvert -O 'separator=; format=raw' samples/excel/statfuns.xls  stat‐
333       funs.txt
334

LICENSE

336       ssconvert  is  licensed  under  the terms of the General Public License
337       (GPL), version 2 or 3. For information on  this  license  look  at  the
338       source code that came with the software or see the GNU project page
339http://www.gnu.org⟩.
340
341
343       The copyright on the Gnumeric software and source code is held  by  the
344       individual authors as is documented in the source code.
345
346

AUTHOR

348       ssconvert's primary author is Jody Goldberg <jody@gnome.org>; ssconvert
349       builds on the Gnumeric codebase.
350
351       The initial version of this manpage was written by J.H.M. Dassen  (Ray)
352       <jdassen@debian.org>.
353
354

SEE ALSO

356       gnumeric(1), ssdiff(1), ssgrep(1), ssindex(1)
357
358       The Gnumeric Homepage ⟨http://www.gnome.org/projects/gnumeric/⟩.
359
360       The GNOME project page ⟨http://www.gnome.org/⟩.
361
362
363
364gnumeric                          2019-01-19                      SSCONVERT(1)
Impressum