TSSFL TECHNOLOGY STACK

Posted: **Thu Feb 23, 2023 12:02 pm**

Assume your excel files are in some directory, move into that directory and execute the command below which uses LibreOffice in bash/Terminal to convert all your excel files into CSV files:

Code: [Select all] [Expand/Collapse]

for i  in *.xlsx; do  libreoffice --headless --convert-to csv "$i" ; done

Or install csvkit:

Code: [Select all] [Expand/Collapse]

sudo apt-get install csvkit

and use it to convert your excel files into CSV files as

Code: [Select all] [Expand/Collapse]

in2csv data.xlsx > data.csv

See more excel_to_csv

TSSFL TECHNOLOGY STACK

Convert Excel Files to CSV in Linux

Convert Excel Files to CSV in Linux