I am teaching myself to make a density map of over 600,000 addresses. The way I know how to do this involves creating a spreadsheet and adding it to the map. However, I believe excel won't take that many rows. Is excel the only option?
I've moved your post into the GIS Managing Data space. You will get a
much better answer here as the GeoNet Help is intended for community
help and feedback. I have also added in a few additional tags. You can see more
on the community structure, and what topics are under each space from the
The addresses you have, are they already geocoded? Do you have X, Y coordinates or Latitude, Longitude coordinates?. If not, you should first geocode the addresses. If you already have X, Y coordinates or Lat, Long attributes, you can use Add XY Events to convert the X, Y or Lat, Long values to a geolocation. Note that this information does not need to be in an Excel file.
Once you have your 600.000 points you can visualize them or perform some spatial analysis. It is important to know the difference between a Heatmap visualization and spatial analysis like Point Density or Kernel Density.
Heat map in esri Maps for Office
Hot Spot Analysis Getis-Ord Gi* (Spatial Statistics)
Kernel Density (Spatial Analyst)
Point Density (Spatial Analyst)
Kind regards, Xander