I have an Excel spreadsheet to input my lat. / long. values in dms (that's the format data comes in); it converts to decimal degrees and then I use the Make XY Event Layer tool to create the points. I am certain someone has created a tool or template to automate this combination. Please share with me what has been created.