Very often you need to export to Excel files. Not all of us like this file format, but sometimes it is requested and we can’t do anything about it. One of the examples are external audits. External auditors very often ask for data exports in Excel. I have created simple tool to utilise exports from ClickHouse to Excel 2010 format.
Most important highlights are:
- http/https connection to ClickHouse
- Automatic split of result to several files, configurable.
- Fully commandline
- All in one binary
- Code Source available
For more details and instalation instructions check its project page chxlsxExportTool