csv2xls

# CSV to XLS python
import pandas as pd
import os
from tkinter import Tk, filedialog
import glob
from pathlib import Path

root = Tk()
root.withdraw()
root.attributes('-topmost', True)
open_folder = filedialog.askdirectory()

print(open_folder)

for (filename) in glob.glob(open_folder + '/*.csv'):
    handle = pd.read_csv(filename, delimiter = ';')
    handle.to_excel(open_folder +'/'+ Path(open_folder + '/' + filename).stem + '.xls', index = False, header = False)
    print(Path(open_folder + '/' + filename).stem + '.xls')