support in displaying decimal degree in excel 2013 sheet to UTM projection on ArcMap 10.1

[Habtamu_Imiru]

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.

[DanPatterson_Retired]

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

PS

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

[Habtamu_Imiru]

Dear Dan,

thanks,

I will do as per your advice and post it as per your advice.

Thanks,

Habtamu

[curtvprice]

There are some really good tips in the help.

Understanding how to use Microsoft Excel files in ArcGIS—Help | ArcGIS for Desktop