Data Scraping with Google Sheets to assist Journalism and OSINT — Tutorial

Every red dot is a People’s Liberation Army Air Force location. If you want to research the number of military planes China has, for example, why start from scratch? A lot of the work is already done — namely, a list of locations to start the search.

The internet is full of data which can be used to make your life easier. Today’s tutorial will look at taking such data and turning it into a useful format for journalists and open-source intelligence analysts.

First, a bit about what we will cover. This tutorial will be based on a small project I did which converted data from a Wikipedia…