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:

    Protected: Scrape-a-palooza and Google Flourish

    There is no excerpt because this is a protected post.

    Skill:

    Level:

    • Protected: Advanced sports coverage using Google Earth Pro

    There is no excerpt because this is a protected post.

    Skill:

    Level:

    • Protected: Google Finance scraping and other tools for business beats

    There is no excerpt because this is a protected post.

    Skill:

    Level:

    • Protected: Data-scraping websites, PDFs and Flourish

    There is no excerpt because this is a protected post.

    Skill:

    Level: