Teacher Tech

Paperless Is Not A Pedagogy

Menu
  • Teacher
    • Blog Posts
    • Teacher Tech Facebook Group
  • Google Certified Innovator
    • CoffeeEDU
    • Tour of Google Classroom
    • Back to Classroom
  • Author
    • Alice Keeler Books on Amazon
    • Bulk Order Books
  • Developer
    • Schoolytics
    • Google Developer Expert
    • Add-ons By Alice Keeler
      • Doc to Slides by Alice Keeler
      • Roster Extras by Schoolytics
      • TemplateTab
      • toTabs
      • Form Printer
      • Quiz Helper
      • Dice Slides by Alice Keeler
      • Scheduler by Alice Keeler
      • Document Outline by Alice Keeler
      • Missing From (Google Forms™)
      • Randomize Slides by Alice Keeler
      • Speaker Notes by Alice Keeler
      • sheetPusher
      • Seating Chart Slides
      • Hyperlink Slides Choice Board
      • Add-a-Date
      • QuickShare Screenshot
      • Anyone Can View
      • Drive 20
    • Apps Script Tutorials
    • Templates
  • EdTech Coach
    • Premium Membership
    • Free Newsletter
  • Hire Alice
Menu
use real data import to a spreadsheet alice keeler

Use Real Data and Put into Google Sheets

Posted on April 22, 2019May 11, 2021 by Alice Keeler
Use real data import to a spreadsheet

Use IMPORTHTML to Get Website Data into Your Google Sheets

In the information age, it is easy to find real data to use rather than contrived situations in a textbook or on a worksheet. Who is Bob and why is he carrying 40 watermelons? Use this student guide with your students to help them get started with IMPORTHTML.

Getting the Data

Google searching is the “easy” part. (Do not assume students know how to Google Search effectively. They can put words in a search box but need to be taught how to research using the web.) Once students find websites that contain data, how do they get it into a spreadsheet to organize and analyze?

Site license for Go Slow Online Workshops
Get a site license for the year for Go Slow Online Workshops. alicekeeler.com/goslow

IMPORTHTML

If a website contains a table or list students will want to copy the link to the page. In a Google Sheets spreadsheet (http://sheets.new) type the formula =IMPORTHTML(

The link to the website will need to be in quotations.
=IMPORTHTML(“https://en.wikipedia.org/wiki/2018_California_wildfires”,

Table or List

After a comma students will want to see if there is a table or list on the webpage. In quotations, “table” is the next part of the formula.

=IMPORTHTML(“https://en.wikipedia.org/wiki/2018_California_wildfires”,“table”,

=IMPORTHTML(“https://en.wikipedia.org/wiki/2018_California_wildfires”,“list”,

Which One?

The last part of the formula is which table or list on the page. Start with 1 and edit to 2, 3, etc… to pull the desired data from the website.

=IMPORTHTML(“https://en.wikipedia.org/wiki/2018_California_wildfires”,”table”, 1)

Example: California WildFires

Wikipedia has lots of data tables. In this Google Sheets spreadsheet, I used the IMPORTHTML formula with the Wikipedia site on California wildfires.

Notice I have multiple tabs along the bottom of the spreadsheet.

Tabs in the spreadsheet

In cell A1 I have the formula =importhtml(“https://en.wikipedia.org/wiki/2018_California_wildfires”,”table”,1) and a range of data

Cell A1 has the importhtml formula

Duplicate the Tab

On the tiny triangle on the tab at the bottom, choose “Duplicate.” This will copy the sheet and the formula.

Double click on cell A1 and modify the table reference from 1 to 2. I repeated this step until I had all the tables in the spreadsheet.

Import Lists

Once I had imported all of the tables, I imported all of the lists. Modifying “table” to “list” pulls lists of information out of the website.

Analyze the Data

Pulling data into a spreadsheet is a great digital literacy lesson all in itself, but then what will students DO with the data? It is an essential skill that students can manage messy data sets (something textbooks fail to provide) and then determine if the data is useful and what to do with it.

Student Guide

I have created a Google Docs guide to share with students to help them get started with IMPORTHTML.

Related

Related Alice Keeler Blog Posts:

  1. Students Tweet as Historical Figures by @MrsAshleyBFort
  2. Teach Students How to Give Peer Feedback
  3. Google Sheets: What is the Time Difference
  4. Linking Data Sets in Different Google Sheets

Continue Reading

Next Post:
10 G Suite Easter Eggs
Previous Post:
Google Apps – Make Available OFFLINE

1 thought on “Use Real Data and Put into Google Sheets”

  1. Pingback: Use Real Data and Put into Google Sheets – US Netizen

Leave a Reply Cancel reply

You must be logged in to post a comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Alice Keeler is a mom of 5. Current High School math teacher. Developer for Schoolytics.com. Google Certified Innovator, Microsoft Innovative Educator, Google Cloud Innovator Champion, and Google Developer Expert. Founder of #coffeeEDU
Teaching with Google Jamboard
Developer Schoolytics
Schoolytics is FREE for teachers.

Find ALL My Blog Posts


Link to List

Google Classroom Books

Alice Keeler: Mom of 5. Current High School math teacher. Developer for Schoolytics. Founder #coffeeEDU. Google Certified Innovator. Microsoft Innovative Educator. Google Developer Expert. EdTech Specialist.

My Referral Links


Custom Stickers, Die Cut Stickers, Bumper Stickers - Sticker Mule

 

©2022 Teacher Tech | Theme by SuperbThemes