Data scraping with Google Sheets and Tabula
|Data scraping — pulling tables of stats and other information from web pages, .PDFs and other documents — is a valuable skill for journalists. In this training video and hands-on exercises, you’ll learn how to scrape data tables out of web pages. We’ll use a formula and a browser plug-in to scrape web pages, then we’ll cover how to scrape native .PDFs with a fantastic tool called Tabula. Before starting the video, install Tabula.technology on your computer, and open the exercises page link. You’ll be a data-scraping ninja in no time!|
Link to exercises: Click here
Scraping formula: =IMPORTHTML(“URL”,“table”, 0)
Download free Tabula .PDF scraping software here: Click here
More data scraping resources on Journalist’s Toolbox: Click here
More training on Investigative:
PowerPoint 02: How to Use Shapes and Transitions to See the Story
See the Story: Microsoft trainer Bill Monroe teaches you how to use shapes, transitions, morph and more in this walkthrough of PowerPoint. Excellent details for improving your decks.
Google Earth Studio
Learn how to use Google Earth Studio, Google Earth Pro, Google Earth Timelapse and Earth Measure Tool with training by author and data journalism expert Mike Reilley.
Curate newsletters that win with readers
Newsletters are a powerful tool to move readers down the subscriber funnel. Here’s how to master them.