Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Convert multiple xlsx files to csv files then merge multiple csv files into one
for i in *.xlsx; do libreoffice --headless --convert-to csv "$i" ; done
awk '(NR == 1) || (FNR > 1)' *.csv > all.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment