Newbie here trying to figure out how to work with Excel data in ArcMap. I am currently using ArcMap ArcGIS for Personal Use. Before my online ArcGIS Online subscription ran out I managed to add a layer of Excel real estate data and the coordinates were as I intended. This was due to the address geocoding feature I suppose. After displaying x y data, I would geocode address and it would work fine. However, the online free trial ran out I have not been able to geocode addresses inside of ArcMap. I'm not sure what I'm doing wrong. I have tried everything and the data is showing on the map halfway across the world. Any suggestions?

  • Can you provide a screen shot of your excel sheet. Also how many addresses to you have in total? – whyzar Jan 7 '17 at 17:18
  • Welcome to GIS SE! As a new user please take the tour to learn about our focused Question and Answer format. You say you "have tried everything" but haven't told us what you've tried. Please edit your question to include some detail about what you've tried (and how) and also include a sample of your CSV file data so potential answerers have an idea of what you're using and can test for themselves. – Midavalo Jan 7 '17 at 17:24
  • Sorry, I don't see a function to upload or add screenshots. I would be happy to provide an example. How do I do this? – steven77 Jan 7 '17 at 20:37
  • @steven77 edit your question and use the Image button from the edit toolbar to add an image. You could also cut/paste some of the text from your CSV rather than trying to include an image if that's easier. – Midavalo Jan 7 '17 at 23:07
  • Data showing up halfway across the world is likely one of three problems: (1) you have lat and lon switched (very common when moving from one platform to another, shouldn't be an issue within ESRI products); (2) you might need to designate west or south coordinates with a negative sign; or most likely (3) you have a projection mismatch -- say you computed decimal degrees latitude and longitude, but somehow you told ArcMap your layer is UTM (meters) instead. – J Kelly Jan 8 '17 at 1:13