Use Cases

Use case 1: Prepare a Google Sheet with Corona virus spread in USA and present it in Google Maps.

List Corona virus cases from USA in Google Sheet as show below

Map My Sheet - Demo Gallery - Spreadsheet

Configure the "Map My Sheet" add on

  • Open add-on "Map My Sheet" from menu, Add-On > Map My Sheet > Start

  • Click on "Create Map"

Step 1:

  • Name the map as required.

  • Select the required sheet tab.

  • Select the required map type.

  • Select the required zoom level.

  • Switch on Clustering if required.

  • Switch on Refresh automatically if required.

Step 2:

  • Choose type of location as "Geo Coordinates".

  • To Map your Data Longitude and latitude is Mandatory.

  • if you already have longitude and latitude then just select the header wherever it is necessary.

  • else click on button which has plus(+) symbol to add latitude and longitude in your Google sheet.

Step 3:

  • Select the Filter in required.

  • Select the required column from sheet.

  • Select the required type.

  • Click Add Filter to add more filter.

Step 4:

  • Select the required marker color.

  • Select the required animation.

  • Click Add Marker to add more marker.

  • Select the required Marker.(A marker label is a letter or number that appears inside a marker.)

Step 5:

  • Configure the info window.

  • So that when the users clicks or hover on the marker the information will be displayed.

  • Customize the info Window as required.

  • Click the "+" symbol to add more to the info window.

  • Click on Save to save the Map.

  • Click View Map to view the map.

  • Click on Publish Map to publish the map.

View map

Here , we are showing the Corona virus spread in USA. If you want to see just click on the map.


If you are not able to see Google Map below, Login to Google, reload screen and accept permissions (if prompted)

Micro Use cases - See how people use Map My Sheet