Select to view content in your preferred language

ArcGIS for Excel Function Builder - Access functions from ArcGIS toolbar

1888
2
12-08-2022 01:04 PM
MrinmayeeBharadwaj
Esri Regular Contributor
2 2 1,888

This article was last updated on 07/11/2024

ArcGIS for Excel has formulas that you maybe familiar with in Microsoft Excel. With these formulas you can use to geocode, geoenrich, and perform route operations. Each function starts with the equal sign in a cell followed by the function name and the cell range it applies to. Once you get acclimated to all these functions, you can easily access them from the Function Builder tool on the ArcGIS for Excel toolbar. 

Note: You can use examples from the ArcGIS for Excel functions and formulas help topic to test these functions from the Function Builder. 

This video blog article is an overview of how to use the functions

  1. Open a Microsoft Excel sheet. 
  2. Access the ArcGIS tab. 
  3. Click the Function Builder button. 

MrinmayeeBharadwaj_0-1719608921026.png

 

The Function Builder opens in the Task pane, with parameters listed under categories. 

Note: You need to sign in to ArcGIS to access the Function Builder tool.

MrinmayeeBharadwaj_1-1719609128189.png

4. If you have chosen a populated or an empty cell, the selection or an error displays before you can proceed with a function selection.

MrinmayeeBharadwaj_2-1719609222881.png

5. Choose a function you wish to run from the following options:

MrinmayeeBharadwaj_3-1719609289087.png

NoteOnce you choose a function, the Task pane is populated with the chosen function and related fields and drop-down menus. After populating all parameter fields, you may choose to click, for example the Include column headers checkbox, then proceed with running the function by clicking  Insert. Depending on which function is selected, there may be additional options to check on/off. 

TipTo exit a function, click Close X. To return to the Function Builder home page click Cancel. 

6. Choose a function you wish to run from the following options:  

Geocoding functions: 

Parameters: (all fields with an asterisk, are required)

 

 

GETADDRESS 

 

MrinmayeeBharadwaj_5-1719609725907.png

 

GETCOORDINATES 

MrinmayeeBharadwaj_6-1719609830383.png

 


 

 

 

 

Geoenrichment functions: 

Parameters: (all fields with an asterisk, are required)

 

 

ENRICHBYPOINT 

MrinmayeeBharadwaj_7-1719609942873.png

 

ENRICHBYGEOGRAPHY 

MrinmayeeBharadwaj_8-1719610026419.png

 ENRICHBYADDRESS

 

MrinmayeeBharadwaj_0-1719611471771.png

 

Routing functions: 

Parameters: (all fields with an asterisk, are required)

 

 

FINDROUTE 

MrinmayeeBharadwaj_11-1719610152334.png

 

 

FINDROUTEBYADDRESS 

MrinmayeeBharadwaj_12-1719610211262.png

 

 

 

Helper functions: 

Parameters: (all fields with an asterisk, are required)

 

 

SUGGESTADDRESS 

MrinmayeeBharadwaj_13-1719610265246.png

 

 

LISTGEOGRAPHIES 

MrinmayeeBharadwaj_14-1719610329690.png

 

 

LISTDATACOLLECTIONS 

MrinmayeeBharadwaj_15-1719610445788.png

 

 

LISTTRAVELMODES 

This function has no parameters. It is already done and displaying results in your chosen cell. 

MrinmayeeBharadwaj_17-1719610501029.png

 

 

 

ADDHEADERS 

MrinmayeeBharadwaj_0-1719611536984.png

 

 

 

7. Once your Excel sheet is populated with information, do one of the following to return to the map frame: 

Click x, or click Show Map. You may also toggle between the two ArcGIS for Excel icons to switch between Function Builder and your map.

MrinmayeeBharadwaj_20-1719610880661.png

MrinmayeeBharadwaj_18-1670532647368.png

2 Comments