if you want to preserve the order of sheets in your dictionaryyou have to pass on an ordered dictionary to the function itself for exampledata ordereddict(data update({"sheet "a_dictionary_of_two_dimensional_arrays['sheet ']}data update({"sheet "a_dictionary_of_two_dimensional_arrays['sheet ']}data update({"sheet "a_dictionary_of_two_dimensional_arrays['sheet ']}pyexcel save_book_as(bookdict=datadest_file_name="book xls"let' verify its orderbook_dict pyexcel get_book_dict(file_name="book xls"for keyitem in book_dict items()print(json dumps({keyitem}){"sheet "[[" "" "" "][ ][ ]]{"sheet "[[ ][ ][ ]]{"sheet "[[" "" "" "][ ][ ]]please notice that "sheet is the first item in the book_dictmeaning the order of sheets are preserved how to import an excel sheet to database using sqlalchemy noteyou can find the complete code of this example in examples folder on github before going aheadlet' import the needed components and initialize sql engine and table basefrom sqlalchemy import create_engine from sqlalchemy ext declarative import declarative_base from sqlalchemy import column integerstringfloatdate from sqlalchemy orm import sessionmaker engine create_engine("sqlite:///birth db"base declarative_base(session sessionmaker(bind=enginelet' suppose we have the following database modelclass birthregister(base)__tablename__='birthid=column(integerprimary_key=truename=column(stringweight=column(floatbirth=column(datelet' create the tablebase metadata create_all(enginenow here is sample excel file to be saved to the tablehere is the code to import itsession session(obtain sql session pyexcel save_as(file_name="birth xls"name_columns_by_row= dest_ '-session=sessiondest_table=birthregisterdone it it is that simple let' verify what has been imported to make sure support the project