Is it possible to create coordinate columns in excel by selecting the location in the map?

802
1
05-18-2017 10:16 AM
Labels (1)
TonyKnievel
New Contributor

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.

0 Kudos
1 Reply
CarmelConnolly
Esri Regular Contributor

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