GIS user technology news

News, Business, AI, Technology, IOS, Android, Google, Mobile, GIS, Crypto Currency, Economics

  • Advertising & Sponsored Posts
    • Advertising & Sponsored Posts
    • Submit Press
  • PRESS
    • Submit PR
    • Top Press
    • Business
    • Software
    • Hardware
    • UAV News
    • Mobile Technology
  • FEATURES
    • Around the Web
    • Social Media Features
    • EXPERTS & Guests
    • Tips
    • Infographics
  • Blog
  • Events
  • Shop
  • Tradepubs
  • CAREERS
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

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

Top Press

The Global Expansion of Aueshah: A New Era of High Jewelry

April 11, 2026 By GISuser

KARACHI, PAKISTAN. The international luxury market is experiencing a profound shift. Consumers are increasingly rejecting mass-produced goods in favor of rarity, authenticity, and emotional depth. … [Read More...]

State of Data Science Report – AI and Open Source at Work

September 10, 2025 By GISuser

AI and Open Source at Work … [Read More...]

Topcon Announces Landmark Expansion of Topnet Live Network Across USA

January 26, 2025 By GISuser

LIVERMORE, Calif.---Topcon Positioning Systems has announced a significant expansion of its Topnet Live reference station network, introducing 200 new geodetic stations strategically positioned across … [Read More...]

Space Flight Laboratory (SFL) Announces Launch and Deployment of NorSat-4 Maritime Monitoring Microsatellite

January 19, 2025 By GISuser

Seventh Satellite Developed by SFL for Norway … [Read More...]

HERE and BMW Group extend partnership on AI-powered mapping system

January 8, 2025 By GISuser

HERE and BMW Group extend partnership on AI-powered mapping system for automated driving and enhanced road safety … [Read More...]

Everest Base Camp Helicopter Tour, Helicopter Return Trek, and Manaslu Circuit Trek: Which Nepal Adventure Is Right for You?

November 6, 2026 By GISuser

Almost everyone planning a Nepal trip runs into the same wall. You want the big mountains, you have a fixed number of days, and every itinerary you read seems to promise something … [Read More...]

SFL Missions Inc. Confirms Successful Deployment of Six HawkEye 360 Radio Frequency Detection Satellites with Advanced Capabilities

October 27, 2026 By GISuser

MĀHIA, New Zealand, 26 October 2026 – SFL Missions Inc. today confirmed the successful deployment of six radio frequency (RF) detection and geolocation satellites for HawkEye 360 … [Read More...]

Canadian-Built RoadEng 12 Uses AI to Find the Best Location for New Resource and Rural Roads

October 17, 2026 By GISuser

Vancouver, BC, Canada, October 15, 2026 – North Vancouver-based Softree Technical Systems today released RoadEng Version 12, used in more than 75 countries to locate and design … [Read More...]

Beyond the Map: How AI Image and Video Generation Is Changing Geospatial Communication

October 14, 2026 By GISuser

Ask anyone who has shipped a GIS project what the hardest part was, and the answer is rarely the spatial analysis. It is almost always the communication. A site suitability … [Read More...]

From Maternity to Everyday Wear: Building a Wardrobe That Grows With You

October 14, 2026 By GISuser

When I think about maternity clothing, I feel the biggest mistake is buying too many things at once. During pregnancy, your body keeps changing, and something that fits well today … [Read More...]

Copyright gletham Communications 2015 - 2026

Go to mobile version