us tuple of tuples (each containing cell objects)and columns gives us tuple of tuples (each containing cell objectsto access one particular tupleyou can refer to it by its index in the larger tuple for exampleto get the tuple that represents column byou use list(sheet columns)[ to get the tuple containing the cell objects in column ayou' use list(sheet columns)[ once you have tuple representing one row or columnyou can loop through its cell objects and print their values workbookssheetscells as quick reviewhere' rundown of all the functionsmethodsand data types involved in reading cell out of spreadsheet file import the openpyxl module call the openpyxl load_workbook(function get workbook object use the active or sheetnames attributes get worksheet object use indexing or the cell(sheet method with row and column keyword arguments get cell object read the cell object' value attribute projectreading data from spreadsheet say you have spreadsheet of data from the us census and you have the boring task of going through its thousands of rows to count both the total population and the number of census tracts for each county ( census tract is simply geographic area defined for the purposes of the census each row represents single census tract we'll name the spreadsheet file censuspopdata xlsxand you can download it from /automatestuff its contents look like figure - figure - the censuspopdata xlsx spreadsheet