Using and Merging Google Maps

How to Create a Google Map

All grid worksheets have map tables. These tables allow for customizing map names, map types and address/geocode settings. Maps can be easily accessed using worksheet navigation links or from the StartDeck Tables sidebar navigation.

Map table with seven addresses
  1. Enter map name here. This name will display in the StartDeck Writer sidebar.
  2. Select the type of map. There four map types:
    1. ROADMAP (normal, default 2D map)
    2. SATELLITE (photographic map)
    3. HYBRID (photographic map + roads and city names)
    4. TERRAIN (map with mountains, rivers, etc.)
  3. Enter map markers. A marker can be any single digit number or character.
  4. Enter street address or Geocode (latitude/longitude). Up to 9 addresses may be plotted on a single map. The map will automatically size to best fit all addresses in the table.
  5. Table name. Map tables require a range name that begins with‘Map’and must follow the format shown above, with two columns and a maximum of 9 address rows.

Geocodes # 

If the location of the map marker is not accurate, as sometimes happens with Google Maps, a more precise location can be achieved with a geocode. Simply paste the geocode in the address field of the map table.

Geocoding Tools     
To find the geocode for an address using Google Maps, follow these steps:

  1. Open Google Maps in your web browser.
  2. Right-click on the exact location.
  3. The geocode will be at the top of the menu. Highlight the geocode and press control-c to copy.

You can also get the geocode from "What's here?" on the right-click menu. 

 

Need to geocode a batch of addresses? We recommend Geocode by Awesome Table.     

 

How to Create A Custom Map

To create a custom map, simply create a map table anywhere in the linked sheet and name the table range starting with “Map" followed by your map name. For Example, "Map_Location". The underscore is not required but improves readability.

A Map table requires a specific layout: it must be two columns wide and four to x rows tall. You can copy this one here
 

Insert Map to Doc

Go to StartDeck Writer > Forms & Data > Sheet Data & Maps then scroll to the bottom of the sidebar to the Maps section. Next place your cursor at the desired location and click the map name to insert the map.

Inserting a Google Map

Example Map

Land Comps Map

Update Maps

If map inputs change, the map can be updated. Go to StartDeck Writer > Forms & Data > Forms & Fields > Update Maps (bottom right of sidebar).

Update maps from the Forms & Fields sidebar

Related Articles

Sheet Data and Sheet Fields


 

How to Get More Help

Processing...