How to plot XY Coordinates in arcmap overlaid on a base map (satellite imagery)

[ShuhongYan]

Hi,

My client sent me an excel file with XY data not in Lat Long format, but in XY Coordinates (e.g. x= 1705962, y = 12257736) and wants me to plot it in the arcmap with satellite imagery as basemap. How could I work on it?

I imported this Excel file to ArcMap by using File --> Add Data --> Add XY Data and then specify the XY fields. However, I don't know the Coordinate system. It did plot my data in the arcMap, but it is not matched with the Basemap.

I tried to use Define Projection to set up a Projected Coordinate System to it, but I don't know which one I need to use. I tried UTM or NAD 1983 in Projected Coordinate Systems but the result doesn't match with the basemap.

What should I do to plot the data in the Excel file overlaid with the basemap? Should I ask my client which Coordinate System they are using for the XY Coordinate?

I would really appreciate your help!

Shuhong

[AbdullahAnter]

I think you said the answer.

 Should I ask my client which Coordinate System they are using for the XY Coordinate?

[JayantaPoddar]

Could you attach a sample of the excel sheet (a few rows)? Which area do the points belong to?

[ShuhongYan]

Hi, I asked my clients for the Coordinate systems they use to collect the data and then the problem solved.

Thank you!