Creating a Wisconsin Township Range Map with Google Sheets

Are you looking for an efficient way to visualize township range data from Wisconsin? Look no further! With Google Sheets, you can create a custom map that displays township ranges for any county in the state. In this article, we will guide you through the steps of creating a Wisconsin township range map using Google Sheets.

Step 1: Create a Spreadsheet

To begin, open Google Sheets and create a new spreadsheet with four columns in the following order:

* County

* StateAbbrev (WI for Wisconsin)

* Data*

* Color

For example, if you want to display the township ranges for Dane County, you would enter 'Dane' in the first column.

Step 2: Set Map Title and Display Options

In the top-right corner of your spreadsheet, click on the 'Map' tab. This will allow you to set the map title and display options. In this example, we'll use 'Wisconsin Township Range Map' as our map title.

Step 3: Add Links and Legends

The second column can contain links beginning with 'https://' that will appear when the user clicks on the map in that county. For example, if you want to add a link to a website for Dane County, you would enter 'https://www.danecounty.com' in the second column.

The header of the second column will be used as the map legend heading. In this case, we'll use 'County Website' as our legend heading.

Step 4: Add Colors

In the color column, you can use any browser-supported color name or any 6-digit hex color code. For example, if you want to use a blue color for Dane County, you would enter '#0000FF' in the color column.

Step 5: Share Your Spreadsheet

To share your spreadsheet and make it accessible to others, follow these steps:

* Click on the 'Share' button in the top-right corner of your spreadsheet.

* Click on the 'Get link' section in the box that appears.

* Change the sharing setting to 'Anyone with the link' (keep the drop-down to the right set as Viewer).

* Click on the 'Copy link' button and then click on 'Done'.

Step 6: Create a Map

Now, go back to your spreadsheet and click on the 'Map' tab. You should see a map that displays township ranges for each county in Wisconsin.

Tips and Tricks:

* The free version of Google Sheets has a limit of 1,000 rows per month. If you need to create a map with more than 1,000 rows, consider upgrading to a paid subscription.

* You can use any combination of 5-digit ZIP Codes and 3-digit ZIP Codes in your spreadsheet.

* Map data will be read from the first sheet tab in your Google Sheet.

Creating a Wisconsin township range map with Google Sheets is an easy and efficient way to visualize geographic data. With these steps, you can create a custom map that displays township ranges for any county in the state. Whether you're a researcher, a GIS professional, or just someone looking for a fun project, Google Sheets makes it easy to create a Wisconsin township range map that meets your needs.