This article covers complete steps on how to install Mapping Sheets in Google Sheet. You will also get to know some awesome features, how to share your map and a deep uninstallation guide.
With just a few clicks, you can turn your own data from Google Sheets into a custom-featured Google Map. The ability to plot one’s own data onto a map is appealing to both businesses and individuals.
The Mapping Sheets can also help you to identify locations within a certain distance of a location and then create the best route directions for your next trip around.
Features of the Mapping Sheets
This add-on has got a lot of great features that will allow users to perform additional functionalities.
a. Choose from a variety of map styles to include on your map, including Google Maps’ basic options as well as your own unique style definition.
b. To show all selected sites, fit the zoom and center of the map.
c. As you put in the search field, the complete data content is instantly filtered.
d. Select the map controls to display in the map from the list of Google Maps’ standard settings.
e. Set the headers to use on the Search filter’s optional headers for better results.
f. To show matching places, use numerous additional filters and other filtering options in conjunction with the main filter.
g. If the complete address is divided across several columns, define a Location Template for Geocoding with placeholders for headers.
h. For greater usability, use expansion panels in the sidebar for the primary and additional filters, with the option to choose which panels expand on loading.
i. For greater usage, an option to pick or deselect all values within each filter section on the panel header.
Install Mapping Sheets In Google Sheet
Below are the steps on how to install:
a. Open the Google Sheet app on your PC.
b. On the Menu bar, locate and click on the “Add-ons” tab, and click on “Get Add-ons“.
c. Now on the Add-ons window, search for the “Mapping Sheets” add-on. Once the required add-on is shown up, click on the “FREE” button to start the installation process.
You will get a prompt to allow the app to have access to your Google account. In this case, you MUST have a Google account before you can proceed.
d. Scroll down and click on the “Allow” button to proceed. This will automatically integrate the add-on in the Google sheet. See the image below:
e. You’re finally done! This is how easy it is to install the Mapping Sheets into your Google Spreadsheet.
Alternatively, you can also follow the second step below to do the same. In this case, we will be using the Google Workspace Marketplace.
To install the Mapping Sheets from the Google Workspace Marketplace, kindly follow these steps:
a. Go to the Mapping Sheets
b. Click on the “Install” button.
c. Next, the Mapping Sheets will need your permission in order to start installing. Click on “Continue” as shown below.
d. Depending on your browser, you may want to scroll down a bit and click on the “Allow” for Mapping Sheets to have access to your Google account. This will give the app access to the following:
- See, edit, create and delete all of your Google Drive files
- Manage your goo.gl short URLs
- See, edit, create and delete all your Google Docs documents
- See, edit, create and delete all your Google Sheets spreadsheets
- Connect to an external service
- Allow this application to run when you are not present
- Display and run third-party web content in prompts and sidebars inside Google applications
See the image below:
You’re done. This is how to install the Mapping Sheets in your Google Spreadsheet.
How To Uninstall Mapping Sheets
To uninstall Mapping Sheets from Google Sheet, follow these steps:
a. Locate and click on the “Add-ons” tab on the Google Sheet menu.
b. On the pop-up menu, click on “manage add-ons“. You would see the Mapping Sheets add-on with the label “Installed“.
c. Next, click on it to open up every detail about the add-on. Click on the “Uninstall” button right beside it.
d. Next, click on the “UNINSTALL APP” button to confirm the uninstallation of the app. Once successful, the “Install” button will be activated, indicating the completion of the uninstallation process. See the image below:
You’re finally done!!!
How To Share Your Map
The Google sheets add-on provides an easy way to share your map with loved ones or basically whoever you want. In order to do so, you may want to share your .jason file for view access.
To publish your map, or to provide people access to your map URL and map file, simply follow these steps:
a. For view access, share the .jason file with those you want to give access to.
b. Now click on the “Copy” button for the map link.
c. Next, click on the “Share” button to open the Google sharing page. Enter the emails you want to send and share your map with.
d. On your right side, click on the button and select “Can View“. Add a note to tell them to click on the link of your map.
e. After that note, paste the link you copied before, and click on the “Send” button to confirm if asked.
Now you are finally done. That is how easy to share your map link with others.
Google Sheets Tutorials
Check out more Google Sheets tutorials below:
In conclusion, these are the full details on how to install the Mapping Sheets, some awesome features, and the uninstallation guide. Get the latest on tertiaryportal.com.
I hope this article was helpful? If you liked this article, don’t forget to share and leave us a comment.