GISuser.com

GIS and Technology news for mapping professionals

  • PRESS
    • Submit PR
    • Top Press
    • Business
    • GIS, Geo Tech Software
    • Hardware
    • UAV News
    • Mobile Technology
    • Editor’s Top Picks
    • Get TOP Listing!
  • FEATURES
    • GeoGeeksinCars
    • 10 Question Q&A
    • FROM THE EDITOR
    • SPATIAL MEDIA AUTHORS
    • Social Media Features
    • EXPERTS & Guests
    • Listicles and Top 10 Lists
    • Infographics
    • VIDEOS
  • Events
    • Webinars
    • Submit event
    • Event Media Partner
  • CAREERS
    • Career Help Articles
    • People and Career News
    • Work from Home
    • About GeoJobs.BIZ
  • About
    • Advertise
      • Advertise wth GISuser
      • Media Kit Request Form
      • Directory
      • Submit Press
    • Contact GISuser
    • Meet the Editor
    • Social Media
      • AnyGeo Blog
      • GeoGeeks Podcast
      • Social Media Features
      • Like Us
    • SpatialMedia
      • LBSzone
      • LiDAR Magazine
      • Amerisurv
      • SymbianOne
    • RSS feed
  • Blog
  • Shop
  • Cloud Hosting
    • Amazon Cloud Hosting
    • WordPress cloud hosting
    • Dedicated servers USA
    • Linux Shared Hosting
    • Windows Shared Hosting
    • Web Development
    • SSL Certificate
  • Tradepubs
You are here: Home / *BLOG / Around the Web / Feature – Create an Interactive Map From a Spreadsheet Using Geosheets

Feature – Create an Interactive Map From a Spreadsheet Using Geosheets

October 12, 2016 By GISuser

There are a variety of tools for creating online maps, but many are impractical, requiring you either to enter numerous points by hand, to structure and import data in a specific format, to learn an expensive or cumbersome tool, or to be a programmer.

Geosheets makes it easier to create map visualizations and manipulate location data directly within Google Sheets, so if you are comfortable with spreadsheets, you can make rich, interactive maps quickly.

Here’s an example showing how to import data from a webpage and then map it, using just two function calls. To get started, either make a copy of the Geosheets demo template, or install the Geosheets add-on for Google Sheets.

Football season is in full swing, so we’re going to map the location of all NFL franchises in the US. Fortunately, there’s a table of all teams and the locations where they play at https://en.wikipedia.org/wiki/National_Football_League.

In cell A3 so that you have a little room to work, write this formula:

=IMPORTHTML(“https://en.wikipedia.org/wiki/National_Football_League”, “table”, 3)

IMPORTHTML is a built-in Google Sheets function that takes the url of a webpage that contains a table and automatically imports the table data into your sheet. The arguments are (1) a url to scrape, (2) whether to look for a “table” or a “list”, and (3) the item position on the page. Here we passed “table” and “3” because we want to import the 3rd table on that page.

Now that we have our data, we’re ready to map it. In cell A1 or wherever you have empty space, write this formula:

=GEO_MAP(A3:H37, “nfl-cities”, “City”)

And voila, in a moment the cell should populate with the url of your full-page, interactive map.

Here we call the GEO_MAP function from Geosheets, which takes a table of data from our spreadsheet and maps it. We pass the full range of our imported data including the header row, which is the range A3:H37. The second argument is a label for the map so it can be referred to later; this can be anything that you want, but we chose “nfl-cities” for this example. Lastly, we have to tell Geosheets which column contains the location we wish to map. If your location data is in the first column, you can omit this, but ours is in column C which is titled “City”, so we include that as our last argument.  Geosheets then goes and geocodes each location, creates a map, and returns to you the url of that map. If you use the Geosheets add-on you’ll see an auto-updating preview of the map in a sidebar right within Google Sheets.

Your map should look something like this:

2016-10-12-13_36_17-gisuser-blog-post-google-docs

If you choose to, you can now get fancy, and add additional columns like “Color”, “Type”, “Radius”, and “Icon” to customize the map. View your full-page map to change settings, like the title or base map tiles.

Here’s a customized map of the same data, where the larger radius represents higher-capacity stadiums, and the color-coding represents the division each team belongs to:

2016-10-12-13_37_25-gisuser-blog-post-google-docs

You can learn more about Geosheets at www.geosheets.com.  More examples and tutorials are available at the Geosheets Blog, blog.geosheets.com, and full documentation can be found here.

Author: Jonathan Goldman

Related Articles on GISuser:

  • Feature – Essential Apps and Tools for GIS ProfessionalsFeature – Essential Apps and Tools for GIS Professionals
  • Maptiks Adds Integration to EsriMaptiks Adds Integration to Esri
  • Feature – GIS and the NFL: Sustainability and Millennial FansFeature – GIS and the NFL: Sustainability and Millennial Fans
  • Feature: Social Media Mapping is Crucial for Market Research and your Social StrategyFeature: Social Media Mapping is Crucial for Market Research and your Social Strategy
  • Esri Web Map Analytics with Maptiks – Municipalities are adopting analytics for their geospatial projectsEsri Web Map Analytics with Maptiks – Municipalities are adopting analytics for their geospatial projects
  • 3 Geospatial Industry Thought Leaders Share a Look at 2017 & Geo Industry Outlook, Trends to Watch in 20183 Geospatial Industry Thought Leaders Share a Look at 2017 & Geo Industry Outlook, Trends to Watch in 2018

Filed Under: Around the Web, EXPERTS, Software, Top Features, Top Text Lead Story Tagged With: Geosheets, webmap






Editor’s Picks

Unique Hand Drawn Map of London

Unique Hand Drawn Map of London – Ten Years in the Making

Wider Selection of US Topo Maps From USGS Now Available in Avenza’s PDF Maps App

Location Privacy and What you Might be Sharing Over Public WiFi

Avenza Releases MAPublisher 9.7 for Adobe Illustrator

See More Editor's Picks...

Connect with GISuser

  • Facebook
  • Google+
  • LinkedIn
  • RSS
  • Twitter


GIS jobs

Recent Features

Digitalization and Simulation at the North Pole

Natural Gas District & GIS-Centric Asset Management

5 Ways Technology Is Affecting The Sharing Economy

Spotlight – Township Canada: Explore Canadian Legal Land Descriptions on a Map

GeoGeeksinCars – The one in “Tippy” the right-hand drive Mitsubishi, at DevSummit

More Posts from this Category

Categories




Recent Posts

  • Best Gaming Phones for 2021
  • Everything You Need to Know About Selling on Amazon
  • Trimble Announces Rugged, Lightweight Field Data Controller for Land and Construction Surveying
  • Webinar – How to Solve Algal Blooms in Municipal Water
  • Concept3D Offers Virtual Tour and Mapping Software to Hospitality and Tourism Industry at No Cost

RSS Career Tips

  • Four Characteristics of the Best Virtual Employees
  • Jobcase Launches Free Unemployment Resource Center for Workers Impacted by COVID-19
  • 8 Questions Employers Should Ask About Coronavirus
  • Must-Have Gadgets and Technology for the Remote Office Worker
  • Must-Have Gadgets and Technology for the Remote Office Worker


shop for geogeek swag

RSS Tech pubs

  • The Human Resources Management Kit - 2021 Edition
  • The Essentials for CEOs - 2021 Kit
  • The Essentials of Cloud - 2021 Kit

RSS Computers

  • iPad CTO Kit - including the iPad Tips and Tricks Guide for IT Executives and Managers
  • The Essentials of Information Security Kit: Includes a Free PC Security Handbook - 2nd Edition eBook
  • Windows... On Speed

RSS HR Tips

  • The Human Resources Management Kit - 2021 Edition
  • A Better Alternative to the Antiquated EAPs
  • The Mental Health Pandemic: 2021's Top Employer Trend

RSS Gov Tech

  • Cyberwarfare Requires Speed, Adaptability and Visibility to Win: Enterprises Must Close the IT Operations and Security Gap
  • The New American Workplace Research Kit - Includes a Free $8.50 Book Summary
  • Next-generation Situational Awareness - How Skydio's autonomous drone solutions protect first responders

RSS UAV news

  • Global Commercial Drone Market Expected to Exceed $8.5 Billion By 2027
  • Down to Earth – Drone Lidar Surveying Reality Series Returns
  • Florida Signs Participating Addendum with DroneUp Providing Public Sector Agencies Access to Drone Services

RSS Geojobs

  • An error has occurred, which probably means the feed is down. Try again later.
Copyright Spatial Media LLC 2003 - 2015