AnsweredAssumed Answered

Trouble turning Excel file into Feature Class

Question asked by albalter on Apr 4, 2018
Latest reply on Apr 10, 2018 by albalter

Using 10.3.1 - I am trying to learn how to take data from an Excel file and create a feature class. I have no issue creating a working shapefile, but when I try to convert the shapefile to a feature class (to put in a file geodatabase), the spatial data does not seem to transfer. The attribute table loads properly, but the points no longer show up on the map. I have checked each step of the way to make sure coordinate systems, names, etc. stay consistent. Also, if I have taken a convoluted route to completing this, please let me know. Here are my steps:

 

1. Excel > Table, via Conversion Tool

2. Right click Table > Display XY Data

3. Set coordinate system to GCS_WGS_1984

4. Points show on map perfectly

5. In Catalog, right-click Table > Create Feature Class> From XY Table

6. Input X,Y fields and change coordinate system to GCS_WGS_1984

7. Shapefile shows on map perfectly

8. In Catalog, right-click on Shapefile > Export to Geodatabase (single)

9. Feature Class created - points no longer show up on map - what am I missing?

 

I have the same issue when trying to use the Simple Data Loader to add data to existing Feature Class:

1. From Catalog, right-click Feature Class > Load Data

2. Loaded data both ways, from Table created above and from original Excel file

3. Attribute table looks fine

3. Points do not load on map 

 

Thank you!

Outcomes