Spreadsheets
Spreadsheets
Note: Find related resources on the Toolbox’s Data Scraping and Math for Journalists pages.
Pro tip: To open a new Google Sheet on the fly, simply type sheets.new into a browser window and one will open. Don’t forget to title it and move it to a specific Google Drive folder.
For more training videos on scraping data from maps and images, visit our YouTube page.
Tools
Nature: Six Steps for Better Spreadsheets
Nature Tech Editor Jeffrey Perkel offers tips.
Excel Formula Bot
Type in a sentence describing what you want the spreadsheet to do and the bot uses AI to generate a formula.
Google Sheets Formula Bot
Type in a sentence describing what you want the spreadsheet to do and the bot uses AI to generate a formula.
PDF 24 Tools
Edit, merge, split and convert PDF documents
Paul Bradshaw: Finding Stories in Spreadsheets
Tableizer
Turning a spreadsheet into an HTML table.
DataTables.net
Add search functionality to an HTML table.
Rows.com
A living spreadsheet.
GPT3 Functions for Google Sheets
For more training videos, visit our YouTube page.
Casual Scenarios for Google Sheets
A Google Sheets add-on that lets you define ranges for your model’s assumptions, and the add-on runs hundreds of simulations to show you the range of possible scenarios.
Email Spreadsheets
A Google Sheets add-on. Email sheetss, charts and dashboards on a recurring schedule in PDF, CSV or Excel format. Send individual sheets, entire workbook or email a specific range of cell.
Postsheet
Effortlessly send personalized emails and text messages from a Google Sheet.
Guides and Training
DataJournalism.com: Spreadsheets for Journalism
A great primer from Brant Houston at the University of Illinois
NY Times: How We Helped Our Reporters to Learn to Love Spreadsheets
Cal Berkeley: A Quick and Easy Guide to Spreadsheets
Ken Blake: Spreadsheet Basics for Journalists
GIJN Training Videos: Spreadsheets, R and R Studio, SQL and More
GIJN: Analyzing Data – Spreadsheets
For more training videos, visit our YouTube page.
Related
Return to Data Journalism | Public Records | Investigative Journalism | Digital Journalism