Data tools

Data tools

AI SPREADSHEET AND SCRAPING TOOLS | PDF CHAT

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.

Rows.com
A spreadsheet “with superpowers.” Connect and analyze data, build forms and dashboards, automate and share them. Eliminate manual work that slows you down.

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

GPTExcel
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 

Numerous.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

Equals
AI spreadsheet assistant

Coefficient
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

ChatCSV
Interview data with this tool. $20 a month

VisualPing
Monitor web page updates. Get an email when a page updates. Good for tracking government sites. Free with paid updates.

Distill.io
Monitor web pages. Free with paid updates.

Browse.ai
Web scraping tool that you also can monitor pages with. 

Parsehub.com
Web scraping tool

Scrap.so
Web scraping tool. One-time fee to use.

Parsehub.com
Free web-scraping tool

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

DATAKU
Advanced extraction and transformation of unstructured text data

FormX.ai
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.”

PDF.ai
Upload PDFs and analyze them. Delete the PDF when you’re done for security.

ChatPDF
Chat with a PDF you upload

CallPDF
Upload a PDF and ask questions of it.

ExcelFormulaBot

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


CHARTS AND OTHER AI TOOLS

Daigr.am
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

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

DGM
Professional diagrams for the web and AI

Lume
Use AI to automate data mappings with AI

Hepta
AI-powered statistics for research

Matrices
Simplify data analysis and automate tasks for better insights

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

Supadash
AI-generated dashboard and charts from your database.

Fintool
Advanced AI analysis for SEC filings and financial news

PamPam
Free maps that you can share with friends

Commons-Project
An AI-driven tool created to help journalists and researchers better understand public comments on Federal regulation posted on Regulations.gov.

Judy.ai
Use this cloud platform to analyze data

RealTime
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.

DataGPT
Ask any question and get answers in seconds

Bardeen
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.

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

SciSpace
Pare down your reading time with data extraction, AI Copilot and paraphraser in one tool

Rose.ai
Eliminate hours wasted finding, cleaning, visualizing and transforming data using the power of AI.

Data Analysis
Analyze and visualize data with this GPT

Graphy
AI-driven interactive chart-making tool

HeyData.org
DATA is your personalized AI co-worker. DATA Replaces Siri with ChatGPT, or any other language model of your choice.

Chart.js
Open-ssource HTML5 charts for your website

UserWise
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

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

BBC: Content Provenance and the Fight Against Disinformation

Grapha
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

Reveal
Pull nsights from qualitative data and enable decisions at scale

Parsuer
AI data extraction made ridiculously simple

Capitol AI
Data storytelling powered by AI

Bothatch
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.

Julius.ai
Analyze structured data and create visualizations.

Sparkboard
Natural language data integration tool

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

STORYD
Creates data presentations readers love in seconds

Owlbot
A chatbot assistant for multisource information integration

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

Levytation
Optimizes AI and data consultancy for small businesses

HEX
Streamline your analytics workflow. Free trial with paid tiers.

Breadcrumb
Our AI turns your data into personalized interactive views.

TableFlow
Freemium, open-source CSV importer

ChangeDetection.io
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.

Capepreivace
Encrypt and analzye data

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

ChatDB
Enables data insights with natural language

Equals
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.

Felt
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.

Proxi
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

FreeMapTools

Investigate.ai
Practical data science tools for journalists.

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

Akkio
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

Mage.ai
Open-source data pipeline tool for transforming and integrating data.

AlphaWatch
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.

Akkio
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

Trickle.so at the end of the video may be helpful to data journalists.


More Data Journalism Tools

Datawrapper.de
Build simple maps and charts. Freemium tool

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

RStudio
RStudio makes R easier to use.

Python
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

Venngage
Build static or interactive graphics with this tool.

Infogr.am
Basic interactive and static infographic maker. Good for making stand-alone charts, too.

StoryMap JS
Free, open source tool helps you build interactive maps.

CartoDB.com
Build all types of interactive maps, including timelapse maps.

MapStack
Create interactive maps.

Maphub
Create interactive maps.

TimeMapper

PixelMap Generator

MapCreator.io
Build cool maps without code.

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

Highcharts
Create interactive charts for your websites.

Visual.ly
Interactive and static infographic maker.

Easel.ly
Basic interactive and static infographic maker.

Plot.ly
Build interactive data visualizations and dashboards for the web.

Flot
Create interactive charts with a Javascript library.

Visme
Browser-based infographic-making tool.

Sketch
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.

Chartist
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.

PDFPlumber
A great PDF to text tool.

ExportData
Twitter data export tool.

Clay
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.

DataWrangler
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