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?

closed as unclear what you're asking by Midavalo Jan 8 '17 at 5:00

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 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