1SSCONVERT(1) GNOME SSCONVERT(1)
2
3
4
6 ssconvert - a command line spreadsheet format converter
7
8
10 ssconvert [OPTIONS] infile outfile
11
12 ssconvert [OPTIONS] --merge-to outfile infile1 infile2 ...
13
14
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
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 --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
44 -v, --verbose
45 Be slightly more verbose about what is going on.
46
47 --list-exporters
48 List the available exporters (file formats that can be written).
49
50 -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
59 -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
65 --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
70 --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
76 --list-image-formats
77 List the available image formats for graph export
78
79 -E, --import-encoding=STRING
80 Specify an encoding for imported content.
81
82 -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
89 -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
97
98 Help options
99 --version
100 Display ssconvert's version.
101
102 -h, --help, --usage
103 Display a brief usage message.
104
105 --help-all
106 Show all help options.
107
108 --help-libspreadsheet
109 Show Gnumeric options.
110
111
113 The following IDs can be can be used both for import (reading) and
114 export (writing).
115
116 Gnumeric_XmlIO:sax
117 Gnumeric's XML file format (*.gnumeric)
118
119 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
125 Gnumeric_dif:dif
126 Data Interchange Format ⟨http://en.wikipedia.org/wiki/
127 Data_Interchange_Format⟩ (*.dif)
128
129 Gnumeric_paradox:paradox
130 Paradox database ⟨http://en.wikipedia.org/wiki/
131 Paradox_%28database%29⟩ or primary index file (*.db, *.px)
132
133 Gnumeric_stf:stf_assistant
134 Text (configurable)
135
136 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
141 Gnumeric_Excel:xlsx
142 Microsoft Excel (tm) 2007 ("Office Open XML", OOXML ⟨http://
143 en.wikipedia.org/wiki/XLSX⟩ ) format
144
145
147 Gnumeric_stf:stf_csvtab
148 Comma or tab separated values (CSV/TSV) (*.csv)
149
150 Gnumeric_html:html
151 HTML (*.html, *.htm)
152
153 Gnumeric_Excel:excel
154 Microsoft Excel (tm) (*.xls)
155
156 Gnumeric_Excel:excel_xml
157 Microsoft Excel (tm) 2003 SpreadsheetML
158
159
161 Gnumeric_QPro:qpro
162 Quattro Pro ⟨http://en.wikipedia.org/wiki/Quattro_Pro⟩ (*.wb1,
163 *.wb2, *.wb3)
164
165 Gnumeric_applix:applix
166 Applix (*.as)
167
168 Gnumeric_lotus:lotus
169 Lotus 1-2-3 ⟨http://en.wikipedia.org/wiki/Lotus_1-2-3⟩ (*.wk1,
170 *.wks, *.123)
171
172 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
177 Gnumeric_oleo:oleo
178 GNU Oleo ⟨http://en.wikipedia.org/wiki/GNU_Oleo⟩ (*.oleo)
179
180 Gnumeric_plan_perfect:pln
181 PlanPerfect Format (PLN)
182
183 Gnumeric_psiconv:psiconv
184 Psion (*.psisheet)
185
186 Gnumeric_sc:sc
187 SC/xspread
188
189 Gnumeric_xbase:xbase
190 xBase ⟨http://en.wikipedia.org/wiki/XBase⟩ (*.dbf) file format
191
192
194 Gnumeric_OpenCalc:odf
195 ODF/OpenOffice with foreign elements (*.ods)
196
197 Gnumeric_glpk:glpk
198 GLPK Linear Program Solver
199
200 Gnumeric_html:html40
201 HTML 4.0 (*.html)
202
203 Gnumeric_html:html40frag
204 HTML (*.html) fragment
205
206 Gnumeric_html:xhtml
207 XHTML (*.html)
208
209 Gnumeric_html:xhtml_range
210 XHTML range - for export to clipboard
211
212 Gnumeric_pdf:pdf_assistant
213 Portable Document Format (*.PDF)
214
215 Gnumeric_stf:stf_csv
216 Comma separated values (CSV)
217
218 Gnumeric_Excel:excel_dsf
219 Microsoft Excel (tm) 97/2000/XP & 5.0/95
220
221
223 Gnumeric_Excel:excel_biff7
224 Microsoft Excel (tm) 5.0/95
225
226 Gnumeric_Excel:excel_biff8
227 Microsoft S Excel (tm) 97/2000/XP
228
229 Gnumeric_GnomeGlossary:po
230 Gnome Glossary PO file format
231
232 Gnumeric_html:html32
233 HTML 3.2 (*.html)
234
235 Gnumeric_html:latex
236 LaTeX 2e (*.tex)
237
238 Gnumeric_html:latex_table
239 LaTeX 2e (*.tex) table fragment
240
241 Gnumeric_html:roff
242 TROFF ⟨http://en.wikipedia.org/wiki/Troff⟩ (*.me) format.
243
244 Gnumeric_lpsolve:lpsolve
245 LPSolve ⟨http://sourceforge.net/projects/lpsolve/⟩ Mixed Integer
246 Linear Programming (MILP) solver
247
248
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
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 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
264
265 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
270
272 sheet Name of the workbook sheet to operate on. You can specify sev‐
273 eral sheets by repeating this option.
274
275
276 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
280
281 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
285
286 charset
287 The character encoding of the output. Defaults to UTF-8.
288
289
290 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
294
295 quote The character or string used for quoting fields. Defaults to
296 "\"" (quotation mark / double quote).
297
298
299 separator
300 The string used to separate fields. Defaults to space.
301
302
303 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
308 This deals with the difference between a cell's contents and the
309 way those contents are formatted.
310
311 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
315 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
321
322 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
327
328 quoting-mode
329 When does data need to be quoted? "never", "auto" (puts quotes
330 where needed), or "always". Defaults to "auto".
331
332
333 quoting-on-whitespace
334 Controls whether initial or terminal whitespace forces quoting.
335 Defaults to TRUE.
336
337
338
340 To convert the Gnumeric file foo.gnumeric to a Microsoft Excel(TM) for‐
341 mat file foo.xls:
342
343 ssconvert foo.gnumeric foo.xls
344
345 The export format can be specified explicitly, to override the default
346 (which is based on the file extension):
347
348 ssconvert --export-type=Gnumeric_stf:stf_csv foo.xls foo.txt
349
350 To convert an Excel format file statfuns.xls to a text file, specifying
351 the semicolon as the separator character:
352
353 ssconvert -O 'separator=; format=raw' samples/excel/statfuns.xls stat‐
354 funs.txt
355
356 To export the charts from the input file input.gnumeric to numbered SVG
357 files:
358
359 ssconvert --export-graphs input.gnumeric 'output.%n.svg'
360
361 To export the charts from the input file input.gnumeric to numbered PNG
362 files:
363
364 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
373
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
378
380 ssconvert's primary author is Jody Goldberg <jody@gnome.org>; ssconvert
381 builds on the Gnumeric codebase.
382
383 The initial version of this manpage was written by J.H.M. Dassen (Ray)
384 <jdassen@debian.org>.
385
386
388 gnumeric(1), ssdiff(1), ssgrep(1), ssindex(1)
389
390 The Gnumeric Homepage ⟨http://www.gnome.org/projects/gnumeric/⟩.
391
392 The GNOME project page ⟨http://www.gnome.org/⟩.
393
394
395
396gnumeric 2020-04-19 SSCONVERT(1)