how to get dictionary from an excel sheet how to obtain records from an excel sheet how to obtain dictionary from multiple sheet book the following two variants of the data access function use generator and should work well with big data files functions iget_array(iget_records(table list of variant functions name memory efficient two dimensional array memory efficient list list of dictionaries python name generator of list of lists generator of list of dictionaries howeveryou will need to call free_resource(to make sure file handles are closed two pyexcel functions in cases where the excel data needs custom manipulationsa pyexcel user got few choicesone is to use sheet and bookthe other is to look for more sophisticated onespandasfor numerical analysis do-it-yourself functions get_sheet(get_book(returns sheet book for all six functionsyou can pass on the same command parameters while the return value is what the function says export data from python this library provides one application programming interface to transform them into one of the data structurestwo dimensional array (ordereddictionary of one dimensional arrays list of dictionaries dictionary of two dimensional arrays sheet book and write to one of the following data sourcesphysical file memory file sqlalchemy table django model design