(continued from previous pagewagner,verdi are from late romantic period ( - sergei rachmaninoff,calude debussy are from modernist period ( th centurywhere start_row skips the header row get dictionary you can get dictionary toomy_dict get_dict(file_name="your_file xls"name_columns_by_row= and let' have look insidefrom pyexcel _compact import ordereddict isinstance(my_dictordereddicttrue for keyvalues in my_dict items()print(key ',join([str(itemfor item in values])name medieval,renaissance,baroque,classical,early romantic,late romantic,modernist period - , - , - , - , - , '- , th century representative composers machautlandini,gibbonsfrescobaldi,js bachvivaldi'-joseph haydnwolfgan amadeus mozart,chopinmendelssohnschumannliszt,wagner'-verdi,sergei rachmaninoff,calude debussy please note that my_dict is an ordereddict get dictionary of two dimensional array suppose you have multiple sheet book as the followinghere is the code to obtain those sheets as single dictionarybook_dict get_book_dict(file_name="book xls"and checkisinstance(book_dictordereddicttrue import json for keyitem in book_dict items()print(json dumps({keyitem}){"most expensive violins"[["name""estimated value""location"]["messiah '-stradivarious"" , , ""ashmolean museum in oxfordengland"]'-"vieuxtemps guarneri"" , , ""on loan to anne akiko meyers"]["lady blunt '-"" , , ""anonymous bidder"]]{"noteable violin makers"[["maker""period""country"]["antonio stradivari"'-" - ""cremonaitaly"]["giovanni paolo maggini"" - ""botticino'-italy"]["amati family"" - ""cremonaitaly"]["guarneri family"" '- ""cremonaitaly"]["rugeri family"" - ""cremonaitaly"]["carlo '-bergonzi"" - ""cremonaitaly"]["jacob stainer"" - ""austria '-"]]{"top violinist"[["name""period""nationality"]["antonio vivaldi"" - "'"italian"]["niccolo paganini"" - ""italian"]["pablo de sarasate"'-" - ""spainish"]["eugene ysaye"" - ""belgian"]["fritz kreisler (continues on next page'-"" - ""astria-american"]["jascha heifetz"" - ""russian'-american"]["david oistrakh"" - ""russian"]["yehundi menuhin"" '- ""american"]["itzhak perlman"" -""israeli-american"]["hilary hahn" support the project '" -""american"]]