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 -v, --verbose
37 Be slightly more verbose about what is going on.
38 --list-exporters
40 List the available exporters (file formats that can be written).
41 -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 -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 --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 -E, --import-encoding=STRING
60 Specify an encoding for imported content.
61 -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 -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 Help options
78 --version
79 Display ssconvert's version.
80 -h, --help, --usage
82 Display a brief usage message.
83 --help-all
85 Show all help options.
86 --help-libspreadsheet
88 Show Gnumeric options.
89
92 The following IDs can be can be used both for import (reading) and
93 export (writing).
94 Gnumeric_XmlIO:sax
96 Gnumeric's XML file format (*.gnumeric)
97 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 Gnumeric_dif:dif
105 Data Interchange Format ⟨http://en.wikipedia.org/wiki/
106 Data_Interchange_Format⟩ (*.dif)
107 Gnumeric_paradox:paradox
109 Paradox database ⟨http://en.wikipedia.org/wiki/
110 Paradox_%28database%29⟩ or primary index file (*.db, *.px)
111 Gnumeric_stf:stf_assistant
113 Text (configurable)
114 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 Gnumeric_Excel:xlsx
121 Microsoft Excel (tm) 2007 ("Office Open XML", OOXML ⟨http://
122 en.wikipedia.org/wiki/XLSX⟩ ) format
123
126 Gnumeric_stf:stf_csvtab
127 Comma or tab separated values (CSV/TSV) (*.csv)
128 Gnumeric_html:html
130 HTML (*.html, *.htm)
131 Gnumeric_Excel:excel
133 Microsoft Excel (tm) (*.xls)
134 Gnumeric_Excel:excel_xml
136 Microsoft Excel (tm) 2003 SpreadsheetML
137
140 Gnumeric_QPro:qpro
141 Quattro Pro ⟨http://en.wikipedia.org/wiki/Quattro_Pro⟩ (*.wb1,
142 *.wb2, *.wb3)
143 Gnumeric_applix:applix
145 Applix (*.as)
146 Gnumeric_lotus:lotus
148 Lotus 1-2-3 ⟨http://en.wikipedia.org/wiki/Lotus_1-2-3⟩ (*.wk1,
149 *.wks, *.123)
150 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 Gnumeric_oleo:oleo
157 GNU Oleo ⟨http://en.wikipedia.org/wiki/GNU_Oleo⟩ (*.oleo)
158 Gnumeric_plan_perfect:pln
160 PlanPerfect Format (PLN)
161 Gnumeric_psiconv:psiconv
163 Psion (*.psisheet)
164 Gnumeric_sc:sc
166 SC/xspread
167 Gnumeric_xbase:xbase
169 xBase ⟨http://en.wikipedia.org/wiki/XBase⟩ (*.dbf) file format
170
173 Gnumeric_OpenCalc:odf
174 ODF/OpenOffice with foreign elements (*.ods)
175 Gnumeric_glpk:glpk
177 GLPK Linear Program Solver
178 Gnumeric_html:html40
180 HTML 4.0 (*.html)
181 Gnumeric_html:html40frag
183 HTML (*.html) fragment
184 Gnumeric_html:xhtml
186 XHTML (*.html)
187 Gnumeric_html:xhtml_range
189 XHTML range - for export to clipboard
190 Gnumeric_pdf:pdf_assistant
192 Portable Document Format (*.PDF)
193 Gnumeric_stf:stf_csv
195 Comma separated values (CSV)
196 Gnumeric_Excel:excel_dsf
198 Microsoft Excel (tm) 97/2000/XP & 5.0/95
199
202 Gnumeric_Excel:excel_biff7
203 Microsoft Excel (tm) 5.0/95
204 Gnumeric_Excel:excel_biff8
206 Microsoft S Excel (tm) 97/2000/XP
207 Gnumeric_GnomeGlossary:po
209 Gnome Glossary PO file format
210 Gnumeric_html:html32
212 HTML 3.2 (*.html)
213 Gnumeric_html:latex
215 LaTeX 2e (*.tex)
216 Gnumeric_html:latex_table
218 LaTeX 2e (*.tex) table fragment
219 Gnumeric_html:roff
221 TROFF ⟨http://en.wikipedia.org/wiki/Troff⟩ (*.me) format.
222 Gnumeric_lpsolve:lpsolve
224 LPSolve ⟨http://sourceforge.net/projects/lpsolve/⟩ Mixed Integer
225 Linear Programming (MILP) solver
226
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 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 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 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
251 sheet Name of the workbook sheet to operate on. You can specify sev‐
252 eral sheets by repeating this option.
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 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 charset
266 The character encoding of the output. Defaults to UTF-8.
267 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 quote The character or string used for quoting fields. Defaults to
275 "\"" (quotation mark / double quote).
276 separator
279 The string used to separate fields. Defaults to space.
280 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 This deals with the difference between a cell's contents and the
288 way those contents are formatted.
289 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 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 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 quoting-mode
308 When does data need to be quoted? "never", "auto" (puts quotes
309 where needed), or "always". Defaults to "auto".
310 quoting-on-whitespace
313 Controls whether initial or terminal whitespace forces quoting.
314 Defaults to TRUE.
315
319 To convert the Gnumeric file foo.gnumeric to a Microsoft Excel(TM) for‐
320 mat file foo.xls:
321 ssconvert foo.gnumeric foo.xls
323 The export format can be specified explicitly, to override the default
325 (which is based on the file extension):
326 ssconvert --export-type=Gnumeric_stf:stf_csv foo.xls foo.txt
328 To convert an Excel format file statfuns.xls to a text file, specifying
330 the semicolon as the separator character:
331 ssconvert -O 'separator=; format=raw' samples/excel/statfuns.xls stat‐
333 funs.txt
334
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
339 ⟨http://www.gnu.org⟩.
340
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
348 ssconvert's primary author is Jody Goldberg <jody@gnome.org>; ssconvert
349 builds on the Gnumeric codebase.
350 The initial version of this manpage was written by J.H.M. Dassen (Ray)
352 <jdassen@debian.org>.
353
356 gnumeric(1), ssdiff(1), ssgrep(1), ssindex(1)
357 The Gnumeric Homepage ⟨http://www.gnome.org/projects/gnumeric/⟩.
359 The GNOME project page ⟨http://www.gnome.org/⟩.
361gnumeric 2019-01-19 SSCONVERT(1)