FAQ

About these prompts

Most people staring at an exported spreadsheet or survey table do not need complex code first; they need to know what moved, what looks unusual and which cut of the data is worth checking next. These prompts take pasted tables, summary figures or open-ended survey responses and organize them into clear findings, caveats and recommended visuals.

Every prompt runs as pasted in ChatGPT, Claude or Gemini without requiring placeholders or setup. Each one includes a realistic example output so you can check the structure before pasting your own numbers, and asks the assistant to flag missing context or small sample sizes instead of overstating a conclusion.

How much spreadsheet data should I paste into a data analysis prompt?

Paste a clean summary table, a representative slice of rows with clear column headers or aggregated totals rather than a massive raw export. Removing personal identifiers such as customer emails or account numbers protects privacy while still giving the assistant enough structure to spot trends, outliers and useful follow-up checks.

Can ChatGPT, Claude or Gemini analyze open-ended survey responses accurately?

Yes. Qualitative coding is one of the strongest uses for chat models because they group free-text answers into recurring themes, pull representative quotes and count rough frequency patterns. Always ask the model to separate direct quotes from interpretation and skim the raw responses yourself to catch subtle sarcasm or minority edge cases.

How do I avoid math errors when using AI for data analysis?

Use chat prompts to frame the right questions, clean messy labels, explain patterns and draft formulas you run inside Excel or Google Sheets rather than trusting mental arithmetic on long columns. Verify every percentage change, total and average in your spreadsheet before putting figures into a stakeholder deck.

Do these prompts work in Claude and Gemini?

Yes. Claude is listed on every prompt here, Gemini is listed on every prompt here, and most text prompts run in any capable chat model. In Claude, paste the prompt into a new chat, or into a project's instructions to reuse it. In Gemini, use a new chat or save it as a Gem. Open in Claude or Gemini on a prompt's page starts the chat with it already typed.

Are these prompts free?

Yes. Every prompt is free to copy. A free account lets you save prompts to your own vault and edit them.