python data structuresdictionaryrecords and array here are the two functionsfunctions save_as(isave_as(save_book_as(isave_book_as(description works well with single sheet file works well with big data files works with multiple sheet file and big data files works with multiple sheet file and big data files if you would only use these two functions to do format transcodingyou may enjoy speed boost using isave_as(and isave_book_as()because they use yield keyword and minimize memory footprint howeveryou will need to call free_resource(to make sure file handles are closed and save_as(and save_book_as(reads all data into memory and will make all rows the same width see alsohow to save an python array as an excel file how to save dictionary of two dimensional array as an excel file how to save an python array as csv file with special delimiter data transportation/transcoding this library is capable of transporting your data between any of the following data sourcesphysical file memory file sqlalchemy table django model python data structuresdictionaryrecords and array see alsohow to import an excel sheet to database using sqlalchemy how to open an xls file and save it as xlsx how to open an xls file and save it as csv architecture pyexcel uses loosely couple plugins to fullfil the promise to access various file formats lml is the plugin management library that provide the specialized support for the loose coupling what is loose couplingthe components of pyexcel is designed as building blocks for your projectyou can cherry-pick the file format support without affecting the core functionality of pyexcel each plugin will bring in additional dependences for exampleif you choose pyexcel-xlsxlrd and xlwt will be brought in as nd level depndencies support the project