Customizing file formats with unoconv
Flexible Import/Export

© Photo by Hudson Hintze on Unsplash
A hidden utility in the LibreOffice toolbox, unoconv offers a wide array of import and export filter options for use at the command line.
LibreOffice is designed to save, import, or export one file at a time, using standard filter settings. The File menu allows you to choose PDF export options, but for most other types of files, you must use the default filter settings. If you want to save multiple files, or adjust the filter settings, you need to shift to the command line and run unoconv [1], a little known Python script that gives you greater control, both with a wide array of import and export filter options.
Unoconv is short for Universal Network Objects (UNO) conversion, a reference to the UNO API used by both LibreOffice and OpenOffice [2]. Bindings for UNO are available for most C++, Java, and Python compilers, and the API is used to create extensions, as well as to provide support for formats not visible in the LibreOffice desktop window, such as the obsolete LibreOffice 1.0 file formats.
Unsurprisingly, unoconv requires access to LibreOffice's resources. The easiest way to provide this access is to install unoconv on a system that already has LibreOffice installed. However, as detailed in the man page, you can also use the --connect
(-c
) option followed by a comma-separated list to define and connect to the location of a remote LibreOffice instance or --listener
(-l
) to have unoconv detect one.
Unoconv's basic command structure (Figure 1) is:

unoconv [FILE].EXTENSION
Other files can be added, either in a space-separated list or by using regular expressions. The command structure assumes that you are exporting the file(s) to PDF format, which is probably the most widely used operation for the command. The extension is the quickest way to specify the type of file, although alternatively you can use the option --doctype
(-d
) [TYPE]
, specifying document, graphics, presentation, or spreadsheet. Formulas, databases, or charts are not supported by unoconv – no doubt due to lack of demand, since these types of documents have existed in LibreOffice and its predecessor OpenOffice.org for over a decade. If you prefer to see confirmation that the command has been successfully carried out, you can also add up to three --verbose
(-v
) options – without at least one, unoconv only displays error messages, and the only sign of a completed conversion is the return to the command prompt.
If you want to change the export format, add the option --format=
(-f
). The supported formats for both exports and imports are displayed by running unoconv --show
. Supported formats include text, CSV, dBase, HTML, PDF, several versions of Microsoft Office formats, StarOffice formats (LibreOffice's original ancestor), common graphic formats, and, of course, current LibreOffice formats (Figure 2).

In addition, unoconv also includes several different housekeeping options. If a file's attributes matter, you can add --preserve
so that the output file has the same attributes as the original file. For batch conversions, you might want to use --output
(-o
) to place all the output files in a separate directory, rather than have them mixed together with the original files. The output file can also be password protected by adding:
--password= [PASSWORD]
Still another interesting option is to set the output file to the same format as the original, then add --template
(-t
) [FILE]
to add styles from another file to the output – a command-line version of the Load Styles feature in the Styles and Formatting window on LibreOffice's desktop interface.
Import and Export Filter Settings
For many users, the default filter settings are all that is needed. However, you can adjust both import and filter settings to your own preferences, using --export
(-e
) [SETTING]
or --import
(-i
) [SETTING]
. Among other purposes, this ability can be used as an easy method for adjusting the character encoding or date formats in the original file.
Filter settings are added directly after --export
(-e
) or --import
(-i
), with a separate option for each setting. For text and CSV files, these settings are introduced by FilterOptions=
and completed by a comma-separated list unique to the format. In the list, settings can be left blank (,,
) or at the end of the list omitted altogether, forcing the use of the default settings.
By contrast, PDF and graphics exports and imports are added after --export
(-e
) or --import
(-i
), with a separate option for each setting. In other words, to set a password and set the highest image resolution to 300dpi in a PDF file, the command would include:
--export PermissionPassword=abcdef --export MaxImageResolution=300
A complete list of standard import and export settings is available online [3], but it is far too long to mention here. However, different types of files have their own set of filter options.
Text Export and Import
For text import, the most common setting to customize is the encoding. A single value can be entered, such as
--import FilterOptions=76
which would set the encoding to UTF-8. However, for exporting text from a spreadsheet, the FilterOptions
fields are encoding, field-separator, text-delimiter, quote-all-text-cells, and save-cell-content-as-shown.
CSV Text File Import
CSV files have four basic settings. In order, they are the field separator, the text delimiter, the encoding, and the first line in the file to convert to or from a spreadsheet. For example,
--export FilterOptions=44,34,76,2
will set commas as the field separator, a double quotation mark as the text delimiter, UTF-8 as the encoding, and the first line in the file to the second. In theory, at the end of the settings, you could add the date format for each column, so that:
--export FilterOptions=44,34,76,2,1/5,2/5,3/5
would specify that the date formats for the first three columns would be YY/MM/DD. Any other columns would use the date format already specified for them.
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
Direct Download
Read full article as PDF:
Price $2.95
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Support Our Work
Linux Magazine content is made possible with support from readers like you. Please consider contributing when you've found an article to be beneficial.
News
-
Armbian 23.05 is Now Available
Based on Debian 12, the latest version of the ARM/RISC-V distribution is now available to download and install.
-
Linux Mint Finally Receiving Support for Gestures
If you use the Linux Mint Cinnamon desktop, you'll be thrilled to know that 21.2 is getting support for gestures on touchscreen devices and touchpads.
-
An All-Snap Version of Ubuntu is In The Works
Along with the standard deb version of the open-source operating system, Canonical will release an-all snap version.
-
Mageia 9 Beta 2 Ready for Testing
The latest beta of the popular Mageia distribution now includes the latest kernel and plenty of updated applications.
-
KDE Plasma 6 Looks to Bring Basic HDR Support
The KWin piece of KDE Plasma now has HDR support and color management geared for the 6.0 release.
-
Bodhi Linux 7.0 Beta Ready for Testing
The latest iteration of the Bohdi Linux distribution is now available for those who want to experience what's in store and for testing purposes.
-
Changes Coming to Ubuntu PPA Usage
The way you manage Personal Package Archives will be changing with the release of Ubuntu 23.10.
-
AlmaLinux 9.2 Now Available for Download
AlmaLinux has been released and provides a free alternative to upstream Red Hat Enterprise Linux.
-
An Immutable Version of Fedora Is Under Consideration
For anyone who's a fan of using immutable versions of Linux, the Fedora team is currently considering adding a new spin called Fedora Onyx.
-
New Release of Br OS Includes ChatGPT Integration
Br OS 23.04 is now available and is geared specifically toward web content creation.