Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Convert multiple xlsx files to csv files then merge multiple csv files into one
#!/bin/bash
# https://stackoverflow.com/a/21651707/9238321
for i in *.xlsx; do libreoffice --headless --convert-to csv "$i" ; done
# https://unix.stackexchange.com/a/558965
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