How do I format my Google Spreadsheet?
See the examples
"My map never loads, and I have more than 400 points. What can I do?"
Or "Not all my pins show at different zoom levels, Why?"
Why this happens?
We make maps of > 400 points switch to use a means of loading that doesn't always show all points -- for quicker loads. In this case, Google determines at what zoom levels to show what points.
In this case, it is possible though for the data in your map (number of pin's and associated title/additional info) to exceed the max size/quantity allowed by Google maps, and thus the map never loads.
If seeing all the points is of utmost priority, the current way to force all points to be visible, is to set the 'show map points key' to true -- this can be done in the "Save Map" step in the wizard, or in the "Manage Maps" page.
By doing so, all points will be visible always, but it will adversely affect load performance, noticed more on older browsers. Another side affect is that the key of map points is visible.
What you can do (right now):
Set "show map points key" to true
Remove the "additional info" in the "assign fields" step of map creation, thus making the KML file for your map smaller. (Google's upper limit on KML file size makes bigger maps sometimes not load.)
Click on the "Download KML / View in Google Earth" button below your map, to load them in Google Earth, where all the points will always load. As it is a desktop application, it is more robust than a browser map viewer.
Not all the pins on my map appear, why is this happening?
Know issues with Internet Explorer 6.0 in resolving map pin images. It is recommmended to use Firefox for which MapAList is optimized, but you can also try the links below to try to assist in addressing issues you may be experiencing with your maps.
My Browser is having issues with maps, what to do?
This site is optimized for
. Internet Explorer 6.0
inconsistently resolves points on maps
, you may try to resolve this, but it is recommended to
upgrade your browser
or use Firefox or Safari.
I'm experiencing difficulty with the maps while using Microsoft Internet Explorer. How do I fix this?
I'm having difficulty accessing Google Maps. How do I fix this?
I am viewing a map outside of MapAList and getting this error: "You do not have permission to view this map." Why?
The map might not be set as public, ask the creator of this map to make it public, in the "Maps: Manage" section.
Is my map data secure?
The data points for maps are stored in a secure database. The points for a map are only retrieved from the database to show that map when requested by the authenticated user who created the map, or a MapAList administrator, unless the map is set to public.
I'd like to revoke MapAList's access to my spreadsheets; how to do so?
You can do it from the Account page (
), by clicking "Unlink Google Documents Account(s)"...
...or do it directly from Google at:
Though, if you are using Google Apps for your Domain (GAFYD), you must use:
Is it possible to include hyperlinks in the map?
You can include any HTML tags (including hyperlinks) in your map pop-ups.
First you need to alter your spreadsheet data to have hyperlink tags as a column and then you need to assign that to the "
field in the "assign fields" step.
<a target='_new' href='a href="http://www.cnn.com/" target="_blank">http://www.cnn.com/'>News</a>
See this spreadsheet for an example: (Worksheet=Embed Images and Links)
The resulting map could look like this:
Additionally, you can use a function in the Google spreadsheet to create an automatic column for you without having to manually add HTML hyperlinks tags.
For example, add this to a new column:
=CONCATENATE("<a target='_new' href='", B5, "'>", B5, "</a>")
Where B5 is the column where your URL resides.
(UPDATE: eventually will have auto-url detection for this)
When I click on any of the pins all I get is the name of the city. Is there some way to show all the information, ie. name, address, city, st, zip & phone?
Create a new map (or just step back on the one you have open) and in step 2, "Assign Fields", assign anything to "Title" and/or "Additional Info".
Is there a way to make the map begin zoomed in on my area?
In the "Save Map" step of the create map process, and on the "Manage Maps" page, there is the option to change your "Default Zoom Level", which starts at 3, centered on one of your points chosen at random.
Can you print (or export as a graphic) the maps created?
See the print icon below a map (or just print the browser via normal means).
Pro-tip: Make map full-screen and then resize browser to alter print size.
How do I go back and change some of the settings?
Certain map settings can be edited after a map is saved via "Manage Maps" (
However, that page is limited. For any other things, like 'map type', 'icons', etc.., you'll have to create a new map. The full featured 'edit map' page has not yet come to fruition.
Is there a way to get more than two variables from my Google spreadsheet to show up in the pin balloon? I see how user can select any field of the spreadsheet to display as either "Title" or "Additional info"....but what If I have text from other fields in the same spreadsheet that I want to pop up in the balloon once a user hovers or clicks on the pin?
There is a trick you need to apply to your Google spreadsheet to accomplish this:
Create a CONCATENATE field in your spreadsheet, i.e.
=CONCATENATE(B2, "<br/>",D2, "<br />", F2)
See the "ConcatenatedField" in the "Band Event Dates" worksheet for an example @
Sample Google Sheet
I am trying place all accounts by sales person on one map with different push pins for each rep (6). Is there a way to do this?
Yes, there are a couple ways to do this:
1) Group By Column
a) On the "Configure Map" step, choose "Settings Type: Basic"
b) Select "Group by distinct column Values" from the drop down
c) Choose the column holding the name of the sales person.
Note: This is Brian's favorite type of map.
2) Custom criteria and Pin Images
a) On the "Configure Map" step, choose "Settings Type: Advanced"
b) Setting your own criteria and choose the images you want for each
How do I get non-Latin characters to appear in my map?
Mia culpa, international users -- Only Latin characters are currently supported. Work to resolve this is underway, albeit at a snails pace.
Answer you're looking for not here?
and we'll get back to you!