Help & Support
Send Feedback
Mapping Sheets
Plot your own data onto a Google Map directly from Google Sheets.
thexs.ca
109,971 users
Works with
Install
Overview
Plotting your own data onto a map is in great demand for businesses and individuals. We want to map all kinds of different data—from business contacts to next week’s appointments, or simply all your friends’ addresses.

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, the Mapping Sheets add-on will read your data from Google Sheets and create a .json file on your Google Drive. Then, the Mapping web app will process the .json file and plot your data directly onto a map. You can get your data from Google Sheets and onto a map in just a few clicks.


⇨ Mapping Sheets add-on
Getting started with your data on Google Sheets
➧Enter all your mapping data 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
➧Click VIEW to open the Mapping web app and see all your locations on the map

Main 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 determines the coordinates on the map
− The Filter will group mapping locations using the same icon image
− Include additional columns to display more information on the map
− Use default icons and colors, or assign your own icons and colors to each filter value
− Select custom data to show in the icon title (mouseover tooltip) based on a template string
− Select the data to display in the Infowindow based on a list of your headers
− Use image file urls (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 Location List, based on a template string
− Access some extra actions in the ⋮ menu
− Insert demo sheet for testing (optional)
− View demo map
− Refresh header list in the sidebar if you make any changes to the data sheet headers
− Available in more than 30 languages (thanks to all the translators, including Google Translate 😉 )

+ Additional filters including checkboxes and numeric sliders
+ 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)
+ 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 
+ More features in the queue already under development

➧ 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, Google Drive maximum file size, etc.


⇨ Mapping web app
A generic data driven web app using Google Maps that loads data and settings from a .json file in Google Drive.

The Mapping web app is free to access, publicly available with no fee, no credentials are required for access, and the code is available on GitHub, for anyone to use.

Main features:
− Load your data and settings from a .json file in your Google Drive by adding the File ID to the Mapping web app url
− Instantly filter across the entire data content as you type in the search box
− Use checkboxes for easy grouping and filtering locations according to the main filter
− 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
− Choose to fit the zoom and center of the map to show selected locations
− Click a marker icon to open an Infowindow showing all the details of a specific location
− Show or hide the list of selected locations
− Allows for custom code on post-processing Data, Infowindow and Locations List
− Take advantage of the many more features provided by Google Maps

Reviews
April 20, 2017
hasn't worked for me. the pop up is blank. everything is blank
Submit reply
Cancel
May 30, 2017
Are you using Mozilla Firefox browser? - There is an issue with this browser that blocks the loading of the sidebar - Could you please, try with the Chrome browser and confirm if it's working fine? * About browser-related issues - We are having issues with the add-on and the mapping app for both, Firefox and IE browsers - Please, try the Chrome browser instead in the meantime - Check for more details at the end of "Known issues..." page, at the end under "Browser specific notes" (http://www.thexs.ca/xsmapping/limitations-known-issues-and-common-errors)
April 5, 2017
This add-on has saved me so much time!! I volunteer for a project (The Real Junk Food Project) that rescues perfectly edible food waste from supermarkets, restaurants and wholesalers in the UK and redistributes it so that it can #feedbelliesnotbins. As well as running regular cafés and catering for events (run on a PayAsYouFeel basis) we distribute up to 300 boxes of 'waste' food each week to recipients all across the city of Birmingham UK. When I started doing the admin, the delivery routes had been put together by educated guesswork, and it was a chore to allocate new recipients to a route. Now I can plan ahead, group deliveries together in routes that make sense (keeping to one side of a river or railway line, for instance), easily see which route is which thanks to colour coded pins, allocate waiting list boxes to routes based on delivery availability in that area, and share maps with limited information in order for volunteer drivers to see what they're signing up for. I was doing this before I found this app, but it was a laborious process, now I just press two buttons. This has made organisation so much simpler and easier - hopefully we will retain our volunteer drivers for longer as a result, now we're no longer sending them on non-sensical routes! Thank you!!!
Submit reply
Cancel
April 4, 2017
how do you buy the full version?
Submit reply
Cancel
April 4, 2017
Under Subscription in the Mapping Sheets Addon - menu.
April 4, 2017
Would love to know that as well.
April 1, 2017
free for 50 row
Submit reply
Cancel
March 24, 2017
It is very awesome tool and very easy to use!! Like it very much! I got some errors few times and the support was very good! Had option to report the issue and had follow ups in the email quickly on what is going on and whether it is fixed or not.
Submit reply
Cancel
March 23, 2017
I'm in the UK - If three people share the same postcode, It seems like the map only puts up a pin for one of them.... any ideas?
Submit reply
Cancel
April 5, 2017
Are you sure it's not 3 pins on top of one another?
March 20, 2017
very empowering team created nice add-ons which is very helpful if you work in shipping
Submit reply
Cancel
March 16, 2017
works well. Had an issue and they contacted me right away and resolved it.
Submit reply
Cancel
March 12, 2017
Easy to configure mapping via Google Sheets. The Forest Service uses my phone app to record issues with hiking trails around Sedona. The observations, including GPS location and photos, are send wirelessly to Google Sheets. The managers who repair the trails then use Mapping Sheets to locate all the observations and to organize and prioritize their repair work. I have had excellent support from the Mapping Sheets team when small issues came up. Kudos to the team for this awesome add-on and excellent support! Looking forward to version 2.
Submit reply
Cancel
March 6, 2017
very useful for creating my own map
Submit reply
Cancel
1-10 of 66
Additional information
Search
Clear search
Close search
Google apps
Main menu