Gemini
Best Gemini Prompt for Excel & Data
Copy, customize, and use this Gemini prompt for Excel & Data.
Intermediate
Why Gemini?
Gemini can analyze large datasets pasted directly into context, write complex Excel formulas, generate Python/SQL data processing scripts, and explain statistical findings in plain language — all without file upload limits that restrict smaller models.
Prompt Template
You are a data analyst and Excel expert.\n\nI have the following dataset / problem:\n{data_description}\n\nSample data (paste rows here if applicable):\n{sample_data}\n\nI need help with: {task_type}\nOptions: formula writing | data cleaning | pivot table design | chart recommendation | statistical analysis | Python/pandas script | SQL query\n\nSpecific ask: {specific_ask}\n\nPlease provide:\n1. The exact solution (formula, script, or query) ready to use — no pseudocode\n2. A plain-English explanation of what it does and why it works\n3. Any edge cases or errors I should watch out for (e.g., empty cells, text in number columns)\n4. One optimization tip if a faster or more robust approach exists\n5. If writing a formula: show the step-by-step logic broken into sub-formulas before combining\n\nIf I pasted sample data above, validate your solution against that data and show the expected output. Example Output
**Formula (Excel):**\n=SUMIF($F$2:$F$1000,F2,$E$2:$E$1000*$D$2:$D$1000)/SUMPRODUCT($D$2:$D$1000,$E$2:$E$1000)\n\n**Plain English:** SUMIF calculates this rep's total revenue; SUMPRODUCT gives the grand total. Dividing gives the percentage share.\n\n**Edge cases:** If Unit Price column has '$' symbols stored as text, SUMPRODUCT returns 0 — strip formatting first.\n\n**Optimization:** For 50K+ rows, move to Power Query or a pandas groupby for speed.
Make it yours
Your Generated Prompt
Prompt copied! What's next?
Got your AI output? Make it better.
Paste what Gemini generated into Coda One and keep the next rewrite or cleanup pass in one browser flow.
Tips for Better Results
Paste 10-20 sample rows of actual data alongside your description — Gemini will validate formulas against real values. For complex data problems, describe the desired output first, then let Gemini design the formula architecture. Ask for both Excel and Google Sheets versions if you switch between tools.
Example (filled in)
data_description=Monthly sales data with columns: Date, Region, Product SKU, Units Sold, Unit Price, Rep Name, sample_data=5 rows of CSV data, task_type=formula writing, specific_ask=Calculate each rep's total revenue contribution as a percentage of overall revenue, dynamically updating as new rows are added