3 ms·
xsv is great -- as is csvkit, which preceded it and is probably a bit slower, but has a few extra utilities that I find essential: - in2csv: extracts Excel wor
by danso 8y ago
xsv is great -- as is csvkit, which preceded it and is probably a bit slower, but has a few extra utilities that I find essential:
- in2csv: extracts Excel worksheets into CSV
- csvsql: produces (and executes) the SQL needed to create a table and insert the data from a CSV
I found these scripts to be profoundly useful when working with govt data and needing to provide a automated workflow that collects and collates their Excel spreadsheets and converts them into CSV and SQLite databases.