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 +++ +++ +++ +++sheet +++ +++ +++ +++sheet +++ +++ +++ +++working with databases 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 baseimport os import pyexcel as from 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 model new tutorial