Install xlsx2csv on Ubuntu 20.04

The xlsx2csv is a tool that enables to convert MS Excel (XLSX) files to CSV files via command line. This tool requires the Python interpreter.

This tutorial explains how to install xlsx2csv on Ubuntu 20.04.

Install xlsx2csv

Make sure the package lists are up-to-date:

sudo apt update

Install xlsx2csv using command:

sudo apt install -y xlsx2csv

When installation is completed, we can check version of xlsx2csv:

xlsx2csv --version

Testing xlsx2csv

For testing purpose, download XLSX file:

wget -O test.xlsx https://raw.githubusercontent.com/dilshod/xlsx2csv/master/test/xlsx2csv-test-file.xlsx

Execute the xlsx2csv command to convert XLSX file to CSV file:

xlsx2csv test.xlsx test.csv

Check the content of the CSV file:

cat test.csv

A,B,C
,MSP,
,MSP,
...........
blah,PPS,
blah,PPS,

Command can write results to standard output. Run command without specifying the name of the CSV file as second argument:

xlsx2csv test.xlsx

Uninstall xlsx2csv

If the xlsx2csv is no longer necessary, it can be removed with command:

sudo apt purge --autoremove -y xlsx2csv