import glob2 path_xls = glob2.glob(r'.\*.xls') path_xlsx = glob2.glob(r'.\*.xlsx') print(path_xls) print(path_xlsx)