content '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"after have saved my multiple sheet book in csv formathow do get them back first of allyou can read them back individual as csv file using meth:~pyexcel get_sheet method secondlythe pyexcel can do the magic to load all of them back into book you will just need to provide the common name before the separator "__"book pyexcel get_book(file_name="myfile csv"book sheet +++ +++ +++ +++(continues on next page old tutorial