I have coordinates in a format e.g. 22°42'39.065”E, 49°4'59.864”N. I tried to add the points using "XY Table to Point" but when I add my Excel file as input, it doesn't recognize the fields as X and Y values. However, when I convert points in that format to DD format it works perfectly.
Is there a way to add those points from an Excel directly, or I need to have my points always in DD format in my Excel database?