Adding New Data

559
3
01-09-2020 06:19 AM
JasonWaldvogel
New Contributor

Trying to add new data from an excel file into an existing layer with same information in Arcmap. How would a go about doing that?

0 Kudos
3 Replies
deleted-user-NvcfpBOWaKwr
Occasional Contributor

Does your excel file contain X Y data?

0 Kudos
JasonWaldvogel
New Contributor

Yes it does.

0 Kudos
deleted-user-NvcfpBOWaKwr
Occasional Contributor

It's been a while since I have done XY data. Going from memory this should be the workflow. All of the mentioned tools below can be found in ArcMap under the "Geoprocessing" tab then click on "Search For Tools". The Geoprocessing pane will open and you can then search for tools.  

1) Convert your excel file to a CSV, this can be done within excel

Import or export text (.txt or .csv) files - Excel 

2) Within ArcMap click File > Add Data >  Add XY Data. Follow the onscreen instructions. Once the XY layer shows up in your Table Of Contents, right click the XY layer name and click Data > Export Data and export the layer as a feature class. Below is a link to a small tutorial to help you with Adding and exporting XY data.

Adding x,y coordinate data as a layer—Help | ArcGIS for Desktop 

****Loading new data into existing feature class****

3) Right click the feature class you need to add the new information to and select "Load"  then "Load Data" or use the "Append tool". Use the newly created feature class from the previous steps as the input data. Run the tool

Note: You will probably be asked to map the fields from the new feature class to the destination feature class. It's pretty straight forward. Just match the destination fields to the corresponding source fields. 

If you have any questions or run into problems please let us know

Hope this helps!

0 Kudos