Converting XY data to points

SLouq

I have a new survey datasheet with an Latitude and Longitude field in it. The documentation says, 'Corresponding latitudes and longitudes are provided relative to the GRS80 ellipsoid'. 

I am trying to use XY table to point geoprossessing tool and would like to convert this datasheet into a point feature class to display in my map but the normal way I do this is not working. It is giving me a 'Warning 100160: Some of the features have invalid geometry and have been removed from the result'. This leads me to believe I am using the wrong coordinate system which I have set to GCS WGS 84.

Should I set it to GRS80 instead?

danretired

Your lat/long in the first image are wrong, just use your eastings and northings columns, they appear to be the projected coordinates which you can confirm for your area and projected coordinate system.

Don't use DMS from a spreadsheet, it would be best to relabel those field names so that they don't popup as the first choice.  If you must convert them to DD within the spreadsheet and label those as longitude and latitude.  Also Longitude or Easting is the X and Latitude or Northing is Y.... switching the order can prove interesting