play with data suppose you have the following data in any of the supported excel formats againsheet pyexcel get_sheet(file_name="example_series xls"name_columns_by_row= you can get headersprint(list(sheet colnames)['column ''column ''column 'you can use utility function to get all in dictionarysheet to_dict(ordereddict([('column '[ ])('column '[ ])('column '[ '- ])]maybe you want to get only the data without the column headers you can call rows(insteadlist(sheet rows()[[ ][ ][ ]attributes attributesimport pyexcel content " , , \ , , sheet pyexcel get_sheet(file_type="csv"file_content=contentsheet tsv ' \ \ \ \ \ \ \ \nprint(sheet simplecsv what' moreyou could as well set value to an attributefor example:import pyexcel content " , , \ , , sheet pyexcel sheet(sheet csv content sheet array [[ ][ ]you can get the direct access to underneath stream object in some situationit is desiredstream sheet stream tsv the returned stream object has tsv formatted content for reading what you could further do is to set memory stream of any supported file format to sheet for exampleanother_sheet pyexcel sheet(another_sheet xls sheet xls another_sheet content (continues on next page new tutorial