import pyexcel book pyexcel get_book(file_name="yourfile xls"for sheet in bookdo you processing with sheet do filteringpass book save_as("output xls"what would happen if save multi sheet book into "csvfile wellyou will get one csv file per each sheet suppose you have these codecontent 'sheet '[ ][ ][ ]'sheet '[' '' '' '][ ][ ]'sheet '[' '' '' '][ ][ book pyexcel book(contentbook save_as("myfile csv"you will end up with three csv filesimport glob outputfiles glob glob("myfile_csv"for file in sorted(outputfiles)print(filemyfile__sheet __ csv myfile__sheet __ csv myfile__sheet __ csv and their content is the value of the dictionary at the corresponding key alternativelyyou could use save_book_as(function pyexcel save_book_as(bookdict=contentdest_file_name="myfile csv" support the project