Get data x = Import["C:\\Book1.xlsx", {"Sheets", "Sheet1"}] Recover the integers for instance like this y = Floor /@ x[[1]] // Flatten (* Out[202]= {Floor["Student ID"], 2014512060, 2013512024, 2013512028} *) Just the data are then z = Drop[y,1] (* Out[203]= {2014512060, 2013512024, 2013512028} *)