Automatically linking excel table to shapefile

397
1
05-12-2018 08:39 AM
AnastasiaKrainyk
New Contributor

Hello everyone,

I have a shapefile in ArcGIS that is basically a grid. I also have an excel file where I can change values in some cells and a new table is produced. The table consists of two columns, the Grid ID and the Value. I was wondering if there is a way to link the excel table to ArcGIS shapefile so that as the values in the excel table change the automatically get updated in the shapefile. Currently I work in excel, then export file to a .csv file and join in to the ArcGIS grid shapefile. IS there a way to do this automatically?

Thanks

0 Kudos
1 Reply
DanPatterson_Retired
MVP Esteemed Contributor

No.  You  could write a script or model using your workflow to make it somewhat more convenient