Home
How to publish your Google spreadsheet on the web
How to use OpenHeatMap within your own site
FAQ
What kind of locations does OpenHeatMap understand?
What options can you set on a map?
What do the upload errors and warnings mean?
Component API calls
Events list
International states and provinces example files
If you have a spreadsheet of street addresses, it’s best to lay them out like this to help the service understand them:
pre.
Location | Value |
2543 Graystone Place, Simi Valley, CA 93065 | 10 |
2098 17th St, San Francisco, CA 94114 | 20 |
…
The important parts are that you put the whole address in a single column (rather than breaking it into separate city, state, or street cells), give the column the title “Location” to help the service understand what it is, and add a “Value” title to control the color of the markers on the map.
You should create a dummy column filled with 1’s, and give it the header “Value”. This will make the service use the same color and size for all the markers. Here’s an example:
pre.
Location | Value |
Los Angeles, CA | 1 |
Boulder, CO | 2 |
…