Create and maintain a Link between an Excel and a FeatureClass even having it published in AGOL using Basic License

04-26-2022 11:25 PM
Occasional Contributor


There is a workaround using ArcGIS PRO Basic License to do the following??

I have created a Featureclass (Points) with 3 fields and I want be able (right now or in the future) to create new features in this FeatureClass reading the Data from an excel (The excel structure machts the FeatureClass Table, with elements in the rows and 6 columns 3 with coordinates and 3 with Fields). The Feature Class is published in ArcGIS Online.

I have already tried: XY Table to Point" and "Join Table and Feature Class". It works but, later, I cannot publish the Feature Class with Basic License.

There is a way to do that? maybe with python?

0 Kudos
2 Replies
Occasional Contributor


I do something similar with Excel data that is populated by a co-worker and then published to ArcGIS Online by truncating and appending the existing hosted feature layer. 

I used modelbuilder to make a model that runs the Excel To Table tool, then XY Table To Point using a calculated date in the feature name, then Feature Class To Feature Class, essentially to overwrite my existing local feature class that is used to append to the online version. 

I created a script following the recommendations here  and added a tool to the model that points to that script, (Truncate Append tool in model below)


I have attached the script from the community post above.

When updates are made to the Excel file I manually run the model. 


0 Kudos
MVP Frequent Contributor

If you are just trying to add new features to the layer, can't you just use the "Update Data" option in the hosted Feature Class details page?  

Should append any data from the excel file to the layer.




0 Kudos