read the sheet as dictionary suppose you have csvxlsxlsx file as the followingthe following code will give you data series in dictionary"example xls","example xlsx","example xlsmsheet pyexcel get_sheet(file_name="example_series xls"name_columns_by_row= sheet to_dict(ordereddict([('column '[ ])('column '[ ])('column '[ '- ])]can get an array of dictionaries per each rowsuppose you have the following datathe following code will produce what you want"example csv","example xlsx","example xlsmsheet pyexcel get_sheet(file_name="example xls"name_columns_by_row= records sheet to_records(for record in recordskeys sorted(record keys()print("{"for key in keysprint("'% ':% (keyrecord[key])print("}"' ': ' ': ' ': ' ': ' ': ' ': ' ': ' ': ' ': writing single sheet excel file suppose you have an array as the following the following code will write it as an excel file of your choice support the project