from pyexcel cookbook import merge_two_readers sheet pyexcel get_sheet(file_name="example csv"name_columns_by_row= sheet pyexcel get_sheet(file_name="example xls"name_columns_by_row= del sheet column[ del sheet column[ merge_two_readers(sheet sheet "output xls"merge two files into book where each file become sheet suppose you want to merge the following two data filesexample csv column column column example xls column column data ["column ""column ""column "][ ][ ][ pyexcel sheet(datas save_as("example csv"data ["column ""column "][ ][ pyexcel sheet(datas save_as("example xls"the following code will merge the tow into one filesay "output xls"from pyexcel cookbook import merge_all_to_a_book merge_all_to_a_book(["example csv""example xls"]"output xls"the output xls would have the following dataexample csv as sheet name and inside the sheetyou havecolumn cook book column column