topic Re: Is it possible to create coordinate columns in excel by selecting the location in the map? in ArcGIS Mapping and Charting Questions https://community.esri.com/t5/arcgis-mapping-and-charting-questions/is-it-possible-to-create-coordinate-columns-in/m-p/561279#M1917 <HTML><HEAD></HEAD><BODY><P>Hi Tony,&nbsp;</P><P></P><P>I don't believe this is possible - New data can only be added if a location is defined by a cell/cells.</P><P>This can be done in ArcGIS Online though:</P><P>1. Add your spreadsheet in My Content&nbsp;</P><P>2. Add it to a new map</P><P>3. Add Map Notes</P><P>4. Create pins where you want them on the map - make sure to fill in the title with what matches the point to the row in the spreadsheet</P><P>5. Use the <A class="link-titled" href="http://doc.arcgis.com/en/arcgis-online/analyze/join-features.htm" title="http://doc.arcgis.com/en/arcgis-online/analyze/join-features.htm">Join Features—ArcGIS Online Help | ArcGIS</A>&nbsp;tool to join the spreadsheet to the points using the common data.</P><P></P><P>I've had a go and it works well</P><P></P><P>Carmel</P></BODY></HTML> Wed, 24 May 2017 16:29:09 GMT CarmelConnolly 2017-05-24T16:29:09Z Is it possible to create coordinate columns in excel by selecting the location in the map? https://community.esri.com/t5/arcgis-mapping-and-charting-questions/is-it-possible-to-create-coordinate-columns-in/m-p/561278#M1916 <HTML><HEAD></HEAD><BODY><P>Is it possible to create coordinate columns in excel by selecting the location in the map? (In ArcGis Maps for Office) I have a spreadsheet with no location data currently, and rather than populating the coordinates manually, I would like to visually select in the map.</P></BODY></HTML> Thu, 18 May 2017 17:16:13 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/is-it-possible-to-create-coordinate-columns-in/m-p/561278#M1916 TonyKnievel 2017-05-18T17:16:13Z Re: Is it possible to create coordinate columns in excel by selecting the location in the map? https://community.esri.com/t5/arcgis-mapping-and-charting-questions/is-it-possible-to-create-coordinate-columns-in/m-p/561279#M1917 <HTML><HEAD></HEAD><BODY><P>Hi Tony,&nbsp;</P><P></P><P>I don't believe this is possible - New data can only be added if a location is defined by a cell/cells.</P><P>This can be done in ArcGIS Online though:</P><P>1. Add your spreadsheet in My Content&nbsp;</P><P>2. Add it to a new map</P><P>3. Add Map Notes</P><P>4. Create pins where you want them on the map - make sure to fill in the title with what matches the point to the row in the spreadsheet</P><P>5. Use the <A class="link-titled" href="http://doc.arcgis.com/en/arcgis-online/analyze/join-features.htm" title="http://doc.arcgis.com/en/arcgis-online/analyze/join-features.htm">Join Features—ArcGIS Online Help | ArcGIS</A>&nbsp;tool to join the spreadsheet to the points using the common data.</P><P></P><P>I've had a go and it works well</P><P></P><P>Carmel</P></BODY></HTML> Wed, 24 May 2017 16:29:09 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/is-it-possible-to-create-coordinate-columns-in/m-p/561279#M1917 CarmelConnolly 2017-05-24T16:29:09Z