Browse Topics

  • 9/11 Terrorist Attacks
  • Advertising and Marketing
  • Agriculture
  • AI for Journalists
  • Audience Engagement
  • Broadcast Journalism
  • Business Resources
  • Census coverage
  • Check Domain Names
  • College Media
  • Cool Sites
  • Copy Editing
  • Copyright Issues
  • Coronavirus and COVID-19 Archives
  • Covering Hate
  • Covering Homlessness
  • Covering Mass Shootings
  • Covering Protests
  • Covering Suicide
  • Crime
  • Daily News Sites
  • Data Journalism
  • Data Scraping
  • Design/Visual
  • Digital Journalism
  • Digital Security
  • Disability Resources
  • Diversity Issues
  • Drones and VR
  • Education
  • Elections/Politics
  • Entertainment: Movies | TV | Music
  • Environment
  • Ethics
  • Expert Sources
  • Federal Government
  • First Amendment
  • Freelance Resources
  • Gender Issues
  • General Research Tools
  • Global Journalism
  • High School Journalism
  • History
  • Holiday Trends
  • Immigration Issues
  • Interactivity
  • Investigative
  • Iraq Resources
  • Journalism Books
  • Journalism Jobs
  • Journalist Safety
  • Labor Issues
  • Legal Resources
  • Lifestyles
  • Listservs and Newsgroups
  • Local News
  • Mapping Resources
  • Math for Journalists
  • Medical/Health Index
  • Mental Health for Journalists
  • Military and Bioterrorism
  • Mobile Journalism
  • NASA and Space Industry
  • News Industry Sites
  • Newsletters
  • Other Journalism Research
  • Photojournalism
  • Podcasting
  • Productivity
  • Public Records
  • Public Relations
  • Public Safety
  • Religion
  • Reporting Tools
  • School Violence
  • Science Resources
  • Search Engines
  • Social Media Resources
  • Sports Resources
  • State Government
  • Teaching Tools
  • Tech News and Tools
  • Transcription Tools
  • Trust and Verification
  • Weather
  • Wildfires
  • Writing Resources
  • 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 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.


    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

    Turning a spreadsheet into an HTML table.
    Add search functionality to an HTML table.
    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.

    Effortlessly send personalized emails and text messages from a Google Sheet.

    Guides and Training 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.


    Return to Data Journalism | Public Records | Investigative Journalism | Digital Journalism