Page History

...

For more practice with displaying XY data, check out our short course: Mapping Locations Using XY Coordinates. For more information on working with Excel in ArcGIS Pro, check out this help resource: Work with Excel in ArcGIS Pro

1. From the Ribbon, click the Analysis tab.
2. From the Analysis tab, in the Geoprocessing group, click the Tools button. The Geoprocessing pane will appear on the right side of the screen. 
3. In the Geoprocessing pane, type Excel to Table. 
4. Select Excel to Table (Conversion Tools).
5. For Input Excel File, click the Browse button.
6. On the left side of the Browse window, click Folders.
7. On the right side of the Browse window, double click the PlayMapping folder and choose IGOR_masterlist
8. Under Output Table, name the table GIS_Wells.
9. From the Sheet drop down, choose the GIS_Wells sheet. This ensures that the GIS_Wells sheet will be the data converted from an excel table to a geodatabase table. 
10. Click Run.
11. In the Contents pane, right-click the GIS_Wells table and select Display XY Data.
12. Name the layer "GIS_Wells_Pts". 
13. Check that the X Field states "longitude" and the Y Field states "latitude". 
14. For Coordinate System, use the dropdown menu to select Current Map [Map]. The coordinate system should now be GCS_North_American_1927. 
15. Click Run.
16. In the Contents pane, rick-click on GIS_Wells_Pts and select Zoom to Layer.
17. In the Contents pane, right-click GIS_Wells_Pts and select Label.
18. Right-click GIS_Wells_Pts and select Label Properties. A new pane, Label Class, will open on the right side of the screen.
19. Under the Expression box, clear the current input. 
20. Under the Fields box, double click api_number. The Expression box should now read $feature.api_number.
21. Click Apply.
22. Above the Ribbon, on the Quick Access toolbar, click the Save button.

...