topic Re: transferring gps coordinates from excel in ArcGIS Mapping and Charting Questions https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470083#M1621 <HTML><HEAD></HEAD><BODY><P>Please send a screen shot of your field names and a few of the records.&nbsp; Thank you.&nbsp; Also, try saving the layer out as a csv file, there can be some formatting being held in the Excel file that would be removed in the csv.</P></BODY></HTML> Thu, 14 Jan 2016 19:25:49 GMT ChadKopplin 2016-01-14T19:25:49Z transferring gps coordinates from excel https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470080#M1618 <HTML><HEAD></HEAD><BODY><P>I transferred gps coordinates from excel into arcmap! Only a handful of my coordinates are showing up, whats causing this and how can I fix the problem! Thanks</P></BODY></HTML> Thu, 14 Jan 2016 19:09:52 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470080#M1618 JasonWaldvogel 2016-01-14T19:09:52Z Re: transferring gps coordinates from excel https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470081#M1619 <HTML><HEAD></HEAD><BODY><P>any blank rows? missing values?? was the spreadsheet formatted with columns set to numeric and the column field names space-less?&nbsp; </P><P>with excel, there are lots of ways things can go wrong.&nbsp; Get DNRGPS <A href="http://www.dnr.state.mn.us/mis/gis/DNRGPS/DNRGPS.html" title="http://www.dnr.state.mn.us/mis/gis/DNRGPS/DNRGPS.html">DNRGPS Application: Minnesota DNR</A>&nbsp; and use it to download your gps data, if it is still in your unit... it supports many formats, like shapefiles, etc</P></BODY></HTML> Thu, 14 Jan 2016 19:12:45 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470081#M1619 DanPatterson_Retired 2016-01-14T19:12:45Z Re: transferring gps coordinates from excel https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470082#M1620 <HTML><HEAD></HEAD><BODY><P>Could you share a sample of the points that don't show up. That would help to see what is going wrong...</P></BODY></HTML> Thu, 14 Jan 2016 19:16:55 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470082#M1620 XanderBakker 2016-01-14T19:16:55Z Re: transferring gps coordinates from excel https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470083#M1621 <HTML><HEAD></HEAD><BODY><P>Please send a screen shot of your field names and a few of the records.&nbsp; Thank you.&nbsp; Also, try saving the layer out as a csv file, there can be some formatting being held in the Excel file that would be removed in the csv.</P></BODY></HTML> Thu, 14 Jan 2016 19:25:49 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470083#M1621 ChadKopplin 2016-01-14T19:25:49Z Re: transferring gps coordinates from excel https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470084#M1622 <HTML><HEAD></HEAD><BODY><P>just found that half the coordinates are looked in a different state! could it be that some of the coordinates are off!</P></BODY></HTML> Thu, 14 Jan 2016 19:28:36 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470084#M1622 JasonWaldvogel 2016-01-14T19:28:36Z Re: transferring gps coordinates from excel https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470085#M1623 <HTML><HEAD></HEAD><BODY><P>again... it will not be possible to tell if you don't post some of the values.</P><P>Also, are the data in a projected coordinate system and you are near the boundary of a change in zones (like a utm zone for instance)</P></BODY></HTML> Thu, 14 Jan 2016 19:41:58 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470085#M1623 DanPatterson_Retired 2016-01-14T19:41:58Z Re: transferring gps coordinates from excel https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470086#M1624 <HTML><HEAD></HEAD><BODY><P>....hmmm perhaps it is the illegal transfer of coordinates over state lines ... problem</P></BODY></HTML> Thu, 14 Jan 2016 20:39:53 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/transferring-gps-coordinates-from-excel/m-p/470086#M1624 DanPatterson_Retired 2016-01-14T20:39:53Z