1SSCONVERT(1) GNOME SSCONVERT(1)
2
6 ssconvert - a command line spreadsheet format converter
7
10 ssconvert [OPTIONS] infile outfile
11 ssconvert [OPTIONS] --merge-to outfile infile1 infile2 ...
13
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 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
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 Main options
33 --recalc
34 Recalculate all cells before writing the result.
35 --set CELL=CONTENTS
37 Set the value of CELL to CONTENTS. To put an expression in a
38 cell, add an extra =, for example --set "A11==A10+1". This
39 option may be repeated as many times as needed. The workbook
40 will be recalculated after all cells have been set, provided
41 that the workbook is set for automatic recalculation. If not,
42 recalculation can be forced with --recalc.
43 -v, --verbose
45 Be slightly more verbose about what is going on.
46 --list-exporters
48 List the available exporters (file formats that can be written).
49 -T, --export-type=ID
51 Specify which exporter to use; see below for a list. This is
52 only necessary when the right format does not follow from the
53 output file name. The list of available export formats can be
54 generated using the --list-exporters option. However, when
55 image export is requested using the --export-graphs option, the
56 list of image formats should be consulted instead. That list
57 can be generated using the --list-image-formats option.
58 -O, --export-options=optionsstring
60 Specify parameters for the chosen exporter. optionsstring is a
61 list of parameter=value pairs, separated by spaces. The parame‐
62 ter names and values allowed are specific to the exporter and
63 are documented below. Multiple parameters can be specified
64 --export-graphs
66 Export the graphs (or charts) inside the input spreadsheet to
67 numbered image files (SVG by default). The list of available
68 image formats can be printed with --list-image-formats
69 --list-importers
71 List the available importers (file formats that can be read).
72 -I, --import-type=ID Specify which importer to use; see below
73 for a list. This is only necessary when the right format does
74 not follow from the input file name.
75 --list-image-formats
77 List the available image formats for graph export
78 -E, --import-encoding=STRING
80 Specify an encoding for imported content.
81 -M, --merge-to=FILENAME
83 Merge a collection of workbooks into one. Sheet size will
84 expand to the largest in all the workbooks. Names in the scope
85 of individual workbooks will end up in the scope of the merged
86 workbook. The merge will be aborted if there are name con‐
87 flicts.
88 -S, --export-file-per-sheet
90 Export a file for each sheet if the exporter only supports one
91 sheet at a time. The output filename is treated as a template
92 in which sheet number is substituted for %n, sheet name is sub‐
93 stituted for %s, and sheet object name is substituted for %o in
94 case of graph export. If there are no substitutions, a default
95 of ".%n" is added.
96 Help options
99 --version
100 Display ssconvert's version.
101 -h, --help, --usage
103 Display a brief usage message.
104 --help-all
106 Show all help options.
107 --help-libspreadsheet
109 Show Gnumeric options.
110
113 The following IDs can be can be used both for import (reading) and
114 export (writing).
115 Gnumeric_XmlIO:sax
117 Gnumeric's XML file format (*.gnumeric)
118 Gnumeric_OpenCalc:openoffice
120 OpenDocument ⟨http://en.wikipedia.org/wiki/OpenDocument⟩ or
121 OpenOffice Calc ⟨http://en.wikipedia.org/wiki/
122 OpenOffice.org_Calc⟩ (*.sxc, *.ods) format. As an exporter,
123 this is ODF/OpenOffice without foreign elements (*.ods).
124 Gnumeric_dif:dif
126 Data Interchange Format ⟨http://en.wikipedia.org/wiki/
127 Data_Interchange_Format⟩ (*.dif)
128 Gnumeric_paradox:paradox
130 Paradox database ⟨http://en.wikipedia.org/wiki/
131 Paradox_%28database%29⟩ or primary index file (*.db, *.px)
132 Gnumeric_stf:stf_assistant
134 Text (configurable)
135 Gnumeric_sylk:sylk
137 MultiPlan ⟨http://en.wikipedia.org/wiki/Multiplan⟩ Symbolic Link
138 (SYLK) ⟨http://en.wikipedia.org/wiki/SYmbolic_LinK_%28SYLK%29⟩
139 (*.slk)
140 Gnumeric_Excel:xlsx
142 Microsoft Excel (tm) 2007 ("Office Open XML", OOXML ⟨http://
143 en.wikipedia.org/wiki/XLSX⟩ ) format
144
147 Gnumeric_stf:stf_csvtab
148 Comma or tab separated values (CSV/TSV) (*.csv)
149 Gnumeric_html:html
151 HTML (*.html, *.htm)
152 Gnumeric_Excel:excel
154 Microsoft Excel (tm) (*.xls)
155 Gnumeric_Excel:excel_xml
157 Microsoft Excel (tm) 2003 SpreadsheetML
158
161 Gnumeric_QPro:qpro
162 Quattro Pro ⟨http://en.wikipedia.org/wiki/Quattro_Pro⟩ (*.wb1,
163 *.wb2, *.wb3)
164 Gnumeric_applix:applix
166 Applix (*.as)
167 Gnumeric_lotus:lotus
169 Lotus 1-2-3 ⟨http://en.wikipedia.org/wiki/Lotus_1-2-3⟩ (*.wk1,
170 *.wks, *.123)
171 Gnumeric_mps:mps
173 MPS (Mathematical Programming System) format ⟨http://
174 en.wikipedia.org/wiki/MPS_%28format%29⟩ Linear programming and
175 mixed integer programming file format (*.mps)
176 Gnumeric_oleo:oleo
178 GNU Oleo ⟨http://en.wikipedia.org/wiki/GNU_Oleo⟩ (*.oleo)
179 Gnumeric_plan_perfect:pln
181 PlanPerfect Format (PLN)
182 Gnumeric_psiconv:psiconv
184 Psion (*.psisheet)
185 Gnumeric_sc:sc
187 SC/xspread
188 Gnumeric_xbase:xbase
190 xBase ⟨http://en.wikipedia.org/wiki/XBase⟩ (*.dbf) file format
191
194 Gnumeric_OpenCalc:odf
195 ODF/OpenOffice with foreign elements (*.ods)
196 Gnumeric_glpk:glpk
198 GLPK Linear Program Solver
199 Gnumeric_html:html40
201 HTML 4.0 (*.html)
202 Gnumeric_html:html40frag
204 HTML (*.html) fragment
205 Gnumeric_html:xhtml
207 XHTML (*.html)
208 Gnumeric_html:xhtml_range
210 XHTML range - for export to clipboard
211 Gnumeric_pdf:pdf_assistant
213 Portable Document Format (*.PDF)
214 Gnumeric_stf:stf_csv
216 Comma separated values (CSV)
217 Gnumeric_Excel:excel_dsf
219 Microsoft Excel (tm) 97/2000/XP & 5.0/95
220
223 Gnumeric_Excel:excel_biff7
224 Microsoft Excel (tm) 5.0/95
225 Gnumeric_Excel:excel_biff8
227 Microsoft S Excel (tm) 97/2000/XP
228 Gnumeric_GnomeGlossary:po
230 Gnome Glossary PO file format
231 Gnumeric_html:html32
233 HTML 3.2 (*.html)
234 Gnumeric_html:latex
236 LaTeX 2e (*.tex)
237 Gnumeric_html:latex_table
239 LaTeX 2e (*.tex) table fragment
240 Gnumeric_html:roff
242 TROFF ⟨http://en.wikipedia.org/wiki/Troff⟩ (*.me) format.
243 Gnumeric_lpsolve:lpsolve
245 LPSolve ⟨http://sourceforge.net/projects/lpsolve/⟩ Mixed Integer
246 Linear Programming (MILP) solver
247
250 sheet Name of the workbook sheet to operate on. You can specify sev‐
251 eral sheets by repeating this option. This is ignored if the
252 object option is given.
253 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 object Name of the sheet object to print. If this option is given any
261 sheet option is ignored. Only the first object given is
262 exported.
263 paper Paper size. Valid values include "A4" for ISO A4 and "na_let‐
266 ter_8.5x11in" for US Letter. If an individual graph is specified
267 through the object option, then a paper size of "fit" reduces
268 the size of the paper to the size of the graph.
269
272 sheet Name of the workbook sheet to operate on. You can specify sev‐
273 eral sheets by repeating this option.
274 active-sheet
277 Select the active sheet to operate on. The value for this
278 option is irrelevant, but the equal sign is mandatory.
279 eol End Of Line convention; how lines are terminated. "unix" for
282 linefeed, "mac" for carriage return; "windows" for carriage
283 return plus linefeed.
284 charset
287 The character encoding of the output. Defaults to UTF-8.
288 locale The locale to use for number and date formatting. Defaults to
291 the current locale as reported by locale(1). Consult locale -a
292 output for acceptable values.
293 quote The character or string used for quoting fields. Defaults to
296 "\"" (quotation mark / double quote).
297 separator
300 The string used to separate fields. Defaults to space.
301 format How cells should be formatted. Acceptable values: "automatic"
304 (apply automatic formatting; default), "raw" (output data raw,
305 unformatted), or "preserve" (preserve the formatting from the
306 source document).
307 This deals with the difference between a cell's contents and the
309 way those contents are formatted.
310 Consider a cell in a Gnumeric input document that was input as
312 "4/19/73" in a US locale, with a format set to "d-mmm-yyyy" and
313 thus formatted as "19-Apr-1973".
314 With the default format setting of "automatic" it will be output
316 as "1973/04/19". With "preserve", the formatting will be pre‐
317 served and it will be output as "19-Apr-1973". With "raw" it
318 will be output as "26773" (Gnumeric's internal representation:
319 days since an epoch).
320 transliterate-mode
323 How to handle unrepresentable characters (characters that cannot
324 be represented in the chosen output character set). Acceptable
325 values: "transliterate", or "escape".
326 quoting-mode
329 When does data need to be quoted? "never", "auto" (puts quotes
330 where needed), or "always". Defaults to "auto".
331 quoting-on-whitespace
334 Controls whether initial or terminal whitespace forces quoting.
335 Defaults to TRUE.
336
340 To convert the Gnumeric file foo.gnumeric to a Microsoft Excel(TM) for‐
341 mat file foo.xls:
342 ssconvert foo.gnumeric foo.xls
344 The export format can be specified explicitly, to override the default
346 (which is based on the file extension):
347 ssconvert --export-type=Gnumeric_stf:stf_csv foo.xls foo.txt
349 To convert an Excel format file statfuns.xls to a text file, specifying
351 the semicolon as the separator character:
352 ssconvert -O 'separator=; format=raw' samples/excel/statfuns.xls stat‐
354 funs.txt
355 To export the charts from the input file input.gnumeric to numbered SVG
357 files:
358 ssconvert --export-graphs input.gnumeric 'output.%n.svg'
360 To export the charts from the input file input.gnumeric to numbered PNG
362 files:
363 ssconvert --export-type=png --export-graphs input.gnumeric 'out‐
365 put.%n.png'
366
368 ssconvert is licensed under the terms of the General Public License
369 (GPL), version 2 or 3. For information on this license look at the
370 source code that came with the software or see the GNU project page
371 ⟨http://www.gnu.org⟩.
372
375 The copyright on the Gnumeric software and source code is held by the
376 individual authors as is documented in the source code.
377
380 ssconvert's primary author is Jody Goldberg <jody@gnome.org>; ssconvert
381 builds on the Gnumeric codebase.
382 The initial version of this manpage was written by J.H.M. Dassen (Ray)
384 <jdassen@debian.org>.
385
388 gnumeric(1), ssdiff(1), ssgrep(1), ssindex(1)
389 The Gnumeric Homepage ⟨http://www.gnome.org/projects/gnumeric/⟩.
391 The GNOME project page ⟨http://www.gnome.org/⟩.
393gnumeric 2020-04-19 SSCONVERT(1)