Excel into ArcGIS PRO - update values etc.

Question

Hello Everyone!

I'm wondering if there is a way to import excel file into ArcGIS PRO and occasionally update it and get some values to GIS. For example, I have to make a report with map, in this report need to be shown a values on geometry fields. Values would be in that excel file. File would be stored somewhere on PC. I would like to open that file and update values but not sure if changes would be seen in GIS. Maybe with join tool/function? Or is there a need for some kind of scripting or with the GIS tools would be enough?

Another example, in excel file there is value from 1 to 5 (earthquake marks), somehow add that file into GIS and with range, and country district will change color (1 - blue, ... 5 - red etc.) by taking these values ​​into account.

ABishop · Answer

Hello GIS_Rookie,

I am glad to help!  If you have a ArcGIS license, you pay for maintenance which unlocks the opportunity to use your account in ArcGIS Online to sign into the learning dashboard and take some lessons on how to use ModelBuilder.  I encourage you to do this!

To get you started, here is a link:  www.esri.com/training/catalog/57630433851d31e02a43eebc/

GIS_Rookie · Answer

Thanks for the answers @ABishop !

I have no experience working with modelbuilder. Will google it.

In answer to your question, I would say that two people would use it. That means the file should be stored somewhere on the server, right?

tigerwoulds · Answer

Have you seen this? Work with Microsoft Excel files in ArcGIS Pro—ArcGIS Pro | Documentation