ArcGIS for Excel functions

Note:

Some workflows may require specific privileges. For more information about user types, roles, and privileges, see the Accounts topic.

Note:

You must sign in to an ArcGIS account to use the ArcGIS for Excel functions.If you are not signed in, a sign in error appears when you hover over the green triangle in the upper left corner of a selected cell. In Microsoft Windows Desktop or macOS, you will also see a yellow warning icon.

Microsoft Excel includes a set of functions or formulas that you can use to calculate information, from simple arithmetic sums to complex population of cells.

ArcGIS for Excel includes similar functions that you can use for geocoding, data enrichment, and performing route operations. Each function starts with an equal sign (=) in a cell followed by the function name and its input parameters, if any, in parentheses.

See Get started with ArcGIS for Excel to learn about setting up an ArcGIS for Excel map.

Tip:

As you write a function in a cell, you can use cell references by selecting a specific cell or cells in a column or row. This ensures data integrity. See the Microsoft Create or change a cell reference article for more information.

Note:

The geocoding, GeoEnrichment Service , and routing functions consume credits. The SUGGESTADDRESS function consumes credits when you request more than 15 suggestions. Helper Functions do not consume credits. Your ArcGIS functions are cached to prevent additional credit consumption if and when the functions are refreshed. This cache increases the size of your Microsoft Excel file. To clear the ArcGIS for Excel functions cache, click the Clear cache button in the Settings pane.

You can copy the examples in this topic into an Excel worksheet to visualize how functions work. You can also use the ArcGIS for Excel functions in the ArcGIS Function Builder tool.

Some ArcGIS functions may fail with an error that the service is not available when running them within a cell in Excel. Contact your organization administrator to enable the service or get more information.

See the ArcGIS Enterprise and ArcGIS Online documentation for more information about services.

The following sections describe the ArcGIS for Excel functions and include the syntax, an example, and descriptions of the parameters.

Note:

In the function examples below, the actual result of the functions excludes the header. Run the ADDHEADERS function to request the headers.

GETADDRESS

Determine the address at a particular longitude-latitude location through reverse geocoding.

Syntax

ARCGIS.GETADDRESS(longitude(X), latitude(Y), [spatial_reference], [all_data], [geocode_service])

Parameters

ParameterDescriptionParameter required

longitude(X)

The longitude of the point from which to search for the closest address.

Yes

latitude(Y)

The latitude of the point from which to search for the closest address.

Yes

spatial reference

The spatial reference for the point location. This can be either a WKID (number) or WKT (text). See the list of valid WKID values. The default is 4326 (WGS84).

No

all_data

If set to TRUE, this returns not just the reverse-geocoded address name but also all address properties, such as City or Region. The default is FALSE.

No

geocode_service

Choose a geocoding service from the drop-down menu. The service lists all the locators available to members of your organization.

No

Function example 1

=ARCGIS.GETADDRESS(-70.251, 43.65808)

Result

Address

Standard Baking, 75 Commercial St, Portland, ME, 04101, USA

Function example 2

=ARCGIS.GETADDRESS(-70.251, 43.65808, 4326, TRUE)

Result

Address matchedFull address nameShort address nameAddress typeType Place nameStreet numberStreet nameBlockSectorNeighborhoodDistrictCityMetropolitan areaSub-regionRegionRegion abbreviationTerritoryPostal codePostal code extensionCountryCountry code

Standard Baking

Standard Baking, 75 Commercial St, Portland, ME, 04101, USA

Standard Baking

POI

Bakery

Standard Baking

75

75 Commercial St.

Portland

Cumberland county

Maine

ME

04101

United States

USA

GETCOORDINATES

Geocode a location. This returns possible locations including longitude, latitude, and, optionally, the address matched and the match score.

Syntax

ARCGIS.GETCOORDINATES(address, [spatial_reference], [match_details], [geocode_service])

Parameters

ParameterDescriptionParameter required

address

The location to be geocoded. This can be a street address, place-name, postal code, or POI.

Yes

spatial reference

The spatial reference for the point location. This can be either a WKID (number) or WKT (text). See the list of valid WKID values. The default is 4326 (WGS84).

No

match_details

If set to TRUE, this returns not just the longitude and latitude but also the address name of the matched point and the match score. The default is FALSE.

No

geocode_service

Choose a geocoding service from the drop-down menu. The service lists all the locators available to members of your organization.

No

Note:

In all the function examples, the actual result of the functions excludes the header. Run the ADDHEADERS function to request the headers.

Function example 1

=ARCGIS.GETCOORDINATES("380 New York Street, Redlands, CA, USA")

Result

Longitude (X)Latitude (Y)

-117.19479

34.057265

Function example 2

=ARCGIS.GETCOORDINATES("380 New York Street, Redlands, CA, USA", 4326 , TRUE)

Result

Longitude (X)Latitude (Y)AddressMatch scoreGeolocatorAddress type

-117.1948

34.057265

380 New York St, Redlands, CA, 92373, USA

100

World

PointAddress

ENRICHBYGEOGRAPHY

Get information about the people, places, and businesses in specific named administrative boundaries—or levels of geography—of a map, such as districts, states and postal codes.

Syntax

ARCGIS.ENRICHBYGEOGRAPHY(area_id, geography_level_id, [data_collections], [variables], [include_derivative_variables], [include_geography_details])

Parameters

ParameterDescriptionParameter required

area_id

The FIPS ID of the area where demographic information will be obtained. Run the LISTGEOGRAPHIES function to request a list of area IDs for a particular geography level. For example, "06" is the State of California.

Yes

geography_level_id

The ID of the geography level to which the area ID belongs. Run the LISTGEOGRAPHIES function to request a list of area IDs for a particular geography level. For example, "US.States" is the states in the United States.

Yes

data_collections

Preassembled lists of attributes that are used to enrich the input features.

Run the LISTDATACOLLECTIONS function to request a list of data collections. An example is "KeyUSFacts, KeyGlobalFacts". The default is KeyGlobalFacts.

No

analysis_variables

Variables to be returned from the data collections—for example, KeyGlobalFacts.TOTPOP, AGE.MALE5. If left blank, all variables of the data collection KeyGlobalFacts are requested.

Run the LISTDATACOLLECTIONS function to request a list of variables, or review the Data Collection Finder to see a list of variables.

No

include_derivative_variables

Derivative variables to include in the output. This can be percent, index average, or all. If left blank, no derivative variable will be included.

No

include_geography_details

If set to TRUE, this will include the associated geography details, such as country code, geography level, and area ID. The default is FALSE.

No

Function example 1

=ARCGIS.ENRICHBYGEOGRAPHY("06","US.States")

Result

Total populationTotal householdsAverage household sizeMale populationFemale population

39770476

13570050

2.86

19767455

20003021

Function example 2

=ARCGIS.ENRICHBYGEOGRAPHY("08019","ES.Municipalities", "IncomeTotalsAIS")

Result

2020 Total household income per year 2020 Average household income per year 2020 Average household income per month 2020 Average annual income per capita 2020 Average monthly income per capita

1.99E + 10

29898.9

2491.57

11938.06

994.84

Note:

In all the function examples, the actual result of the functions excludes the header. Run the ADDHEADERS function to request the headers.

Function example 3

=ARCGIS.ENRICHBYGEOGRAPHY("08019","ES.Municipalities", , "KeyGlobalFacts.AVGHHSZ, IncomeTotalsAIS.NINCHA")

Result

Average household size 2020 Average household income per year

2.5

29898.9

Function example 4

=ARCGIS.ENRICHBYGEOGRAPHY("06","US.States","health", "X8001_X, X8021_X", "index", TRUE)

Result

Standard geography level Standard geography name Standard geography ID Country code 2022 Health care 2022 Health care: index 2022 Dental services 2022 Dental services: index

U.S. States

California

06

US

1.08894E+11

113

7.37E+09

119

ENRICHBYADDRESS

Get enriched demographic information about the people, places, and businesses in a specific area or within a certain distance or drive time from an address. The default distance is within a one-mile radius of the point.

Syntax

ARCGIS.ENRICHBYADDRESS(address, [distance], [unit],[travel_mode],[data_collections],[variables],[include_derivative_variables], [include_studyarea_details])

Parameters

ParameterDescriptionParameter required

address

The location to be geocoded. This can be a street address, place-name, postal code, or POI.

Yes

distance

The radius or distance from the point, which is used to compute the ring buffer area for the demographic data. For example, use 3 for a three-mile radius. The default is 1.

No

unit

The unit of measurement for the distance parameter. This can be meters, kilometers, feet, yards, miles, or nautical miles. If the travel_mode parameter is set, this can also be seconds, minutes, or hours. The default is miles.

No

travel_mode

If this is set, it will compute an area using travel distance from the point of interest. This can be walking, driving, or trucking. If left blank, a ring buffer area will be computed.

No

analysis_variables

Variables to be returned from the data collections—for example, KeyGlobalFacts.TOTPOP, AGE.MALE5. If left blank, all variables of the data collection KeyGlobalFacts are requested.

Run the LISTDATACOLLECTIONS function to request a list of variables, or review the Data Collection Finder to see a list of variables.

No

include_derivative_variables

Derivative variables to include in the output. This can be percent, index, average, or all. If left blank, no derivative variable will be included.

No

include_studyarea_details

If set to TRUE, this will include the associated study area details, such as the radius and distance measurement method used to compute the relevant area around the point. Default is FALSE.

No

Function example 1

=ARCGIS.ENRICHBYADDRESS("380 New York Street, Redlands, CA, USA")

Result

Total populationTotal householdsAverage household sizeMale populationFemale population

11464

4860

1.98

5745

5719

Note:

In all the function examples, the actual result of the functions excludes the header. Run the ADDHEADERS function to request the headers.

Function example 2

=ARCGIS.ENRICHBYADDRESS("380 New York Street, Redlands, CA, USA", 5, "miles", "driving", "health", "X8001_X, X8021_X", "index", TRUE)

Result

Country codeArea typeBuffer units aliasBuffer radii2022 Healthcare2022 Healthcare: index2022 Dental services2022 Dental services: index

US

NetworkServiceArea

Drive Distance Miles

5

240971277

99

15463985

99

ENRICHBYPOINT

Get enriched demographic information about the people, places, and businesses in a specific area or within a certain distance or drive time from a location. The default distance is within a one-mile radius of the point.

Syntax

ARCGIS.ENRICHBYPOINT(longitude(X), latitude(Y), [spatial_reference], [distance], [unit],[travel_mode],[data_collections],[variables],[include_derivative_variables], [include_studyarea_details])

Parameters

ParameterDescriptionParameter required

longitude(X)

The longitude of the point of interest.

Yes

latitude(Y)

The latitude of the point of interest.

Yes

spatial_reference

The spatial reference for the point location. This can be either a WKID (number) or WKT (text). See the list of valid WKID values. The default is 4326 (WGS84).

No

distance

The radius or distance from the point, which is used to compute the ring buffer area for the demographic data. For example, use 3 for a three-mile radius. The default is 1.

No

unit

The unit of measurement for the distance parameter. This can be meters, kilometers, feet, yards, miles, or nautical miles. If the travel_mode parameter is set, this can also be seconds, minutes, or hours. The default is miles.

No

travel_mode

If this is set, it will compute an area using travel distance from the point of interest. This can be walking, driving, or trucking. If left blank, a ring buffer area will be computed.

No

data_collections

Preassembled lists of attributes that will be used to enrich the input features.

Run the LISTDATACOLLECTIONS function to request a list of data collections. For example, use KeyUSFacts, KeyGlobalFacts. The default is KeyGlobalFacts.

No

analysis_variables

Variables to be returned from the data collections—for example, KeyGlobalFacts.TOTPOP, AGE.MALE5. If left blank, all variables of the data collection KeyGlobalFacts are requested.

Run the LISTDATACOLLECTIONS function to request a list of variables, or review the Data Collection Finder to see a list of variables.

No

include_derivative_variables

Derivative variables to include in the output. This can be percent, index, average, or all. If left blank, no derivative variable will be included.

No

include_studyarea_details

If set to TRUE, this will include the associated study area details, such as the radius and distance measurement method used to compute the relevant area around the point. Default is FALSE.

No

Function example 1

=ARCGIS.ENRICHBYPOINT(-90.491, 38.777)

Result

Total populationTotal householdsAverage household sizeMale populationFemale population

11464

4860

1.98

5745

5719

Note:

In all the function examples, the actual result of the functions excludes the header. Run the ADDHEADERS function to request the headers.

Function example 2

=ARCGIS.ENRICHBYPOINT(-90.491, 38.777, 4326, 5, "miles", "driving", "health", "X8001_X, X8021_X", "index", TRUE)

Result

Country codeArea typeBuffer units aliasBuffer radii2022 Healthcare2022 Healthcare: index2022 Dental services2022 Dental services: index

US

NetworkServiceArea

Drive Distance Miles

5

240971277

99

15463985

99

FINDROUTE

Find the total travel distance (the default measurement unit is miles) and time (in minutes) between two locations using the best route found.

Syntax

ARCGIS.FINDROUTE(from_longitude(X), from_latitude(Y), to_longitude(X), to_latitude(Y), [spatial_reference], [travel_mode], [unit], [include_directions])

Parameters

ParameterDescriptionParameter required

from_longitude(X)

The longitude coordinates of the starting location of the route.

Yes

from_latitude(Y)

The latitude coordinates of the starting location of the route.

Yes

to_longitude(X)

The longitude coordinates of the destination location of the route.

Yes

to_latitude(Y)

The latitude coordinates of the destination location of the route.

Yes

spatial_reference

The spatial reference for the point location. This can be either a WKID (number) or WKT (text). See the list of valid WKID values. The default is 4326 (WGS84).

No

travel_mode

The travel mode for the route. Instead of a ring buffer area, compute an area using a travel mode, for example, walking, driving, or trucking.

For example, use Driving Distance or Walking Time. Run the LISTTRAVELMODES function to request a list of supported travel modes. If left blank, the default travel mode specified in your ArcGIS organization settings is used. See Configure travel modes to learn more about travel modes and parameters.

No

unit

The measurement unit for the travel distance. This can be miles, kilometers, meters, feet, points, yards, or nautical miles. The default is miles.

No

include_directions

If set to TRUE, the routing directions to the destination and the time and distance traveled at each step will be included in the results. The default is FALSE.

No

Function example 1

=ARCGIS.FINDROUTE(-77.24488778, 38.92894278, -80.78300851, 35.1001845)

Result

Distance traveled (miles)Time traveled (minutes)

391.3764

401.6001295

Note:

In all the function examples, the actual result of the functions excludes the header. Run the ADDHEADERS function to request the headers.

Function example 2

=ARCGIS.FINDROUTE(-77.24488778, 38.92894278, -80.78300851, 35.1001845, 4326, "Driving Distance", "miles", TRUE)

Result

DescriptionDistance traveled (miles)Time traveled (minutes)

Total Distance/Time Traveled

382.7767

408.1581

Start at Location 1

0

0

Go East

0.03108

0.300162

Turn right on Springbank Ln

0.087211

0.421049

Finish at Location 2, on the left

0

0

FINDROUTEBYADDRESS

Find the total travel distance (the default measurement unit is miles) and time (in minutes) between two addresses using the best route found.

Syntax

ARCGIS.FINDROUTEBYADDRESS(from_address, to_address, [travel_mode], [unit], [include_directions])

Parameters

ParameterDescriptionParameter required

from_address

The address of the starting location of the route.

Yes

to_address

The address of the destination location of the route.

Yes

travel_mode

The travel mode for the route. Instead of a ring buffer area, compute an area using a travel mode, for example, walking, driving, or trucking.

For example, use Driving Distance or Walking Time. Run the LISTTRAVELMODES function to request a list of supported travel modes. If left blank, the default travel mode specified in your ArcGIS organization settings is used. See Configure travel modes to learn more about travel modes and parameters.

No

unit

The measurement unit for the travel distance. This can be miles, kilometers, meters, feet, yards, or nautical miles. The default is miles.

No

include_directions

If set to TRUE, the routing directions to the destination and the time and distance traveled at each step will be included in the results. The default is FALSE.

No

Function example 1

=ARCGIS.FINDROUTEBYADDRESS("380 New York Street Redlands CA", "Downtown Riverside")

Result

Distance traveled (miles)Time traveled (minutes)

14.32662

20.73435

Function example 2

=ARCGIS.FINDROUTEBYADDRESS("380 New York Street Redlands CA", "Downtown Riverside", "Driving Distance", "kilometers", TRUE)

Result

DescriptionDistance traveled (kilometers)Time traveled (minutes)

Total Distance/Time Traveled

22.9899

22.40177

Start at Location 1

0

0

Go Southwest

0.092545

0.555303

At the traffic light, turn right on University Ave

0.427128

0.672165

Finish at Location 2, on the left

0

0

LISTDATACOLLECTIONS

List the data collections available for a country.

Syntax

ARCGIS.LISTDATACOLLECTIONS(country, [data_collection_id], [search_term])

Parameters

ParameterDescriptionParameter required

country

The source country of the data collections. For example, use United Kingdom. Run the LISTGEOGRAPHIES function to request a list of countries.

Yes

data_collection_id

The ID of a data collection. For example, use KeyFacts. If a value is specified, all variables of the data collection are listed. If left blank, all data collections for the specified country are listed.

No

search_term

A search term that narrows the results by matching the search term with the data collection names and descriptions or variable names and descriptions. For example, use fast food.

No

Function example

=ARCGIS.LISTDATACOLLECTIONS("USA")

Result

IDDescriptionExample data

1yearincrements

The 1 Year Increments data collection includes population counts by 1-year age breaks up to age 84 for 2023 and 2028. The collection also includes 2010 population by single year increments up to age 21. The data tables include age for total population and age by gender. This collection contains data from the Esri 2023/2028 Updated Demographic database and Esri Census 2010 database.

  • 2023 Population Age <1
  • 2023 Population Age 10
  • 2023 Population Age 35

5yearincrements

The 5 Year Increments data collection includes population counts by 5-year age breaks for 2023, 2028, and 2010. The data tables include age for the total population and age by gender. This collection contains data from the Esri 2023/2028 Updated Demographic database, American Community Survey (ACS) database, and Census 2010 database.

  • 2023 Population Age 0-4
  • 2023 Population Age 25-29
  • 2023 Population Age 40-44

Age

This data collection includes age range data for males and females used for data pyramid infographics. This collection contains Esri 2023 Updated Demographic data.

  • 2023 Males Age 0-4
  • 2023 Females Age 5-9
  • 2023 Males Age 60-64

=ARCGIS.LISTDATACOLLECTIONS("USA","health")

Result

IDNameDescription

REL65HI2OC

2023 Pop 65+: Other Health Ins Combos REL (ACS 5-Yr)

2023 Population 65+: Other Health Ins Combinations REL (ACS 5-Yr)

ACSCIVNINS

2023 Civ Noninstitutionalized Population (ACS 5-Yr)

2023 Civilian Noninstitutionalized Population (ACS 5-Yr)

MOECIVNINS

2023 Civ Noninstitutionalized Population MOE (ACS 5-Yr)

2023 Civilian Noninstitutionalized Population MOE (ACS 5-Yr)

=ARCGIS.LISTDATACOLLECTIONS("USA", "health", "<19")

Result

IDNameDescription

ACSCIVNI0

2023 Civ Noninstitutionalized Pop <19 (ACS 5-Yr)

2023 Civilian Noninstitutionalized Pop <19 (ACS 5-Yr)

ACS0ONEHI

2023 Pop <19: 1 Type of Health Ins (ACS 5-Yr)

2023 Population <19: One Type of Health Insurance (ACS 5-Yr)

MOE0ONEHI

2023 Pop <19: 1 Type of Health Ins MOE (ACS 5-Yr)

2023 Population <19: One Type of Health Insurance MOE (ACS 5-Yr)

Note:

In all the function examples, the actual result of the functions excludes the header. Run the ADDHEADERS function to request the headers.

LISTGEOGRAPHIES

Depending on the input parameters, a list of countries, a list of geography levels (for example, districts or provinces) of a country, or a list of the area IDs for a geography level is returned. The maximum list item limit is 5,000.

Syntax

ARCGIS.LISTGEOGRAPHIES([country], [geography_level_id], [search_term], [exact_match])

Parameters

ParameterDescriptionParameter required

country

The source country of the data collections. For example, use United Kingdom. If a value is specified, all geography levels for that country are listed. If left blank, all countries and territories are listed.

No

geography_level_id

The ID of a geography level. For example, use US.States for the states in the United States. If a value is specified, all areas of a geography level, such as California, and their FIPS IDs are listed. If left blank, the results are dependent on the country parameter.

No

search_term

A search term that narrows the results by matching the search term with the geography names.

No

exact_match

Only return results matching your exact search term.

No

Function example

=ARCGIS.LISTGEOGRAPHIES()

Result

CountryCountry code

Albania

AL

Algeria

DZ

Andorra

AD

Angola

AO

Anguilla

AI

=ARCGIS.LISTGEOGRAPHIES("USA")

Result

IDName

US.WholeUSA

Entire Country

US.States

States

US.DMA

DMAs

US.CD

Congressional Districts

US.CBSA

CBSAs

US.Counties

Counties

US.CSD

County Subdivisions

US.ZIP5

Zip Codes

US.Places

Cities and Towns (Places)

US.Tracts

Census Tracts

US.BlockGroups

Block Groups

=ARCGIS.LISTGEOGRAPHIES("Spain","ES.Municipalities")

Result

IDNameMajor geography subdivision

01001

Alegría-Dulantzi

País Vasco

01002

Amurrio

País Vasco

01003

Aramaio

País Vasco

01004

Artziniega

País Vasco

01006

Armiñón

País Vasco

=ARCGIS.LISTGEOGRAPHIES("Spain","ES.Municipalities","Barcelona")

IDNameMajor geography subdivision

08019

Barcelona

Cataluña

SUGGESTADDRESS

Suggest addresses based on a text input. This can be used as an interactive autocomplete address search.

Syntax

ARCGIS.SUGGESTADDRESS(search_term, [max_suggestions], [country], [geocode_service])

Parameters

ParameterDescriptionParameter required

search_term

The input text provided by a user, which is used to generate a list of possible matches.

Yes

max_suggestions

The maximum number of suggestions to be returned. If this number is greater than 15, the suggestions will be made by the geocoding operation, which may consume additional credits and may lead to unexpected results. The default is 5. Maximum is 50.

No

country

Limits the results to a particular country. For example, use United Kingdom. Run ARCGIS.LISTGEOGRAPHIES to request a list of countries.

No

geocode_service

The maximum number of suggestions to be returned. If this number is greater than 15, the suggestions will be made by the geocoding operation, which may consume more credits and may lead to different results. Default is 5. Maximum is 50.

No

Function example

=ARCGIS.SUGGESTADDRESS("Orange county",10, "USA")

Result

Orange County, CA, USA

Orange County, FL, USA

Orange County, IN, USA

Orange County, NC, USA

Orange County, NY, USA

Orange County, TX, USA

Orange County, VA, USA

Orange County, VT, USA

Orange County Great Park, Irvine, CA, USA

Orange County Airport, 500 Dunn Rd, Montgomery, NY, 12549, USA

LISTTRAVELMODES

List all travel modes of the route service supported by ArcGIS Online or configured for your organization.

Note:

This function requires no parameters. For a similar example, see the Microsoft RAND function article.

Syntax

ARCGIS.LISTTRAVELMODES()

Function example

=ARCGIS.LISTTRAVELMODES()

Result

NameDescriptionDetails

Driving Time

Models the movement of cars and other similar small automobiles, such as pickup trucks, and finds solutions that optimize travel time. Travel obeys one-way roads, avoids illegal turns, and follows other rules that are specific to cars. When you specify a start time, dynamic travel speeds based on traffic are used where it is available.

Avoid Carpool Roads; Avoid Express Lanes; Avoid Gates; Avoid Private Roads; Avoid Unpaved Roads; Driving an Automobile; Roads Under Construction Prohibited; Through Traffic Prohibited; Vehicle Maximum Speed (km/h): TravelTime 0

Walking Time

Follows paths and roads that allow pedestrian traffic and finds solutions that optimize travel time. The walking speed is set to 5 kilometers per hour.

Avoid Private Roads; Avoid Roads Unsuitable for Pedestrians; Preferred for Pedestrians; Walking Speed (km/h): WalkTime 5; Walking

Walking Distance

Follows paths and roads that allow pedestrian traffic and finds solutions that optimize travel distance.

Avoid Private Roads; Avoid Roads Unsuitable for Pedestrians; Preferred for Pedestrians; Walking Speed (km/h): WalkTime 5; Walking

Note:

In all the function examples, the actual result of the functions excludes the header. Run the ADDHEADERS function to request the headers.

ADDHEADERS

Create a header row only for the output of the ArcGIS for Excel GETADDRESS, GETCOORDINATES, ENRICHBYGEOGRAPHY, ENRICHBYPOINT, FINDROUTE, and FINDROUTEBYADDRESS functions.

Note:

This function requires only one parameter.

Note:

In all the function examples, the actual result of the functions excludes the header. Run the ADDHEADERS function to request the headers.

Syntax

ARCGIS.ADDHEADERS(ARCGIS_function)

Parameters

ParameterDescriptionParameter required

ARCGIS_function

Input a cell reference to another ArcGIS for Excel function where you want to add headers.

Yes

Function example

=ARCGIS.ADDHEADERS(A2)

This example will work if you have another function in cell A2. For example, if cell A2 contains the =ARCGIS.GETCOORDINATES("380 New York Street, Redlands, CA, USA") function.

Result

Longitude (X)

Latitude (Y)

Comma, decimal point, and semicolon separators

If you are using a German, Dutch, Spanish, French, or Italian-language operating system, numbers written in decimal form may be formatted differently than for those using English-language operating systems. For some languages, numbers containing decimals are written or separated using a comma (,) instead of a decimal point (.).

Depending on the decimal separator, functions in Excel should be formatted differently.

  • When a decimal point (.) separator is used, you must separate function parameter inputs using a comma (,), for example, =ARCGIS.GETADDRESS(-70.251, 43.65808).
  • When a comma (,) decimal separator is used, you must separate function parameter inputs using a semicolon (;), for example, =ARCGIS.GETADDRESS(-70,251; 43,65808).

In Excel, the default decimal separator is the same as that of your operating system. When using Excel, you can also customize this setting.