AnsweredAssumed Answered

CSV File ArcMap Geocoding

Question asked by steven77 on Jan 7, 2017
Latest reply on Jan 16, 2017 by jborgion

Newbie here trying to figure out how to work with excel data in arcmap. I am currently using ArcMap. 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 adress and it would work fine. However, the online free trail ran out I have not been able to geocode addresses inside of Arc

map and my data is halfway across the world. Guess my question is why is not working in the first place? My lat long coordinates are correct in my excel file. Should I format the addresses is in a different way? There is a column for each of the following in the csv. file.

House NumberStreet NameCityState/ProvinceCounty

Postal Code


Should I make the combine the above address columns a single field? Also, if there are any good beginner tutorials on how to work with the data after it is mapped, a link would be greatly appreciated. If I upgrade most of what I do would be csv to shp type of stuff. Thanks!