I have started to learn ArcMap.

I have two separate Excel files which are: Border coordinates, CSD coordinates.

For each Excel files, I have information for longtitude and latitude. My aim is to see both border coordinates and CSD coordinates on same map in ArcMap. To see clearly which points are border, I want to make different colour for border coordinates than CSD coordinates.

closed as too broad by Dan C, Vince, PolyGeo Nov 28 '18 at 6:54

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


ArcMap (and ArcGIS Pro) cannot read data in degrees-minutes-seconds (DMS), and therefore this data must be converted into decimal degrees (DD) before importing.

The steps below give instructions for formatting XY data, in decimal degrees, using Microsoft Excel, and converting these data to a shapefile or geodatabase feature class in ArcMap.

There are several table formats that ArcMap can read to bring point data into ArcMap as an event theme.

Click File > Add Data > Add XY Data.

Select the table that contains x,y coordinate data.

Identify the columns that hold the x- and y-coordinates (and, optionally, the z-coordinate).

Specify the coordinate system.

Adding x,y coordinate data as a layer can provide further assistance

Not the answer you're looking for? Browse other questions tagged or ask your own question.