Originally published April 3, 2018 @ 2:07 pm

The other day I ran into the “Flexible Import/Export” article by Bruce Byfield in the March 2018 issue of Linux Pro Magazine and thought it could use some more detail. So here’s some more detail.

The unoconv utility is a part of LibreOffice. All examples below were ran on RHEL 7.3. The first step is to get the latest version of LibreOffice. This is not necessary, but may save you some time and aggravation.

Remove any existing installations of LibreOffice and install the latest stable release from one of the project’s mirrors:

Now, download a more up-to-speed version of unoconv and replace the one that came with your LibreOffice installation. Once again, this is not necessary, but is a good idea.

Add a startup file for the unoconv listener and add an appropriate selinux rule, if your system is using selinux.

Now with the installation out of the way, here come the examples.

You can find additional options for the unoconv utility’s PDF import/export functionality here. There was some talk about adding a command-line option to unoconv to allow the user to specify the sheet name or number during the conversion of a multi-sheet spreadsheet.

I don’t know if anything came out of this. I was not able to find a version of unoconv with this capability. So not to leave this question unanswered, here’s how you can use xlsx2csv tool to work with multi-sheet spreadsheets.