Data tools

Data tools


Note: We’re adding new tools and resources to this page regularly. If you have a bad experience with one, let us know about it and we’ll remove it if necessary. | Find more useful tools on our Coding page.

NICAR 24 Tipsheets
Slides, audio and other resources from sessions.

NICAR Conference Resources Database
Links to presentations, GitHub repos, and tipsheets this year. The database starts at 2020.
A spreadsheet “with superpowers.” Connect and analyze data, build forms and dashboards, automate and share them. Eliminate manual work that slows you down.

Write descriptive prompt and the material will appear in your Google Sheet.

Turn verbal descriptions into functional Excel formulas

AI Excel Bot
Turns plain text into Excel formulas

Sheet Copilot
Effortlessly automate your Google Sheets workflow with AI
Add ChatGPT to your Google Sheets or Excel. Seven-day free trial and pricing starting at $99 a year.

= Equals
Spreadsheet assistant  

Excel Formula Generator
Excel formula bot. Very simple to use

AI spreadsheet assistant

Supercharge your spreadsheets with GPT-powered AI tools for connecting data, building reports, and automatically analyzing and visualizing trends in your data.

Github CoPilot
Build scrapers and entire coding projects

Interview data with this tool. $20 a month

Monitor web page updates. Get an email when a page updates. Good for tracking government sites. Free with paid updates.
Monitor web pages. Free with paid updates.
Web scraping tool that you also can monitor pages with.
Web scraping tool
Web scraping tool. One-time fee to use.
Free web-scraping tool

Outwit Hub Scraper
Only the first 100 rows are free, then paid.

Advanced extraction and transformation of unstructured text data
Automate data extraction and capture. Transforms physical documents to structured digital data.

Numerous AI
Google Sheets and MS Excel are made simple. Use this AI tool to extract, categorize, generate formulas, and use ChatGPT to work like a pro.

GPT for Sheets and Docs Guide 
How to use GPT for Sheets and Docs add-ons

PDF Insight
Generates “insights and summaries of PDF documents uploaded by users.”
Upload PDFs and analyze them. Delete the PDF when you’re done for security.

Chat with a PDF you upload

Upload a PDF and ask questions of it.


Video: ChatGPT for Data Analytics
A one-hour, basic video tutorial on how to use the ChatGPT Data Analysis tool

InfoWorld: ChatGPT Tools for R Programming

Journalist’s Resource: Using Per Capita in Data Stories

ChatGPT custom GPT lets you build charts and diagrams from text.

Whimsical Diagrams
A custom GPT that explains and visualizes concepts with flowcharts, mindmaps and sequence diagrams.

Setting up Data Diaries

Chat Ur Data GPT
Boost productivity and unlock data insights with AI-driven assistance

Can help you extract data from images, conduct visual searches, summarize handwriting, translate photos, make presentations, and much more.

Professional diagrams for the web and AI

Use AI to automate data mappings with AI

AI-powered statistics for research

Simplify data analysis and automate tasks for better insights

GPT Guard
Unlock and freely use your data for AI and data analytics 

AI-generated dashboard and charts from your database.

Advanced AI analysis for SEC filings and financial news

Free maps that you can share with friends

An AI-driven tool created to help journalists and researchers better understand public comments on Federal regulation posted on
Use this cloud platform to analyze data

Realtime continuously scans public data sources and uses LLMs to translate the raw data into simple to understand charts and text, and ranks the most interesting updates. Journalists can use this tool to monitor data feeds that are important to them or discover new data related to their area of coverage.

The Inverted Pyramid of Data Journalism
The updated process chart from Paul Bradshaw

The Analyst Intelligence
Combines a no-code interface with advanced language models to handle big data analysis.

Ask any question and get answers in seconds

A ChatGPT plug-in and Chrome browser extension that generates custom automation with more than 30 applications. Scrape the web, update Google Sheets and boost your productivity.

Six Best AI Tools for Data Visualization in 2023

Top 7 Web Scraping Tools Using AI
List of tools appears lower in the guide, below the section explaining what scraping is.

Guides your chat conversations with helpful prompt recommendations. Useful for data analysis.

Pare down your reading time with data extraction, AI Copilot and paraphraser in one tool
Eliminate hours wasted finding, cleaning, visualizing and transforming data using the power of AI.

Data Analysis
Analyze and visualize data with this GPT

AI-driven interactive chart-making tool
DATA is your personalized AI co-worker. DATA Replaces Siri with ChatGPT, or any other language model of your choice.

Open-ssource HTML5 charts for your website

Make data-driven decisions with AI feedback

COA Beat Assistant
Filipino journalist Jaemark Tordecilla created a custom GPT to analyze documents from the Commission on Audit (COA) for investigtative journalists in his country.

Julius AI Android
Your AI-powered data analyst

Custom-build AI using open-source software and personal datasets

BBC: Content Provenance and the Fight Against Disinformation

Use AI to pull data insights

GIJN: Tips for Building Datasets from Scratch

GIJN: How to Use ChatGPT to Extract Data from PDFs
A good step-by-step with an excellent eight-minute training video at the end.

Webscrape AI

GIJN: Data Scraping Websites With Data Miner Browser Extension

Narrative BI
GPT-driven tool analyzes ad/marketing  data.

Mix Panel Spark
Allows you to chat with your data

PDF Parser
Analyze, visualize, and communicate data for insights

Pull nsights from qualitative data and enable decisions at scale

AI data extraction made ridiculously simple

Capitol AI
Data storytelling powered by AI

Powered by OpenAI’s GPT tech, this tool transform data into conversations. Your uploaded documents and data become the foundation of your chatbot’s knowledge, allowing it to engage in meaningful and productive conversations.

Super Tools Database
A large collection of AI tools organized by skills, including data. You can filter by free/paid tools

Chart Analyst GPT
Analyze any chart, instantly. Just paste or upload an image of your chart. Include as many indicators as you want.

Simplescraper – A tool that allows users to easily extract data from websites and convert it into a JSON or CSV file. startups that want to scale without hiring humans.
Analyze structured data and create visualizations.

Natural language data integration tool

Speak AI
Turn your language data into insights, fast and with no code

Creates data presentations readers love in seconds

A chatbot assistant for multisource information integration

Batch process your data with AI: classification, parsing, translation, transformation, etc.

Optimizes AI and data consultancy for small businesses

Streamline your analytics workflow. Free trial with paid tiers.

Our AI turns your data into personalized interactive views.

Freemium, open-source CSV importer
From simply monitoring website pages that have a change (such as watching prices, restock notification), to deep inspection such as PDF text support, JSON and XML monitoring and extensive text triggers.

Encrypt and analzye data

A simple API that can categorize, classify, or label any data.

Enables data insights with natural language

Turn spreadsheets into dashboards and auto-distribute up-to-date reports. Freemium tool

Chart plugin for Figma
Create charts and other visualizes

GIJC 2023 Data and Investigative Tools
Resources, including many AI tools, from the investigative journalists conference.

Collaborative map-making tool that lets you annotate, modify and visualize data. Free account that offers almost all features; $30 a month for advanced features.

Create and share maps. Good for businesses and anyone creating community events. Freemium account with pricing starting at $9 a month.

GIJN: Updating the Inverted Pyramid of Data Journalism

GIJN: Working With Mass Shootings Data

Practical data science tools for journalists.

Our World in Data: Our Personal Experiences and Imporance of Global Data

Understand patterns, analyze influential factors, and effortlessly make forecasts with their live data. Free trial and you can request a demo.

How to Choose the Right Visualization for Your Data
Open-source data pipeline tool for transforming and integrating data.

Simplify marketing data into charts and graphics

Mostly AI
Create AI-generated synthetic data based on your existing data sample. Eliminate privacy risks and preserve all your statistical attributes.

AI business data tool. Forecast revenue, analyze live data, visualize survey sentiment, track ad spend, and predict customer lifetime value in one intuitive platform.

Browse AI
Train a robot in two minutes to extract and monitor data from any website

Video: ChatGPT for Data Analytics
A one-hour, basic video tutorial on how to use the ChatGPT Data Analysis tool

ChatGPT AskyourPDF Plug-in
Turns your PDF into a chatbot at the end of the video may be helpful to data journalists.

More Data Journalism Tools
Build simple maps and charts. Freemium tool

Turn spreadsheets into visualizations, maps, interactives, etc. Freemium tool

RStudio makes R easier to use.

Python is an interpreted, object-oriented, high-level programming language with dynamic semantics.

First Python Notebook Course
A step-by-step guide to analyzing data with Python and the Jupyter Notebook.

Jupyter Notebook
Open-source software, open-standards, and services for interactive computing across dozens of programming languages

Build static or interactive graphics with this tool.
Basic interactive and static infographic maker. Good for making stand-alone charts, too.

StoryMap JS
Free, open source tool helps you build interactive maps.
Build all types of interactive maps, including timelapse maps.

Create interactive maps.

Create interactive maps.


PixelMap Generator
Build cool maps without code.

Mapping tool. JavaScript library for image- and vector-tiled maps in SVG (scalable vector graphics)

Create interactive charts for your websites.
Interactive and static infographic maker.
Basic interactive and static infographic maker.
Build interactive data visualizations and dashboards for the web.

Create interactive charts with a Javascript library.

Browser-based infographic-making tool.

Create, prototype, collaborate, and bring your ideas to life with the design platform used by over one million people — from freelancers, to the world’s largest teams.

Simple responsive charts. Will change the way the data is displayed based on the size screen it’s being viewed on.

Bellingcat Maps, Satellite and Streetview

Data Viz Mapping Tools

Media Hack: Mapping for Journalists – 9 Essential Tools

EthicalGeo: Ethical Mapping — How Not to Map

Geocoding and Mapping in Google Sheets
Training video from data journalist Daniel Carter.

GIJN: How to Use ChatGPT to Extract Data from PDFs
A good step-by-step with an excellent eight-minute training video at the end.

A great PDF to text tool.

Twitter data export tool.

Automated, self-fulling spreadsheet that you can use to take Twitter handles or LinkedIn URLs and have it fill out people’s information into a searchable spreadsheet.

Data Scraping in Google Sheets
This tutorial and formula will let you scrape HTML tables out of web pages. Created by Mike Reilley, Journalist’s Toolbox founder and SPJ digital trainer.

Introduction to Web Scraping
Python scraping primer with Mindy McAdams.

Wrangler is an interactive tool for data cleaning and transformation. Spend less time formatting and more time analyzing your data.

GIJN: How to Use ChatGPT to Extract Data from PDFs
A good step-by-step with an excellent eight-minute training video at the end.

Beginner’s Guide to Extracting Data from PDFs