How to setUp ?

Step 1 : Prepare Google Sheet Data

Map My Sheet - Demo Spreadsheet

Step 2 : Add on MapConfigure and save map.

To Start Map My Sheet

  • Open any Google Sheet (that has your data)
  • Go to add-on and select Map My Sheet.
  • Then, you will get this GUI on the right side of the screen.
  • To create your custom map Click on CREATE MAP.

Here, you have to do some configuration steps to create your custom map.

Step 1 of 5 - Provide Basic Information

  • Set Name of your map.
  • Select the tab-name, Its one of the important field because based on this tab name columns header is displayed in next sections.
  • Select the map type
  • Set the default Zoom Level of map
  • Turn on/off for Clustering
  • Turn on/off for Automatic refresh (Pro version)

Step 2 of 5 - Setup Location

Here you have two way to mark your location.

Address: This is default location type. If you want to place your marker based on complete address. Click on address field it will list all sheet headers. Now, you choose appropriate column header which has complete address.

  • You need to select the address by clicking on address columns.
  • To Present your data on map Longitude and Latitude are Mandatory fields.
  • If your Google Sheet you already have those(Longitude, Latitude) fields, you can just select the headers wherever it is necessary.
  • Otherwise , You just click (+) button that will add longitude and latitude in your Google Sheet. The add-on will auto generate latitude and longitude from your given address while saving the map.

Geo Co-ordinates: Here marker is placed based on Longitude and Latitude.

Step 3 of 5 - Setup Filters

In filter you can display data based on your condition.

For more details

  • Step 4 of 5 - Setup Marker

In this Section you can customise markers style, marker animation.

For more details

  • Step 5 of 5 - Setup Info Window

Displays content (usually text or images) in a popup window on map, at a given location.

For more details

Now, all configuration is completed and map is ready

You can view your map by clicking view map

You can publish the map to others by clicking publish map

Step 3: View Map