Township 21 North, Range 14 West, Indian Principal Meridian, Oklahoma

randymajors.org Map Tools ©2021 randymajors.org

mapBuilder

Create Custom Areas from ZIP Codes or Counties

Create Custom Areas from ZIP Codes or Counties

Create a custom area from a list of ZIP Codes

Define a delivery area, service area or sales territory using a list of 5-digit or 3-digit ZIP Codes

Show Me How

sample map

Color-code ZIP Codes from a spreadsheet

Create a custom color-coded map using a live link to a Google Sheet containing ZIP Codes

Show Me How

sample map

Color-code Counties from a spreadsheet

Create a custom color-coded map using a live link to a Google Sheet containing Counties

Show Me How

sample map

- Type a comma-separated list of ZIP Codes into the box below
OR
- Select ZIP Codes by drawing on the map above:
- 1. Click the Drawing Tools button on the left side of the map, then draw an area (any ZIP Code you touch will be included).
- 2. Double-click to finish drawing, and the ZIP Codes will automatically appear in the box below.

1. In Google Sheets, create a spreadsheet with the first 3 columns in this order: ZIPCode, Data*, and Color
- TIP: You can use either 5-digit ZIP Codes or 3-digit ZIP Codes (but not a combination of the two)
- TIP: If you don't have a Google Sheet, create one by importing from Excel or a .csv file
2. Publish your spreadsheet using the default values in the File > Publish to the Web box. Click Publish, then close the Publish box.
3. Copy the URL from your web browser address bar while viewing the Google Sheet (see example URL below)
- TIP: DO NOT copy the link from the Publish to the Web box
4. Paste the URL into the box below:

Color-code ZIP Codes from spreadsheet example
* Example spreadsheet showing Data column as Territory

1. In Google Sheets, create a spreadsheet with 4 columns in this order: County, StateAbbrev, Data* and Color
- TIP: If you don't have a Google Sheet, create one by importing from Excel or a .csv file
2. Publish your spreadsheet using the default values in the File > Publish to the Web box. Click Publish, then close the Publish box.
3. Copy the URL from your web browser address bar while viewing the Google Sheet (see example URL below)
- TIP: DO NOT copy the link from the Publish to the Web box
4. Paste the URL into the box below:

Color-code counties from spreadsheet example
* Example spreadsheet showing Data column as Salesperson

Add Custom Points to the Map

Add Custom Points to the Map

Add your own custom points to any map!

Add points to the map from a live-linked spreadsheet! Or add points from Google My Maps, Google Earth, or GIS software.

Add Custom Points in mapBuilderPro

Set Map Title & Display Options

Set Map Title & Display Options

Set a title for your map, set the main color and choose other map layers to display

Set color

Map type

Show labels

Center map on user location

Show county lines

Show city limits

Show ZIP Code boundaries

Also show these outside my custom area

Ready! Click link at left to view your map.
You can bookmark the link or embed the link on another website!

Ready! Click link above to view your map.
You can bookmark the link or embed the link on another website!

Note: If you include a map screenshot from this tool on your website, please include a small source attribution link pointing to this page.
Error: Cannot create object