Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Use Real Data and Put into Google Sheets

use real data import to a spreadsheet alice keeler
Use Real Data and Put into Google Sheets
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.

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

Exit this pop up by pressing escape or clicking anywhere off the pop up.