3 stations · 16 tools

AI tools for data analysis

Tools for working with spreadsheets, documents and research data. Find services for cleaning, analysis, visualisation and reporting.

Quantitative

Visualization

Present finished numbers and insights clearly: charts, diagrams, infographics for reports and presentations.

Flourish

Builds interactive charts, maps and data stories from templates (now part of Canva).

Website
VisualizationYesOfficial
Julius AI

Upload a spreadsheet and ask in plain language: “average order value by region”, “test the difference”. AI runs the numbers and builds charts.

Website
Spreadsheets & Excel · VisualizationYesNo
Napkin AI

Turns text into diagrams, charts, mind maps and slides.

Website
VisualizationYesCommunity
Powerdrill

Upload spreadsheets and documents, ask questions in plain language and get calculations, charts and slides.

Website
Spreadsheets & Excel · VisualizationYesOfficial
Tableau

Dashboard and visual analytics platform; AI answers questions about your data.

Website
Statistics & BI · VisualizationYesOfficial
Kanaries

Ask a spreadsheet a question in plain language and get interactive charts; also available for Python (Jupyter).

Website
Spreadsheets & Excel · VisualizationNoNo
Flourish

Builds interactive charts, maps and data stories from templates (now part of Canva).

Free planMCP server

Visualization

Free · paid on request

Website
Julius AI

Upload a spreadsheet and ask in plain language: “average order value by region”, “test the difference”. AI runs the numbers and builds charts.

Free plan

Spreadsheets & Excel · Visualization

Free · paid from $20/mo

Website
Napkin AI

Turns text into diagrams, charts, mind maps and slides.

Free plan

Visualization

Free · paid from $9/mo

Website
Powerdrill

Upload spreadsheets and documents, ask questions in plain language and get calculations, charts and slides.

Free planMCP server

Spreadsheets & Excel · Visualization

Free · paid from $13.27/mo

Website
Tableau

Dashboard and visual analytics platform; AI answers questions about your data.

Free planMCP server

Statistics & BI · Visualization

Free · paid from $15/mo

Website
Kanaries

Ask a spreadsheet a question in plain language and get interactive charts; also available for Python (Jupyter).

Spreadsheets & Excel · Visualization

from $10.75/mo

Website

Questions and answers

Can I upload a CSV to an AI and ask questions in plain English?

Yes. You upload an Excel or CSV file, type a question such as "average order value by region", and the AI runs the calculation and draws a chart; always check AI output. Julius AI, Powerdrill and Rows all work this way and have free plans; Rows can also pull tables out of PDFs and images. Better Analyst (formerly Formula Bot) connects to spreadsheets or databases, answers questions and writes Excel formulas, and also has a free plan.

Is there an AI that runs statistical tests without coding?

Yes: several tools let you run tests from menus while AI suggests the method and explains the output in plain language. XLSTAT by Lumivero adds regression, factor and cluster analysis to Excel. Displayr imports SPSS and Excel survey data, builds crosstabs and dashboards, codes open-ended answers with AI (always check AI output) and has a free plan. IBM SPSS Statistics, the classic survey statistics package, now includes an AI assistant that explains results in plain language.

Which AI data visualization tools connect to Claude via MCP?

Several tools on this line have an official MCP server (Model Context Protocol, the standard that lets Claude work with an app directly): Flourish, Powerdrill and Tableau. Flourish builds interactive charts, maps and data stories and has a free plan. Powerdrill turns uploaded spreadsheets and documents into calculations, charts and slides; always check AI output. Tableau is a dashboard and visual analytics platform where AI answers questions about your data; it also has a free plan.

Is it safe to upload company data to an AI analytics tool?

It depends on what is in the file, so upload only what the analysis needs. Remove names, emails and phone numbers or replace them with IDs, and where possible use aggregated data (totals by region instead of customer rows). Julius AI, Powerdrill and ChatGPT process uploaded files on the vendor's side, so check their terms on data storage and model training first. If your team needs governed dashboards rather than one-off uploads, look at BI platforms such as Tableau.

Other research lines