Page History

...

1. From the Ribbon, click the Analysis tab.
2. 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 right side of the Browse window, click Folders.
7. On the left side of the Browse window, double click the Workshop_Data folder and choose IGOR_masterlist
8. select the IGOR - master list.xlsx sheet in your Playmapping folder.
9. Label the Output Table as Under Output Table, name the table GIS_Wells.
10. Ensure that From the Sheet section displays 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 in ArcGIS. 
11. Click Run.
12. In the Contents tabpane, right-click the GIS_Wells Table table and click select Display XY Data.
13. Ensure that the X Field states longitude and the Y Field states latitude. Name the Layer GIS_Wells. For Spatial Reference, use the dropdown menu to select Current Map [Map]. The Spatial Reference should now be GCS_North_American_1927. Click Run.
14. Zoom to the GIS_Wells Layer if you are unable to see the points.
15. Right click GIS_Wells and click Label.
16. Open GIS_Wells1 Label Properties. Go to the Labels Class tab and under Class > Expression, clear the Expression code. Under Fields, double click api_number. Click apply.
17. Above the ribbon, on the Quick Access toolbar, click the Save button.

...