...
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
- From the Ribbon, click the Analysis tab.
- From the Analysis tab, in the Geoprocessing group, click the Tools button. The Geoprocessing pane will appear on the right side of the screen.
- In the Geoprocessing pane, type Excel to Table.
- Select Excel to Table (Conversion Tools).
- For Input Excel File, click the Browse button.
- On the left side of the Browse window, click Folders.
- On the right side of the Browse window, double click the PlayMapping folder and choose IGOR_masterlist
- Under Output Table, name the table GIS_Wells.
- 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.
- Click Run.
- In the Contents pane, right-click the GIS_Wells table and select Display XY Data.
- Name the layer "GIS_Wells_Pts".
- Check that the X Field states "longitude" and the Y Field states "latitude".
- For Coordinate System, use the dropdown menu to select Current Map [Map]. The coordinate system should now be GCS_North_American_1927.
- Click Run.
- In the Contents pane, rick-click on GIS_Wells_Pts and select Zoom to Layer.
- In the Contents pane, right-click GIS_Wells_Pts and select Label.
- Right-click GIS_Wells_Pts and select Label Properties. A new pane, Label Class, will open on the right side of the screen.
- Under the Expression box, clear the current input.
- Under the Fields box, double click api_number. The Expression box should now read $feature.api_number.
- Click Apply.
- Above the Ribbon, on the Quick Access toolbar, click the Save button.
...