noteplease note that csv(comma separate valuefile is pure text file formulachartsimages and formatting in xls file will disappear no matter which transcoding tool you use hencepyexcel is quick alternative for this transcoding job let use previous example and save it as xlsx instead save_as(file_name="birth xls"dest_file_name="birth xlsx"change the file extension again let' verify what we have gottensheet get_sheet(file_name="birth xlsx"sheet pyexcel_sheet +++name weight birth +++adam +++smith +++excel book merge and split operation in one line merge all excel files in directory into book where each file become sheet the following code will merge every excel files into one filesay "output xls"from pyexcel cookbook import merge_all_to_a_book import glob merge_all_to_a_book(glob glob("your_csv_directory\csv")"output xls"you can mix and match with other excel formatsxlsxlsm and ods for exampleif you are sure you have only xlsxlsmxlsxods and csv files in your_excel_file_directoryyou can do the followingfrom pyexcel cookbook import merge_all_to_a_book import glob merge_all_to_a_book(glob glob("your_excel_file_directory\*")"output xls"split book into single sheet files suppose you have many sheets in work book and you would like to separate each into single sheet excel file you can easily do thisfrom pyexcel cookbook import split_a_book split_a_book("megabook xls""output xls"import glob outputfiles glob glob("*_output xls"(continues on next page support the project