file format csv tsv csvz tsvz xls xlsx xlsm ods json html simple rst mediawiki definition comma separated values tab separated values zip file that contains one or many csv files zip file that contains one or many tsv files spreadsheet file format created by ms-excel - ms-excel extensions to the office open xml spreadsheetml file format an ms-excel macro-enabled workbook file open document spreadsheet java script object notation html table of the data structure simple presentation rstructured text presentation of the data media wiki table see also list of file formats supported by external plugins data transformation often developer would like to have excel data imported into python data structure this library supports the conversions from previous three data source to the following list of data structuresand vice versa table list of supported data structures pesudo name python name two dimensional array list of lists dictionary of key value pair dictionary dictionary of one dimensional arrays dictionary of lists list of dictionaries list of dictionaries dictionary of two dimensional arrays dictionary of lists of lists related model pyexcel sheet pyexcel sheet pyexcel sheet pyexcel sheet pyexcel book data manipulation the main operation on cell involves cell accessformatting and cleansing the main operation on sheet involves group access to row or columndata filteringand data transformation the main operation in book is obtain access to individual sheets data transcoding for various reasons the data in one format needs to be transcoded into another this library provides transcoding tunnel for data transcoding between supported file formats data visualization via pyexcel renderer abstractrenderer interfacedata visualization is made possible pyexcel-chart is the interface plugin to formalize this effort pyexcel-pygal is the first plugin to provide barpiehistogram charts and more quoted from whatis com technical details can be found at msdn xls xlsx is used by ms-excel more information can be found at msdn xlsx design