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 Number||Street Name||City||State/Province||County|
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!