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.
Hi Tony,
I don't believe this is possible - New data can only be added if a location is defined by a cell/cells.
This can be done in ArcGIS Online though:
1. Add your spreadsheet in My Content
2. Add it to a new map
3. Add Map Notes
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
5. Use the Join Features—ArcGIS Online Help | ArcGIS tool to join the spreadsheet to the points using the common data.
I've had a go and it works well
Carmel