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

will convert xlsx to csv


name of the original Excel file to insert into Clickhouse table


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


name of the table to insert data to

rm tmp.csv

remove temporary file after data is inserted