9951 explained code solutions for 126 technologies


clickhouseInsert XLSX (Excel) into Clickhouse table


You'll need ssconvert installed to insert Excel into Clickhouse:

ssconvert file.xlsx tmp.csv
cat tmp.csv | clickhouse -q "INSERT INTO tbl FORMAT CSV"
rm tmp.csvctrl + c
ssconvert

will convert xlsx to csv

file.xlsx

name of the original Excel file to insert into Clickhouse table

tmp.csv

name of the temporary csv file which will be fed to Clickhouse

tbl

name of the table to insert data to

rm tmp.csv

remove temporary file after data is inserted