5

I know you can use libreoffice as a command line tool and one parameter to convert formats is --convert-to, I do not know of other programs.

However, I do not know how to make it work, what do I have to type with libreoffice or another program to convert from excel to calc or the other way round?

sharkant
  • 1,361

1 Answers1

8

Use the default extension to indicate what you want to convert your file to:

libreoffice --convert-to xlsx filename.ods

to convert a Calc file to Excel (this will create filename.xlsx), or

libreoffice --convert-to ods filename.xlsx

the other way around.

If you want to convert a batch of files in one go, use a *:

libreoffice --convert-to ods *.xlsx

If this doesn't work, either enter the command with sudo, or fix ownership of your .config directory (see here):

sudo chown -R --reference="$HOME" ~/.config
Jos
  • 30,707
  • 2
    I recommend not using sudo; then you have the problem of the created files being root-owned, and that will continue until you're using root for everything - almost entirely defeating the point of having separate accounts. – wizzwizz4 Apr 25 '17 at 19:57