Convert CSVs into Excel Worksheet Tabs

csvs-to-xlsx.py

"""                                                                             
Convert CSVs into Excel sheets                                                  
"""
                                                                             
import glob                                                                               
import pandas as pd                                                             
                                                                                                                                             
with pd.ExcelWriter("output.xlsx") as writer:                                   
    for file in glob.glob("*.csv"):                                             
        df = pd.read_csv(file)                                                  
        df.to_excel(writer, sheet_name=file.replace(".csv", ""), index=False)