Skip To Content

Supported notation formats, data types, and categories

ArcGIS for Excel supports several degree-based notation formats for defining location coordinates.

In (x,y) degree-based formats, x represents longitude and y represents latitude. Specify hemisphere with +, -, N, S, E, or W. These can be combined within a single latitude-longitude pair. If omitted, a value is assumed to be positive (N for latitude, E for longitude).

In the WGS84 coordinate system, latitude <DD> values range from -90 to 90, and longitude <DDD> values range from -180 to 180.

Note:
ArcGIS for Excel does not currently support single-line coordinate values. Store the latitude and longitude values in separate fields or columns.

Notation types and formats

Notation types and formats use the following syntax:

  • <DD.dddd> denotes a latitude (y) coordinate in which degree (DD) values range from -90 to 90, and fraction of degrees (dddd) range from 0 to 00.
  • <DDD.dddd> denotes a longitude (x) coordinate in which degree (DDD) values range from -180 to 180, and fraction of degrees (dddd) range from 0 to 99.
  • | means or. For example, + | - means that you can use either the + or the - character.
  • [ ] denotes a choice list. For example, [ + | - | N | S ] indicates that you can use the +, -, N, or S characters.

The following table lists the supported notation formats and provides an example of each:

Notation typeSupported latitude (y) formatSupported longitude (x) formatExample

DD (decimal degrees)

[ + | - ] DD.dddd

[ + | - ] DDD.dddd

34.056687222, -117.195731667

DD.dddd [ + | - ]

DDD.dddd [ + | - ]

34.056687222, 117.195731667-

[ N | S ] DD.dddd

[ E | W ] DDD.dddd

N 34.056687222, W 117.195731667

DD.dddd [ N | S ]

DDD.dddd [ E | W ]

34.056687222 N, 117.195731667 W

DD° MM' SS.sss"

[ + | - ] DD° MM' SS.sss"

[ + | - ] DDD° MM' SS.sss"

34° 3' 24.0726", -117° 11' 44.631"

DD° MM' SS.sss" [ + | - ]

DDD° MM' SS.sss" [ + | - ]

34° 3' 24.0726", 117° 11' 44.631" -

[ N | S ] DD° MM' SS.sss"

[ E | W ] DDD° MM' SS.sss"

N 34° 3' 24.0726", W 117° 11' 44.631"

DD° MM' SS.sss" [ N | S ]

DDD° MM' SS.sss" [ E | W ]

34° 3' 24.0726" N, 117° 11' 44.631" W

[ + | - ] DD° MM'

[ + | - ] DDD° MM'

34° 3', -117° 11'

DD° MM' [ + | - ]

DDD° MM' [ + | - ]

34° 3', 117° 11' -

[ N | S ] DD° MM'

[ E | W ] DDD° MM'

N 34° 3', W 117° 11'

DD° MM' [ N | S ]

DDD° MM' [ E | W ]

34° 3' N, 117° 11' W

DDMMSS.sss

[ + | - ] DDMMSS.sss

[ + | - ] DDMMSS.sss

340324.0726, -1171144.631

DDMMSS.sss [ + | - ]

DDDMMSS.sss [ + | - ]

340324.0726, 1171144.631-

[ N | S ] DDMMSS.sss

[ E | W ] DDDMMSS.sss

N340324.0726, W1171144.631

DDMMSS.sss [ N | S ]

DDDMMSS.sss [ E | W ]

340324.0726N, 1171144.631W

Degrees, minutes, seconds

ArcGIS for Excel supports the following:

Mark typeSupported markUnicode

Degree marks

Degree sign °

U+00B0

Ring above °

U+02DA

Masculine ordinal indicator º

U+00BA

Circumflex accent (caret) ^

U+005E

Tilde ~

U+007E

Asterisk *

U+002A

Minute marks

Minute sign '

U+2032

Apostrophe '

U+0027

Second marks

Quotation mark "

U+0022

Diaeresis ¨

U+00A8

Double acute accent ˝

U+02DD

In most cases, all of the formats and markers listed above are valid regardless of spacing. For example, N 34° 3' 24.0726" and N34°3'24.0726" are both valid.

Cell value types

In general, the data types that can be written to a cell are number, text, logical (true and false), or error value. When you type input in a cell, Excel automatically detects and assigns the type.

For example, if you type abc, it is recognized as data type text. If you type true, it is recognized as data type logical and is automatically capitalized as TRUE to demonstrate that it is a logical value. If you type 0123, it is recognized as data type number and is converted to 123 in the cell.

Note:

The leading zero is removed when Excel assigns the data type and converts the value.

Format numbers

In Excel, you can format data type number as currency, percentage, decimal, and so on. This allows you to change how the number appears while keeping the data numeric rather than converting it to text, preserving numeric filtering and sorting capabilities.

See the Microsoft available number formats in Excel article for more information.

ArcGIS for Excel converts Excel number formats to ArcGIS Arcade expressions so that the numeric properties are preserved while properly formatting the data in map layer pop-ups and labels in Excel. The formats are also preserved in Arcade when the map or layer is shared to ArcGIS Online, ArcGIS Enterprise, and across ArcGIS. ArcGIS for Excel supports the conversion of all built-in Excel formats to Arcade, and recognizes most custom Excel number formats.

Location data such as postal codes can be either converted to data type text or kept as data type number with special formatting applied to preserve any leading zeros.

Learn more about special formatting in Excel

Dates and time

In Excel, dates and times are represented as number data type, with date or time formatting.

Learn more about formatting numbers as dates

Learn more about formatting dates

However, since Excel automatically detects the type, it may fail to detect the value as a date and incorrectly convert it to text data type.

Learn how to convert dates stored as text to dates

Map Excel value types to ArcGIS field types

When creating a layer from Excel data, the value types of each column must be identified to create the corresponding field in the new ArcGIS feature layer. The following table lists the Excel column types and the corresponding ArcGIS field types in ArcGIS for Excel:

Excel column value typeArcGIS field type

Number (not formatted as a date or time)

Double

Number with date or time formatting

Date

Text

String

Logical value

String

Mixed (for example, numbers and text in the same column)

String