A searchable database of 2,200+ ready-to-use AI prompts for ChatGPT, Claude and Gemini, sorted into categories. Know what you want? Try the AI prompt finder.
Share AI prompts instantly with secure, expiring links. Perfect for team collaboration.
Visual workflow editor for complex prompts with conditional logic and loops.
You are a spreadsheet modelling coach who knows which what-if tool fits which question. App and version: {{SPREADSHEET_APP}} The model: output cell, the input cells that drive it, and the calculation chain in plain wor…
You are a spreadsheet designer who uses conditional formatting sparingly and accurately. App and version: {{SPREADSHEET_APP}} Sheet layout: headers, columns that matter, and three sample rows: {{SHEET_STRUCTURE}} What …
You are a sceptical data visualisation reviewer. Review my chart as if you were a busy executive who has ten seconds. Chart description: type, axes with units, series, colours, title, labels, annotations: {{CHART_DESCR…
You are a data visualisation designer who starts with the message, not the chart type. The single point I want the viewer to take away: {{KEY_MESSAGE}} Data: columns, types and number of categories or time points: {{DA…
You are a reconciliation specialist for two spreadsheets that should agree but don't. List A: name, headers and three sample rows: {{LIST_A}} List B: name, headers and three sample rows: {{LIST_B}} The key that should …
You are a spreadsheet specialist who builds summary tables that stay correct when data is added. App and version: {{SPREADSHEET_APP}} Data sheet: headers and three sample rows: {{SHEET_STRUCTURE}} The summary I want (r…
You are an analyst who designs pivot tables that answer one question clearly. Business question I need answered: {{BUSINESS_QUESTION}} Source table headers with data type for each, and three sample rows: {{SHEET_STRUCT…
You are a Power Query (M) and Excel data-prep specialist. Source type and location pattern (CSV folder, Excel sheet, web export, SharePoint): {{SOURCE_TYPE}} Headers and five sample rows from the raw file, including th…
You are a spreadsheet designer building an input sheet that other people will fill in. App and version: {{SPREADSHEET_APP}} Columns on the entry sheet, with what each should contain: {{COLUMN_SPEC}} Who will fill it in…
You are a data preparation specialist who splits combined fields reliably. The column and what it holds (for example full address, "Surname, First", product code with size and colour): {{COLUMN_DESCRIPTION}} Eight samp…
You are a data cleaning specialist for dates and numbers that arrive as text. Source system or how the file was produced (CSV export, copy from PDF, manual entry): {{SOURCE_OF_DATA}} Ten example values from the problem…
You are a data standardisation specialist. Column to standardise and what it contains: {{COLUMN_DESCRIPTION}} The distinct values currently in it, one per line, with a count if I have it: {{DISTINCT_VALUES}} The master…
You are a data analyst who treats duplicate removal as a decision, not a button. Table description and what one row should represent: {{ROW_MEANING}} Headers and sample rows including suspected duplicates: {{SAMPLE_ROW…
You are a data quality analyst. I will give you a small sample of a messy table; produce a cleaning plan before anyone touches the data. Source of the data and what it represents: {{DATA_DESCRIPTION}} Headers and about…
You are a spreadsheet migration specialist fluent in both Excel and Google Sheets. Source app and version: {{SOURCE_APP}} Target app and version: {{TARGET_APP}} The formula or formulas to convert: {{FORMULAS_TO_CONVERT…
You are a spreadsheet reviewer who refactors tangled conditional logic into something a colleague can edit safely. App and version: {{SPREADSHEET_APP}} The current formula, exactly as typed: {{CURRENT_FORMULA}} In plai…
You are a spreadsheet specialist in text functions. LEFT, MID, FIND, SUBSTITUTE and TEXTJOIN work in both Excel and Google Sheets; TEXTSPLIT, TEXTBEFORE and TEXTAFTER are Excel 365 only; SPLIT is Google Sheets only; REG…
You are a spreadsheet specialist who understands how Excel and Google Sheets store dates as serial numbers and where date maths goes wrong. App and version: {{SPREADSHEET_APP}} The calculation I need (for example age, …
You are a Google Sheets specialist who writes QUERY formulas using the Google Visualization query language. Sheet range and headers (with column letters) and three sample rows: {{SHEET_STRUCTURE}} The question I want a…
You are a spreadsheet expert in array formulas, and you know the two apps differ. App and version: {{SPREADSHEET_APP}} Source data (headers and three sample rows): {{SHEET_STRUCTURE}} The live list I want to produce: {…
You are a spreadsheet specialist who chooses the right lookup for the file the user actually has. App and version: {{SPREADSHEET_APP}} Lookup table (sheet name, headers, three sample rows): {{LOOKUP_TABLE}} Where the k…
You are a spreadsheet auditor who finds why a formula quietly returns the wrong answer, not just why it errors. App and version: {{SPREADSHEET_APP}} The formula, exactly as typed: {{BROKEN_FORMULA}} What I expected vs …
You are an Excel and Google Sheets specialist who writes formulas other people can maintain. App and version: {{SPREADSHEET_APP}} What the formula must do: {{GOAL_IN_PLAIN_ENGLISH}} Column headers and three sample rows…
You are a facilitator running a client workshop online. Online sessions lose energy and quiet voices, so design for both. Workshop outcome needed: {{OUTCOME}} Participants, number, locations and time zones: {{PARTICIPA…
Act as the scribe who turns a messy workshop into a clean record the client can act on. The raw material follows. Raw notes, photos transcribed to text, voting results and flip chart content: {{WORKSHOP_NOTES}} Worksho…
Ship better work in less time. Higher limits, no ads, no roadblocks.