I have currently installed Excel 2013. I do have ArcGIS 10.1 on my machine. When I try to add excel sheet of x,y, z data in excel to ArcMap after exporting, it refused to display on Arcmap. I am a bit worried as how to convert the data to UTM and display it on ArcMap for further processing. So, kindly I need your support.
the coordinates must be in decimal degrees, not degree minutes seconds and other variants
ensure there are no blank rows ... in fact any blank cells
numbers are right justified, if yours are left, they are probably text.
If none of that twigs anything, post a screen shot of the top 10 or so rows and columns
once it loads in arcmap, give it a defined geographic coordinate system (ie GCS WGS84)
Then you can project it to a new file in UTM