If additional columns are present, a 'more.' button will appear above the map when the user clicks on your custom point. In Google Sheets, create a spreadsheet that includes these columns: Longitude, Latitude, Data* and Color. The Data column will appear in the map legend.ġ. * What is the Data column? The Data column is the first column in your spreadsheet other than State, County and Color, such as Salesperson in the image at right. Links included in the sheet beginning with will be clickable when the user clicks the map on that county.If additional columns are present, a 'more.' button will appear above the map when the user clicks on your custom area. In Google Sheets, create a spreadsheet that includes these columns: County, State Abbrev, Data* and Color. * What is the Data column? The Data column is the first column in your spreadsheet other than ZIP Code and Color, such as Territory in the image at right. Paste the link you just copied into the box below: Change the sharing setting to Anyone with the link (keep the drop-down to the right set as Viewer)ģ. Click the Get link section in the box that appearsģ. Click the Share button in the upper right cornerĢ. In Google Sheets, Share your spreadsheet with Anyone with the link permissions and click the Copy link button In Google Sheets:ġ. If used, the Color column can contain any browser-supported color name or any 6-digit hex color codeĢ. Links included in the sheet beginning with will be clickable when the user clicks the map on that ZIP Code.The header of the Data column will be used as the map legend heading.If you don't have a Google Sheet, create one by importing from Excel or a.Map data will be read from first tab in your Google Sheet the first row must contain column headers.You can use any combination of 5-digit ZIP Codes and 3-digit ZIP Codes.Free version has a limit of 1,000 rows monthly contributors can map up to 10,000 rows per map.In Google Sheets, create a spreadsheet that includes these columns: ZIP Code, Data* and Color. Maps of every Township and Range in the U.S.Individual County Maps of Section Township and Range.Individual County Maps of Civil Townships.

World time zone map current