table list of supported file formats file format csv tsv csvz tsvz xls xlsx xlsm ods fods 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 flat open document spreadsheet java script object notation html table of the data structure simple presentation rstructured text presentation of the data media wiki table usage suppose you want to process the following excel data here are the example usagesimport pyexcel as pe records pe iget_records(file_name="your_file xls"for record in recordsprint("% is aged at % (record['name']record['age'])adam is aged at beatrice is aged at ceri is aged at dean is aged at pe free_resources( design introduction this section introduces excel data modelsits representing data structures and provides an overview of formattingtransformationmanipulation supported by pyexcel data models and data structures when dealing with excel filespyexcel pay attention to three primary objectscellsheet and book book contains one or more sheets and sheet is consisted of sheet name and two dimensional array of cells although sheet can contain charts and cell can have formulastyling propertiesthis library ignores them and only pays attention to the data in the cell and its data type soin the context of this librarythe definition of those three concepts are usage