Data scraping with Google Sheets and Tabula

Skill:

Level:

    • 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!
    Download the presentationDownload

    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 Reporting & Writing:

    Reporters toolkit for search

    Use this tool to track and visualize search trends on Google. You can compare terms or sub-topics, and use the tool to compare keywords you can use in SEO tags and headlines. The comparison graphics, maps and list are easy to embed and share.

    Skill:

    Level:

    • News values and judgment

    We tackle the fundamentals of what makes a story newsworthy, the essential practices of journalists and the shared values that differentiate journalism from other forms of content and storytelling.

    Skill:

    Level:

    • Conversational headlines

    Getting readers to tap your story starts ​with a headline that makes them a promise​.

    Skill:

    Level:

    • Improving our relationship with readers

    A primer on the the audience funnel. First, we will do an audience health checkup and what we can do to help move readers through the loyalty funnel. Then we explore what a reader NEEDS from our content  – and making sure we deliver.

    Skill:

    Level: