Add Map Markers of Different Colors via Spreadsheet

Suppose you want to add different colored markers, based on a certain column in your spreadsheet, e.g., to distinguish Hospitals and Clinics.
Add a column called “Category” to your spreadsheet, and then enter values such as “Hospital” and “Clinic” in the relevant cells.

ZeeMaps will automatically assign a different color to each category.
If you want to specify the color yourself, then before you upload the spreadsheet, add a legend using the Map -> Legend menu item. Specify the legend values “Hospital” and “Clinic” for the appropriate colors.

The matching is case-sensitive, so make sure that your legend values and category values are exactly the same.

To delete a legend value, empty the legend value in the Map -> Legend dialog and hit submit.

If you want to color markers differently, but not necessarily have a legend, then you can also use color names like blue, green, yellow, etc., in your spreadsheet cells. For a complete list of colors, see the menu item Map -> Marker Icons on your map.

Revised upload limit for Basic plan

ZeeMaps enforces an upload limit for uploading geographical location data through spreadsheets. The upload limit is such that after a spreadsheet upload, the number of entries on your map cannot exceed your upload limit.
Until recently, our Basic (free) plan allowed up to 500 entries to be uploaded per map. Starting today, due to increased operational costs, the upload limit for Basic plan will be set to 100.
This limit does not apply if your data already contains location information (latitude, longitude), or if you add markers one by one (e.g., through crowd source).
Please let us know if you need some time to adjust to this change.

Displace Markers to reduce clutter

Sometimes map markers (pins) can get cluttered on the map if they are too close to each other. Other times markers can overlap, causing just the top one to be visible.
We’ve added the ability to “Displace Markers”, that allows you to un-clutter close or overlapping markers.
To displace a marker, click on the marker to show the information bubble. Then, click on the first icon to the right bottom of the information bubble. (You must be admin, or have added the marker, to see the icons on the right bottom of the information bubble.)
 

Displace Marker
Displace Marker Icon

A small window with the buttons “Done” and “Cancel” will appear, and you’ll be able to drag-and-drop the marker to a displaced location. A thin black pointer will point to the original location of the marker, so you know the actual geo-position.
After dragging-and-dropping the marker to a displaced location, if you click on the “Done” button, the marker will be displaced both in the interactive version of the map, and the static images. If you click on the “Cancel” button, the marker will be re-positioned at its original location.
In the above map, we had two overlapping markers. We displaced the top one, to get the following map:
Two overlapping markers separated
Two overlapping markers separated

Re-Positioning or Relocating Markers

Sometimes when you add a marker on a map. It is not positioned exactly where you’d like it to be positioned. There could be many reasons for this: e.g., the address information was not geo coded correctly. Or, you do not want to position the marker on the exact address. or there are multiple markers on a location and you’d like to tease them apart.
ZeeMaps allows you to drag-and-drop markers to reposition them.
To enable drag-and-drop, click on the marker. In the resulting information bubble, click on the first icon to the right bottom of the information bubble.
Resposition

This should allow you to drag-and-drop the marker to its new location.

Upload spreadsheet to a map: New Video

We’ve recently released a 2-minute video demonstrating how to upload your spreadsheet data to a map on ZeeMaps.
The video creates a map of hotels and dining establishments in Austin, Texas. We create a new map, upload the spreadsheet to the map, adjust the column assignments and submit. Within a few minutes we have a map of over 150 locations! It also demonstrates how we can use a “Category” column to get different colored markers.
Check it out and let us know what you think.