Linux convert xlsx to xls

XLSX to XLS Converter

This is a free app to convert Xlsx to Xls format, also you can save the result to PDF, DOCX, PPTX, XLS, XLSX, XLSM, XLSB, XLT, ET, ODS, CSV, TSV, HTML, JPG, BMP, PNG, SVG, TIFF, XPS, JSON, XML, SQL, MHTML and Markdown.Convert Excel online from Mac OS, Linux, Android, iOS, and anywhere.

• Convert XLSX
• Save to desired format: PDF, XLS, XLSX, DOCX, PPTX, XLSM, XLSB, XLT, XLTX, XLTM, ODS, OTS, CSV, TSV, HTML, XHTML, JPG, BMP, PNG, WEBP, SVG, TIFF, XPS, MHTML, MD, JSON, XML, ZIP, SQL, TXT, ET, TABDELIMITED, FODS, SXC
• Quick way to convert multiple Excel spreadsheet files
• Easily save document as pdf, images or html
• Convert OpenDocument Spreadsheet
• Upload maximum 10 files and convert them simultaneously

How to convert XLSX to XLS

• Upload your XLSX files to convert.
• Press the «CONVERT» button.
• Download the converted XLS files instantly or send a download link to email.

Note that file will be deleted from our servers after 24 hours and download links will stop working after this time period.

Upload your XLSX files, choose the save format type and click on «Convert» button. You will get the download link as soon as the file is converted.

It works from all platforms including Windows, Mac, Android and iOS. All files are processed on our servers. No plugin or software installation required for you.

Powered by Aspose.Cells . All files are processed using Aspose APIs, which are being used by many Fortune 100 companies across 114 countries.

Источник

How to convert xlsx files to xls or csv format on Linux

The xlsx file name extension is a new file format based on XML, first used by Microsoft Office Excel 2007 spreadsheet application. The letter x appended to the existing xls extension used by earlier versions of Excel, signifies that the format is based on XML. If you would like to open or edit an xlsx file created by Excel 2007 or later, on an earlier version of Excel or any other spreadsheet application, you need to convert xlsx files first.

There are four different ways you can convert xlsx files on Linux.

Method One: Gnumeric

The first method is to use Gnumeric. Gnumeric is a free spreadsheet program which can import or export data in different file formats such as csv , xls and xlsx . Gnumeric comes with a command-line utility called ssconvert which can convert between different spreadsheet file formats. In order to convert xls files to xlsx or csv format by using Gnumeric, first install Gnumeric. Once Gnumeric is installed, you can use ssconvert .

$ sudo apt-get install gnumeric

Note that ssconvert accepts arguments in the following format.

$ ssconvert --export-type=ID [input file] [output file]

In the above, —export-type is optional, and without —export-type , ssconvert can infer export type from the extension of output file. If you want to explicitly specify export type, ID can be one of the following.

• Gnumeric_Excel:excel_dsf : Microsoft Excel 97/2000/XP, 5.0/95 format
• Gnumeric_Excel:xlsx : Microsoft Excel 2007
• Gnumeric_pdf:pdf_assistant : Portable Document Format (PDF)
• Gnumeric_stf:stf_csv: Comma Separated Values (CSV)

So if you would like to convert xlsx files to csv format using ssconvert :

$ ssconvert input.xlsx output.csv $ ssconvert --export-type=Gnumeric_stf:stf_csv input.xls output.txt

Method Two: xlsx2csv

The drawback of the Gnumeric-based method is that you need to install Gnumeric which may be too bloated software to install just for file conversion. A more lightweight way is to use xlsx2csv which is a python tool for xlsx to csv conversion.

$ git clone https://github.com/dilshod/xlsx2csv.git $ cd xlsx2csv $ ./xlsx2csv.py input.xlsx output.csv

Method Three: OpenOffice

Besides these methods, you can also use OpenOffice (if you already have it installed) to perform xlsx format conversions. OpenOffice comes with a command-line utility called unoconv which can convert xlsx files.

If you do not have it installed, you can install it with:

$ sudo apt-get install unoconv $ unoconv -f csv input.xlsx

Note that once you install unoconv using apt-get , it will install OpenOffice package as well.

Method Four: Google Docs

The final method of converting xlsx files is to use Google Spreadsheets. Google Spreadsheets can import Excel 2007 files. Thus, all you have to do is to import your xlsx file on to Google Docs Spreadsheet, click on Download as menu, and choose an appropriate file format: Excel ( xls ), PDF, CSV, Text. Note that document files which can be uploaded to Google Docs for conversion cannot be larger than 2MB .

Support Xmodulo

This website is made possible by minimal ads and your gracious donation via PayPal or credit card

Please note that this article is published by Xmodulo.com under a Creative Commons Attribution-ShareAlike 3.0 Unported License. If you would like to use the whole or any part of this article, you need to cite this web page at Xmodulo.com as the original source.

Источник

How to convert XLSX file to XLS or CSV file in Linux

In this article, I will take you through the steps to convert xlsx file to xls or csv file in Linux. Many times you might face a scenario where you have to read the data from the latest excel file in Linux but you cannot do it until you convert it to csv file.

Also there might be a scenario where you need to convert the latest excel file i.e xlsx file to the older excel format i.e xls file as you might not able to work with xlsx file directly. For all these scenarios we have few important tools available that can be employed to serve the purpose. We will discuss about those tools in below section with the help of examples.

How to convert XLSX file to XLS or CSV file in Linux

Step 1: Prerequisites

a) You should have a running Linux Server.

b) You should have sudo or root access to run privileged commands.

c) You should have xls2csv utility available in your System. You can check How to Install xls2csv on Ubuntu 20.04 LTS (Focal Fossa) to install the utility.

Step 2: Install Gnumeric

Gnumeric is a free and very powerful open source spreadsheet program available in Linux that can be employed to convert xlsx file to xls . To install this tool in a Ubuntu/Debian based systems, you just need to use sudo apt-get install gnumeric command as shown below.

cyberithub@ubuntu:~$ sudo apt-get install gnumeric Reading package lists. Done Building dependency tree Reading state information. Done The following packages were automatically installed and are no longer required: libfwupdplugin1 libllvm11 libxmlb1 Use 'sudo apt autoremove' to remove them. The following additional packages will be installed: gnumeric-common gnumeric-doc gsfonts libgoffice-0.10-10 libgoffice-0.10-10-common pxlib1 Suggested packages: gnumeric-plugins-extra libgsf-1-dev docbook-xsl The following NEW packages will be installed: gnumeric gnumeric-common gnumeric-doc gsfonts libgoffice-0.10-10 libgoffice-0.10-10-common pxlib1 0 upgraded, 7 newly installed, 0 to remove and 24 not upgraded. Need to get 20.8 MB of archives. After this operation, 69.1 MB of additional disk space will be used. Do you want to continue? [Y/n] Y Get:1 http://in.archive.ubuntu.com/ubuntu focal/universe amd64 gnumeric-common all 1.12.46-1ubuntu2 [2,665 kB] Get:2 http://in.archive.ubuntu.com/ubuntu focal/universe amd64 libgoffice-0.10-10-common all 0.10.46-1 [679 kB] Get:3 http://in.archive.ubuntu.com/ubuntu focal/universe amd64 libgoffice-0.10-10 amd64 0.10.46-1 [1,557 kB] Get:4 http://in.archive.ubuntu.com/ubuntu focal/universe amd64 pxlib1 amd64 0.6.8-1 [36.8 kB] Get:5 http://in.archive.ubuntu.com/ubuntu focal/universe amd64 gsfonts all 1:8.11+urwcyr1.0.7~pre44-4.4 [3,120 kB] Get:6 http://in.archive.ubuntu.com/ubuntu focal/universe amd64 gnumeric amd64 1.12.46-1ubuntu2 [2,319 kB] Get:7 http://in.archive.ubuntu.com/ubuntu focal/universe amd64 gnumeric-doc all 1.12.46-1ubuntu2 [10.4 MB] Fetched 20.8 MB in 7s (3,051 kB/s) Preconfiguring packages . Selecting previously unselected package gnumeric-common. (Reading database . 182730 files and directories currently installed.) Preparing to unpack . /0-gnumeric-common_1.12.46-1ubuntu2_all.deb . Unpacking gnumeric-common (1.12.46-1ubuntu2) . Selecting previously unselected package libgoffice-0.10-10-common. Preparing to unpack . /1-libgoffice-0.10-10-common_0.10.46-1_all.deb . Unpacking libgoffice-0.10-10-common (0.10.46-1) . Selecting previously unselected package libgoffice-0.10-10. Preparing to unpack . /2-libgoffice-0.10-10_0.10.46-1_amd64.deb . Unpacking libgoffice-0.10-10 (0.10.46-1) . Selecting previously unselected package pxlib1. Preparing to unpack . /3-pxlib1_0.6.8-1_amd64.deb . Unpacking pxlib1 (0.6.8-1) . Selecting previously unselected package gsfonts. Preparing to unpack . /4-gsfonts_1%3a8.11+urwcyr1.0.7~pre44-4.4_all.deb . Unpacking gsfonts (1:8.11+urwcyr1.0.7~pre44-4.4) . Selecting previously unselected package gnumeric. Preparing to unpack . /5-gnumeric_1.12.46-1ubuntu2_amd64.deb . Unpacking gnumeric (1.12.46-1ubuntu2) . Selecting previously unselected package gnumeric-doc. Preparing to unpack . /6-gnumeric-doc_1.12.46-1ubuntu2_all.deb . Unpacking gnumeric-doc (1.12.46-1ubuntu2) . Setting up gnumeric-common (1.12.46-1ubuntu2) . Setting up pxlib1 (0.6.8-1) . Setting up gnumeric-doc (1.12.46-1ubuntu2) . Setting up gsfonts (1:8.11+urwcyr1.0.7~pre44-4.4) . Setting up libgoffice-0.10-10-common (0.10.46-1) . Setting up libgoffice-0.10-10 (0.10.46-1) . Processing triggers for libc-bin (2.31-0ubuntu9.9) . Processing triggers for man-db (2.9.1-1) . Processing triggers for fontconfig (2.13.1-2ubuntu3) . Processing triggers for desktop-file-utils (0.24-1ubuntu3) . Processing triggers for mime-support (3.64ubuntu1) . Processing triggers for hicolor-icon-theme (0.17-2) . Processing triggers for gnome-menus (3.36.0-1ubuntu1) . Processing triggers for libglib2.0-0:amd64 (2.64.6-1~ubuntu20.04.4) . Setting up gnumeric (1.12.46-1ubuntu2) . Processing triggers for libc-bin (2.31-0ubuntu9.9) .

Step 3: Convert XLSX file to XLS file

ssconvert is one utility you will get after installing Gnumeric package in your System. To convert latest excel file format xlsx to the older xls format, you need to use ssconvert —export-type= syntax.

cyberithub@ubuntu:~$ ssconvert --export-type=Gnumeric_Excel:excel_dsf excel_example.xlsx excel_example.xls

Step 4: Convert XLS file to CSV file

Now if you want to convert XLS file to CSV then you need to use another tool called xls2csv . Here we have a XLS file called excel_example.xls which needs to be converted to excel_example.csv file. For that we are using xls2csv -x excel_example.xls -s cp1252 -d 8859-1 > excel_example.csv command as shown below.

cyberithub@ubuntu:~$ xls2csv -x excel_example.xls -s cp1252 -d 8859-1 > excel_example.csv

-x : print unknown Unicode chars as \xNNNN, rather than as question marks

-s : specifies source charset

-d : specifies destination charset name

After converting the file into CSV format, you can try to check the contents of the file by using cat excel_example.csv command as shown below.

cyberithub@ubuntu:~$ cat excel_example.csv "Employee ID","Employee Name","Department","Salary in $(per month)" "1098567","Cassie","Accounts","5200" "1076345","John","Finance","5200" "1045667","Mike","Facility","4800" "1023454","Chris","Engineering","6200" "1076256","Trevor","Medical ","6300" "1054864","Ryan","Security","4900" "Employee ID","Employee Name","Department","Salary in $(per month)" "1098567","Cassie","Accounts","5200" "1076345","John","Finance","5200" "1045667","Mike","Facility","4800" "1023454","Chris","Engineering","6200" "1076256","Trevor","Medical ","6300" "1054864","Ryan","Security","4900"

Источник