topic Re: support in displaying decimal degree in excel 2013 sheet to UTM projection on ArcMap 10.1 in Data Management Questions https://community.esri.com/t5/data-management-questions/support-in-displaying-decimal-degree-in-excel-2013/m-p/704833#M39943 <HTML><HEAD></HEAD><BODY><P>There are some really good tips in the help. </P><P><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/understanding-how-to-use-microsoft-excel-files-in-arcgis.htm" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/understanding-how-to-use-microsoft-excel-files-in-arcgis.htm">Understanding how to use Microsoft Excel files in ArcGIS—Help | ArcGIS for Desktop</A> </P></BODY></HTML> Sat, 11 Jun 2016 23:34:58 GMT curtvprice 2016-06-11T23:34:58Z support in displaying decimal degree in excel 2013 sheet to UTM projection on ArcMap 10.1 https://community.esri.com/t5/data-management-questions/support-in-displaying-decimal-degree-in-excel-2013/m-p/704831#M39941 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Sat, 11 Jun 2016 15:33:38 GMT https://community.esri.com/t5/data-management-questions/support-in-displaying-decimal-degree-in-excel-2013/m-p/704831#M39941 Habtamu_Imiru 2016-06-11T15:33:38Z Re: support in displaying decimal degree in excel 2013 sheet to UTM projection on ArcMap 10.1 https://community.esri.com/t5/data-management-questions/support-in-displaying-decimal-degree-in-excel-2013/m-p/704832#M39942 <HTML><HEAD></HEAD><BODY><P>the coordinates must be in decimal degrees, not degree minutes seconds and other variants</P><P>ensure there are no blank rows ... in fact any blank cells</P><P>numbers are right justified, if yours are left, they are probably text.</P><P></P><P>If none of that twigs anything, post a screen shot of the top 10 or so rows and columns</P><P>PS</P><P>once it loads in arcmap, give it a defined geographic coordinate system (ie GCS WGS84)</P><P>Then you can project it to a new file in UTM</P></BODY></HTML> Sat, 11 Jun 2016 15:59:18 GMT https://community.esri.com/t5/data-management-questions/support-in-displaying-decimal-degree-in-excel-2013/m-p/704832#M39942 DanPatterson_Retired 2016-06-11T15:59:18Z Re: support in displaying decimal degree in excel 2013 sheet to UTM projection on ArcMap 10.1 https://community.esri.com/t5/data-management-questions/support-in-displaying-decimal-degree-in-excel-2013/m-p/704833#M39943 <HTML><HEAD></HEAD><BODY><P>There are some really good tips in the help. </P><P><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/understanding-how-to-use-microsoft-excel-files-in-arcgis.htm" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/understanding-how-to-use-microsoft-excel-files-in-arcgis.htm">Understanding how to use Microsoft Excel files in ArcGIS—Help | ArcGIS for Desktop</A> </P></BODY></HTML> Sat, 11 Jun 2016 23:34:58 GMT https://community.esri.com/t5/data-management-questions/support-in-displaying-decimal-degree-in-excel-2013/m-p/704833#M39943 curtvprice 2016-06-11T23:34:58Z Re: support in displaying decimal degree in excel 2013 sheet to UTM projection on ArcMap 10.1 https://community.esri.com/t5/data-management-questions/support-in-displaying-decimal-degree-in-excel-2013/m-p/704834#M39944 <HTML><HEAD></HEAD><BODY><P>Dear Dan,</P><P>thanks,</P><P></P><P>I will do as per your advice and post it as per your advice.</P><P></P><P>Thanks,</P><P></P><P>Habtamu</P></BODY></HTML> Sun, 12 Jun 2016 13:53:03 GMT https://community.esri.com/t5/data-management-questions/support-in-displaying-decimal-degree-in-excel-2013/m-p/704834#M39944 Habtamu_Imiru 2016-06-12T13:53:03Z