Mapping Sheets with Google Maps
Get your own data from a Google Sheets into a custom featured Google Map with just a few clicks.
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.
Update: Mapping 4.0 version is coming later this year 2020, with a better look plus a bunch of new features and options.
➡ 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.
■ Extended Custom Plan: All of the above plus tailored solutions, workflows and integrations as per client requirements, upon request (∗).
⇨ 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 (Free) 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
− Improved map sharing workflow with a prompt dialog and detailed documentation
- Unattended time-based BUILD if something has changed in the datasheet within an hour or more, after the last BUILD
− 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
⇨ Advanced (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
+ 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
+ More features in the queue already under development (see the Extended features below)
⇨ Extended (Custom) Features:
Most of the features under the Basic and Advanced sections above started here, as a custom feature for some client(s), and later moved up to mainstream public features. Some of the features listed below would follow that path eventually, depending on actual demand and available resources.
EDIT: some of these features will be available in Mapping 4.0 version coming later this year 2020
The current status of these extended custom features vary from 'thinking-about-it' to 'working-for-some-clients' including 'designing', 'developing', 'limited-availability' and others in between. The sorting of the following list does not represent their current status, neither their priority, nor their perceived value. This section would serve as the Roadmap.
Please, feel free to contact us through the support form if you are interested in any of these extended custom features or if you have a new feature request to include on this list.
− Assign the width and height for the Infowindow and choose if the height is locked or flexible
∗ Additional routing options without optimization as listed (as-is) and reverse order
∗ Allow for manual sorting (drag and drop) on the Listing when showing less than 50 locations
∗ Writing custom code on post-processing Data, Infowindow, Listing, etc, upon client requests
− Using expansion panels for main and additional filters in the sidebar for better usability, with the option to set which panels are expanded on loading
+ Use markdown content within your data under specified headers
+ More and better filter types
− Select an icon set from a list of available options
∗ Custom layers using Overlays, GeoJSON, KML & GeoRSS, OGC:WMS, Boundaries and others (extend details on the layers page)
∗ Options for export and import Preferences
∗ Set a trip route directions on the map, then draw a buffer boundary at a distance around the route to filter locations within
∗ Get the weather forecast for a location on the map on a click from the Infowindow
+ Define a full custom markdown template for the Infowindow content as an alternative for the default tabular content
+ Define a full custom markdown template for the Listing item content
∗ Use your own Info section (about) markdown content instead of the default by theXS
∗ Save the current map state (filters, panels, center, zoom) to reload it on the next time use
+ Set the headers to use on the optional Search filter for better results
∗ Find my location (find & follow me) options and center the map there with the choice of a filtering circle around
+ Circle around a place or location activate on click and editable radius
∗ Add and update (editing) locations data in the source datasheet directly from the Mapping web app
∗ An option to show the full header name on mouse hover the headers in the standard Infowindow, useful when having too long headers in the datasheet
+ Use an alternative icon shape (icon set) based on a header values
+ Use a custom icon size (scale) based on a header values
∗ Add a custom label to the location icons based on a header values and other options
∗ Geocoding in bulk client-side for a large number of locations
+ Select the map controls to use among the standard options in Google maps
+ Filter numeric values using slider range, slider left (<=) and slider right (>=)
+ Filter select single value within a searchable list of unique values
+ Filter select multiple values within a searchable list of unique values
∗ Filter select multiple values within a searchable list of unique values, but with dynamic content based on current visible locations
+ Filter select a single date or a date range (from - to) dates; date values must be on ISO yyyy-mm-dd format as plain-text under the selected column
∗ Asset tracking as a realtime layer of ‘moving icons’ on the map
∗ Real time map update on form submit new data
∗ Save the json map data file within Google Firebase, as an option to current Google Drive, to improve the loading for public maps
+ Allow for just a map with your locations by disabling everything else (menu, sidebar, listing, infowindow, controls)
➡ Relevant links and references