Trouble turning Excel file into Feature Class

1423
4
04-04-2018 09:12 AM
Highlighted
New Contributor

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!

Tags (1)
Reply
0 Kudos
4 Replies
Highlighted
Regular Contributor

Thank you Alyssa, could you please share the Excel file or the exported table?  Chad

Reply
0 Kudos
Highlighted
MVP Esteemed Contributor

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

I'm assuming you got to this point in ArcMap?  If so, you have an xy event table in your TOC: what if right click on it and save it directly to a fgdb feature class....

Highlighted
MVP Esteemed Contributor

tip.... when a file ...'doesn't show'.... put it in its own dataframe (arcmap) or map (pro) without any other data, especially basemaps.  If it shows, then it is fine, but it may need to have a defined coordinate system if it doesn't behave with other data.  

As for excel http://pro.arcgis.com/en/pro-app/help/data/excel/work-with-excel-in-arcgis-pro.htm

know the rules and only use it sparingly and convert it to a featureclass prior to doing anything else.

Highlighted
New Contributor

Thanks for the help! 

Reply
0 Kudos