Two Jupyter Notebooks highlight the process using
- openpyxl - using_openpyxl_csv_to_xlsx.ipynb
- xlsxwriter - using_xlsxwriter_csv_to_xlsx.ipynb
Both will accomplish the same task. Some claim OpenPyXL is more robust because it allows individual worksheet cells to be manipulated and worksheet styling. However, the documentation looks pretty robust for XlsxWriter.
OpenPyXL docs Creating Excel files with Python and XlsxWriter Working with Python Pandas and XlsxWriter
More to come...