Home

OpenHeatMap

How to:

How to publish your Google spreadsheet on the web
How to use OpenHeatMap within your own site

Reference:

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

How can I map my list of addresses?

If you have a spreadsheet of street addresses, it’s best to lay them out like this to help the service understand them:

| 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.

What if I don’t have any values for my places?

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:

| Location        | Value |
+-----------------+------+
| Los Angeles, CA | 1    |
| Boulder, CO     | 1    |
...

What if