Help & Support
Send Feedback
Mapping Sheets
Get your own data from a Google Sheets into a custom featured Google Map with just a few clicks.
161,561 users
Works with
Install
Overview
Plotting your own data onto a map is in great demand for businesses and individuals. Either to show each location details in an Infowindow or for filtering over the map based on several conditions, but also to find locations within a distance to a place and ultimately to calculate the optimal route directions for your next travel around.

For the first time, the Mapping Sheets add-on is providing an easy way to process your data directly from Google Sheets onto a map.

First BUILD: the Mapping Sheets add-on will process your data from Google Sheets and create a .json file in your Google Drive, ready for mapping. Then VIEW: the Mapping web app will gather that .json file and plot your data directly onto a map. You can get your data from Google Sheets and onto a Google Map in just a few clicks.

➡ Mapping Sheets add-on
A Google Sheets add-on available within your own Spreadsheets under the Add-ons menu

⇨ Plans and Features
  ■ Basic Free Plan: Up to 50 locations per map. Includes all the basic (−) features.
  ■ Advanced Premium Plan (†): No restrictions in the number of locations per map. Includes all the basic (−) and advanced (+) features.
(†) Disclaimer: The Advanced Premium Plan does not avoid service errors, limitations and quotas like Google Geocoding daily quota limit exception, etc.

⇨ Getting started with your data on Google Sheets
  ■ Enter all your data for mapping onto a sheet, or insert a demo sheet from the ⋮ menu
  ■ Select the 3 column headers you want to use for Title, Filter, and Location when building the map 
  ■ Click BUILD to process your data into a .json file in your Google Drive, ready for mapping
  ■ Click VIEW to open the Mapping web app and see all your locations on a Google Map
  ■ Check the User Preferences for more options and settings

➡ Mapping web app
A generic data driven web app using Google Maps that loads data and settings from a .json file in your Google Drive.
The Mapping web app is free to access, publicly available with no fee, no credentials are required for access, for anyone to use.

➡ Main features (add-on and web-app)
⇨ Basic Features:
− Select the 3 data headers you want to use for Title, Filter, and Location
− The Title determines the value of the header in the Infowindow
− The Location (address) is used for Geocoding to get the coordinates on the map
− The Filter will group mapping locations using the same icon image
− Define a Location Template for Geocoding, using placeholders for headers, if the full address is split across several columns
− Include additional columns to display more information on the map
− Set the optional data headers row in case it's not the row #1 as default
− Use default icons and colors, or assign your own icons and colors to each filter unique value
− Select custom data to show in the icon title (mouseover tooltip) based on a template string
− Click a marker icon to open an Infowindow showing all the details of a specific location
− Select the data to display in the Infowindow based on a list of your headers
− Use image file secure urls (https:// ending on jpg, gif, png, svg) to show an image in the Infowindow
− Use valid urls to show links (...⬈) in the Infowindow
− Select custom data to show in the right-side Listing, based on a template string
− Access some extra actions in the add-on sidebar ⋮ menu
− Using Marker Clusters to combine markers of close proximity into clusters, for better performance and navigation
− Optional cluster settings for size, zoom and an [experimental] toggle button to hide/show clusters as convenient
− Spreading out overlapping location icons on click, in a spider-like approach
− Instantly filter across the entire data content as you type in the search box
− Use check-boxes for easy grouping and filtering locations according to the main filter
− Fast filtering by using a debounce asynchronous function, that wait/queue user's requests on filtering
− Choose to fit the zoom and center of the map to show selected locations
− Show or hide the right-side Listing of selected locations
− Available in more than 30 languages (add-on only, thanks to all the translators, including Google Translate 😉 )
− Take advantage of the many more features provided by Google Maps

⇨ Premium Features:
+ Additional filters including check-boxes and numeric sliders
+ Use additional filters in combination with the main filter to show selected locations
+ Filtering within a section works with “inclusive or” logic
+ Filtering across sections works with “and” logic
+ Find a place, draw a circle around, with option to filter locations within its boundaries
+ Optional quantity tags next to each filter value
+ Show one filter value per line (optional)
+ Use optional multi-value filter (with your own custom separator)
+ Filter for a value greater than a number,  like a standard slider with the active section on the right
+ Choose to hide the filter menu on loading the map
+ Custom Mapping web app page title
+ Select an icon set from a list of available options
+ Set and apply a custom style definition for your map, with thousands available online
+ Optimal route with options for round trip and start/end locations on Listing
+ Allows for custom code on post-processing Data, Infowindow and Locations List
+ More features in the queue already under development (see the Roadmap)

➡ Relevant links and references
+ Get the add-on from G Suite Marketplace
+ FAQ, Feedback, and Support
  https://www.thexs.ca/xsmapping/faq-and-feedback
+ Limitations, Known Issues and Common Errors
  https://www.thexs.ca/xsmapping/limitations-known-issues-and-common-errors
+ New Features Roadmap
  https://www.thexs.ca/xsmapping/new-features-roadmap
+ Current (out of date) Mapping Sheets add-on Reference document
  https://thexs.page.link/3EvT
+ Advanced Premium Plan subscription
  https://www.thexs.ca/xsmapping/advanced-premium-plan-subscription
+ User Preferences and Settings
  https://www.thexs.ca/xsmapping/mapping-sheets-add-on-preferences
+ Privacy, TOS, SLA and Liability
  https://www.thexs.ca/about-thexs/legalese
+ Demo map with most of the Advanced Premium Features
  https://thexs-mapping.firebaseapp.com/mapping.html
Reviews
A User of Mapping Sheets
June 11, 2019
Support is amazing and this add-on has saved tons of time across our company. The only feature request that we'd like to see to make this "perfect" is to have the maps automatically update so you don't have to keep building them. I'm told the development team is on-it though and can't wait to see the next version!
Submit reply
Cancel
A User of Mapping Sheets
June 7, 2019
Outstanding add-on. This has saved me hours of work a week and a small fortune on other products. Ability to create multiple filters that work with each other easily is amazing Routing planning tool allows for efficient use of vehicles and checks on travel times and distances This was the exact product I had been looking for, for some time and was close to paying a small fortune for a substandard product. Cannot rate this highly enough To top it off when I confused myself the support was first class, email response within an hour and with clear and easy replies - no waffle or babble. Keep up the great work
Submit reply
Cancel
theXS Assistant
May 23, 2019
An update from the Mapping Sheets add-on Team: Latest News! On or after May.23, 2019 we are updating the scope and permission the add-on requires to work for you - All current users will have to reauthorize the add-on, now with a limited / restrictive access to your Google Drive - The new permission would be as "View and manage Google Drive files and folders that you have opened or created with this app" - In other words: the Script can only access a private folder it creates within your Google Drive and the data files it creates within that folder We are moving our focus from the Chrome Web Store to the G Suite Marketplace (this page) as the main source/store from where to install the add-on, either for individual accounts for for the whole G Suite domain, depending on your account and requirements. Thanks for your continuous and valuable support
Submit reply
Cancel
A User of Mapping Sheets
May 11, 2019
Very easy interface!
Submit reply
Cancel
A User of Mapping Sheets
May 1, 2019
I am a new user, but I find this to be a very useful and easy tool for me to get to know my church congregation much better and to organize my approach to evangelization outreach. Thank you.
Submit reply
Cancel
A User of Mapping Sheets
April 29, 2019
Very simple, useful and intuitive add-on. Has made targeting our sales efforts based on the locations of existing sales much, much easier. Really useful for creating quick maps of sales successes for pitch decks, too ;)
Submit reply
Cancel
A User of Mapping Sheets
April 25, 2019
Fantastic idea and implementation. Words better than the mapping functionality Excel offers.
Submit reply
Cancel
A User of Mapping Sheets
March 20, 2019
Mapping Sheets works exactly as advertised and the creator(s) are consistently making improvements. It has provided me with a nice business opportunity that would not exist without Mapping Sheets. When I needed support, I was provided support within hours. Can't say enough good things. Steve Langert
Submit reply
Cancel
A User of Mapping Sheets
March 8, 2019
Can I send the map I made on my laptop with google chrome to my phone or tablet (apple)? I made up a map for sales calls but can’t figure out how to either save it to my docs or send to other devices
Submit reply
Cancel
A User of Mapping Sheets
March 8, 2019
Absolutely love this add-on! So easy to use and it is the perfect tool for our BlindSquare mapping solution, so I tip my hat to the developers and look forward to spending more time using it!
Submit reply
Cancel
1-10 of 76
Additional information
Search
Clear search
Close search
Google apps
Main menu