This article was last updated on 12/08/2023
ArcGIS for Excel has formulas similar to Microsoft Excel that you can use to geocode, geoenrich, and 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.
The Function Builder opens in the Task pane, with Choose function and Set parameters tabs visible.
4. Click the Don’t show this again checkbox to skip this welcome screen the next time you want to access the Function Builder.
5. Click OK.
6. The Choose function tab is enabled by default with function drop-down lists visible.
7. If you have chosen a populated cell, or an empty cell, that cell number will be visible in the Choose function pane description, for example G9 in the screenshot below:
8. Choose a function you wish to run from the following options:
Note: Once you choose a function, the related Set parameters tab opens immediately. After populating all parameter fields, you may choose to Add Header, or proceed with running the function by clicking Update.
Tip: To exit a function, click the Choose function tab. This returns you to the functions drop-down lists.
Geocoding functions: | Parameters: |
|
|
Longitude(X) – required Latitude(Y) – required All_data – type this value as “TRUE” geocode_service | |
Address – required Match_details geocode_service | |
|
|
Geoenrichment functions: | Parameters: |
|
|
Longitude(X) – required Latitude(Y) – required Distance Unit Travel_mode Variables -
- browse through the list of data collections variables. Click Close to exit and return to the ENRICHBYPOINT function pane. Include_derivative_variables Include_point_details
| |
Area_id
– required. Browse through the list of areas. Click
to return to the ENRICHBYGEOGRAPHY function pane. Geography_level_id
– required. Browse through the list of countries, and their respective geography levels. Click
to return to the ENRICHBYGEOGRAPHY function pane. Variables -
- browse through the list of data collections variables. Click Close to exit and return to the ENRICHBYPOINT function pane. Include_derivative_variables Include_geography_details | |
address - Required distance - Optional unit - Optional travel_mode - Optional variables - Optional include_derivative_variables - Optional include_point_details - Optional |
Routing functions: | Parameters: |
|
|
From_longitude(X) – required From_latitude(Y) – required To_longitude(X) – required To_latitude(Y) – required Travel_mode
- browse through the list of travel modes supported for routing operations. Click
to return to the FINDROUTE function pane. Unit Include_directions | |
|
|
From_address – required To_address – required Travel_mode
- browse through the list of travel modes supported for routing operations. Click
to return to the FINDROUTE function pane. Unit Include_directions | |
|
|
Helper functions: | Parameters: |
|
|
Text – required Max_suggestions Country geocode_service | |
|
|
Country Geography_level_id
– required. Browse through the list of countries, and their respective geography levels. Click
to return to the LISTGEOGRAPHIES function pane. Search_term exact_match | |
|
|
Country – required Data_collection_id Search_term | |
|
|
This function has no parameters. It is already done and displaying results in your chosen cell. | |
|
|
ARCGIS_function - required | |
|
|
Once your Excel sheet is populated with all desired information, do one of the following to return to the map frame:
9. Click x
10. Click the ArcGIS for Excel icon
11. Click Show map
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.