topic Re: Cant convert table of XY coordinates to Points properly in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/cant-convert-table-of-xy-coordinates-to-points/m-p/256934#M8802 <HTML><HEAD></HEAD><BODY><P>I opened the spreadsheet.&nbsp; You have errors</P><P></P><P>Y is longitude&nbsp;</P><P>X is latitude …. you have them switched</P><P></P><P>Your coordinate fields are indeed in decimal degrees (probably a GCS WGS84)</P><P></P><P>You have to get rid of blank rows and/or rows with no coordinates... this will cause failure with Excel to Table for sure</P><P></P><P>Your coordinates need to be in numeric fields... yours are left justified... make sure they aren't text but formatted as numbers as soon as you get rid of the rows with no coordinates</P></BODY></HTML> Fri, 01 Mar 2019 01:04:08 GMT DanPatterson_Retired 2019-03-01T01:04:08Z Cant convert table of XY coordinates to Points properly https://community.esri.com/t5/geoprocessing-questions/cant-convert-table-of-xy-coordinates-to-points/m-p/256933#M8801 <HTML><HEAD></HEAD><BODY><P>I</P></BODY></HTML> Thu, 28 Feb 2019 23:39:02 GMT https://community.esri.com/t5/geoprocessing-questions/cant-convert-table-of-xy-coordinates-to-points/m-p/256933#M8801 DavidSchwab1 2019-02-28T23:39:02Z Re: Cant convert table of XY coordinates to Points properly https://community.esri.com/t5/geoprocessing-questions/cant-convert-table-of-xy-coordinates-to-points/m-p/256934#M8802 <HTML><HEAD></HEAD><BODY><P>I opened the spreadsheet.&nbsp; You have errors</P><P></P><P>Y is longitude&nbsp;</P><P>X is latitude …. you have them switched</P><P></P><P>Your coordinate fields are indeed in decimal degrees (probably a GCS WGS84)</P><P></P><P>You have to get rid of blank rows and/or rows with no coordinates... this will cause failure with Excel to Table for sure</P><P></P><P>Your coordinates need to be in numeric fields... yours are left justified... make sure they aren't text but formatted as numbers as soon as you get rid of the rows with no coordinates</P></BODY></HTML> Fri, 01 Mar 2019 01:04:08 GMT https://community.esri.com/t5/geoprocessing-questions/cant-convert-table-of-xy-coordinates-to-points/m-p/256934#M8802 DanPatterson_Retired 2019-03-01T01:04:08Z