Home › Category
AI for data and spreadsheets: 17 real cases with prompts
17 source-checked cases in Data. Each shows what happened and the prompt.
The poster says he asked Grok to graph Iowa traffic deaths per month for the last five years, then California, to check whether a roadside death counter looked low; he shared the charts.
Grok · Data · Source date:
- Build a support data pipeline and dashboard in under an hour with DevinRecreated promptEvidence: Company case study
At Eight Sleep, a support manager who used to need the data team for dashboards built an end-to-end pipeline and dashboard herself with Devin in under an hour, according to Devin's customer story.
Poster says:Under an hour
Devin · Data · Source date:
- Set up a Google Analytics dashboard with Claude in ChromeImproved promptEvidence: Described by posterFailure
Claude in Chrome spent 45 minutes building a Google Analytics dashboard, then couldn't work out how to drag one element, so it undid all of its work and told the poster it couldn't do it.
Claude in Chrome · Data · Source date:
- Turn a year of bank statements into a business expense spreadsheet with Claude CoworkRecreated promptEvidence: Described by poster
Claude Cowork extracted and categorized business expenses from a year of statements across several accounts into a well-organized spreadsheet; after some back-and-forth the poster fixed a handful of items by hand.
Claude Cowork · Data · Source date:
- Build a credit risk scorecard in Excel with Claude in ExcelImproved promptEvidence: Shown on videoPartial
Given a credit risk dataset and a brief for an Excel-native scorecard, Claude in Excel built a polished 28-sheet workbook but skipped the variable clustering, ran the model in JavaScript and reported 0.706 AUC on training data with no split; ChatGPT followed the method and got 0.627 on test data.
Claude (Excel) · Data · Source date:
- Find smarter buying patterns in office supply order history with Claude CodeRecreated promptEvidence: Described by poster
Alex Hillman had Claude Code go through Indy Hall's paper products order history to suggest buying patterns that avoid costly last-minute orders.
Claude Code · Data · Source date:
- Analyze seven years of credit card statements with Claude CoworkRecreated promptEvidence: Screenshots or logs
From seven years of monthly credit card statement PDFs in zip files, Claude Cowork returned an Excel file with 5,726 extracted, categorized transactions plus analysis; issues were vendor transaction IDs and some miscategorized vendors it wasn't told how to handle.
Poster says:5,726 transactions categorized
Claude Cowork · Data · Source date:
- Sort a Google Sheet in a custom priority order with Claude in ChromeImproved promptEvidence: Screenshots or logsFailure
Asked to sort a Google Sheet in a custom order (critical, high, medium, low), Claude for Chrome kept trying to sort it alphabetically instead, per the poster's screenshot.
Claude in Chrome · Data · Source date:
- Build a cohort retention table in Excel with Copilot Agent ModeRecreated promptEvidence: Article or interview
Given a long table of customers by period, Excel's Copilot Agent Mode built a color-coded cohort retention table that DataCamp's reviewer found accurate to the data; it also added a useless chart he had to delete.
Microsoft Copilot Agent Mode (Excel) · Data · Source date:
- Fill missing industry details in a customer sheet with Zapier AgentsRecreated promptEvidence: Company case study
UK energy company egg set up a Zapier Agent that finds customers with missing industry details in a HubSpot-fed Google Sheet, searches for the information and updates the sheet; Zapier says it now takes about five minutes and egg no longer pays a contractor for it.
Poster says:About 5 minutes; contractor no longer needed
Zapier Agents · Data · Source date:
More Data cases
- Let a whole team self-serve data via an agent-written schema guide
- Merge provider price CSVs into one comparison table with Claude Code
- Automate a daily analytics summary to Slack with Claude Code
- Turn X bookmarks and likes into a searchable knowledge base
- Analyze every entry of a huge JSONL file with Claude Code subagents
- Compare Claude Code, Codex and Gemini CLI on a 97k-message chat dataset
- Reproduce an economics paper's findings from replication data with Claude