Software and other tools

When you try to install some of the software below, you will be warned that it comes from an unknown developer. To override this warning and install the software, right-click and select Open.

Google Sheets

Our spreadsheet application for these classes will be Google Sheets. Use from your Google Drive account.


Some of the tools we will use are Chrome add-ons. Ensure that you have the latest version of this popular web browser.

Sublime Text or Brackets

For some exercises, you will need a text editor optimized for authoring web pages. These are both good options.


Your go-to resource for color schemes to encode data. Web app: no installation required.

Color Oracle

Allows you to simulate the effects of three forms of colorblindness on your screen, to check that your charts and maps do not exclude the color-impaired. Download and move to your Applications folder. When launched, program icon will appear to the right of your menu bar. You can set to start at login under Preferences.

Tableau Public

Visualization software designed for exploratory graphic analysis, which also allows you to create interactive online graphics without JavaScript coding. You will also need to sign up for a free Tableau Public account.

The Public version of the software requires you to save your visualizations to the open web. However, members of Investigative Reporters and Editors can obtain a license for the Professional version, which allows you to save workbooks on your machine. In any case, I strongly recommend that J-School students join IRE as a student member: it is a leader for training in data journalism.

GitHub Desktop

Point-and-click GUI for version control of your projects, and synching with remote hosting at GitHub. Download from here. You will also need to sign up here for a free GitHub account.


Markdown editor, which will make authoring webpages much easier. Download from here. (If you are already using Markdown, feel free to keep using the editor of your choice.)

Open Refine

A powerful tool for data cleaning, once owned by Google, now open source. Download the version 2.8 from here. When launched, Open Refine will work in your default web browser; note that your data remains on your computer, and is not uploaded to the web.


A tool for extracting tables of data from digital PDFs. Downlaod from here. When launched, Tabula will work in your default web browser; again, your data remains on your computer, and is not uploaded to the web.

Mr. Data Converter

Allows you to convert tabular (spreadsheet/CSV) data to web-friendly formats including JSON. Web app: no installation required.

R and R Studio

R is a software environment and programming language for statistical computing and graphics. Download the for OSX from here. R Studio provides a user interface that makes it much easier to use. Download the latest free version of RStudio Desktop from here.

GPS Visualizer batch geocoder

Allows you to convert addresses to latitude and longitude coordinates. Web app: no installation required; however, you will need to sign up for API keys for the geocoding services it uses.


The leading open source Geographic Information System, which we will use to make maps and process geodata. Download version 3.0 from my website here, and download Python 3.6 from this link. First install Python 3.6, then install GDAL Complete from the QGIS Download, and finally install QGIS.

Mapbox Studio

Web-based map design studio. Sign up here for a free Mapbox account.

ImageMagick and FFmpeg

ImageMagick is a software library for creating, editing, converting and manipulating images, including animated GIFs. FFmpeg is a software library that records and converts audio and video.

We will use them in conjunction with R to make animated graphics. They take some time to install, so it is important that you do this before class.

Here are the steps for installation: