Skip to content
prompts-gpt.com
  • Prompts
  • Categories
  • Build a prompt
  • Studio
  1. Categories
  2. Excel

Best ChatGPT prompts for Excel and Google Sheets

Prompts that write formulas, clean messy data, build a budget sheet or explain what a spreadsheet is doing. They work for Excel and Google Sheets alike.

  1. Excel & Spreadsheets

    Build an Inventory Tracker Spreadsheet with Reorder Points and Low-Stock Alerts

    You get exact columns, copy-ready reorder-point formulas, a status column and conditional formatting that highlights items to reorder now or this week.

  2. Excel & Spreadsheets

    Build an Invoice Template in Excel or Google Sheets with Automatic Totals

    You get a cell-by-cell invoice layout with exact formulas for line totals, discount, tax, due date, and a duplicate-proof invoice numbering system.

  3. Excel & Spreadsheets

    Design a One-Page Manager Dashboard in Excel or Google Sheets

    Get a buildable one-page dashboard plan with a layout grid, a spec for each tile (metric, chart, filter, source range, formula) and numbered build steps.

  4. Excel & Spreadsheets

    Clean and Standardize Messy Spreadsheet Data with Exact Formulas

    Get a column-by-column cleaning plan with ready-to-fill formulas for spaces, case, dates and duplicates, plus a list of rows that need a manual check.

  5. Excel & Spreadsheets

    Design a Clean Spreadsheet Layout for a Tracker or Budget That Scales

    You get a complete sheet blueprint with tabs, column specs, data types, dropdown lists, summary formulas and setup steps that keep working as rows grow.

  6. Excel & Spreadsheets

    Explain Any Excel or Google Sheets Formula Step by Step in Plain English

    Paste a formula and get a plain-language walkthrough in evaluation order, a table of what each part returns, common ways it breaks with fixes, and a simpler version.

  7. Excel & Spreadsheets

    Summarize Pasted Spreadsheet Data into Key Findings and Trends

    Paste rows from Excel or Google Sheets and get numbered findings tied to exact figures, a trend table, data quality flags and the gaps that limit conclusions.

  8. Excel & Spreadsheets

    Write a Google Apps Script to Automate a Sheets Task with Dry-Run Mode

    Get a working Google Apps Script for your Sheets task, with trigger setup, the permission screens you will see, and a dry-run mode that logs changes first.

  9. Excel & Spreadsheets

    Build an Employee Shift Schedule and Hours Tracker with Overtime in Excel

    You get a ready-to-build spreadsheet layout with formulas for overnight shifts, unpaid breaks, weekly hours per employee and highlighted overtime.

  10. Excel & Spreadsheets

    Set Up Data Validation Rules That Stop Bad Entries in a Shared Excel Sheet

    You get a column-by-column validation plan with allowed values, custom formulas, input and error messages, plus a helper formula that flags rows already holding bad data.

  11. Excel & Spreadsheets

    Build Conditional Formatting Rules with Exact Formulas and Rule Order

    You get a table of conditional formatting rules with the exact custom formula, the range to apply each one to, colors, and a rule order that avoids conflicts.

  12. Excel & Spreadsheets

    Build Excel and Google Sheets Formulas for Workdays, Ages and Deadlines

    You get working date formulas for your exact layout, such as workdays, deadlines, ages and month offsets, with a holiday table, locale pitfalls and a test row.

  13. Excel & Spreadsheets

    Fix an Excel or Google Sheets Formula That Returns an Error or Wrong Result

    Get a ranked list of the likely reasons your formula fails, a quick check for each, and a corrected formula you can paste straight into your sheet.

  14. Excel & Spreadsheets

    Pick the Right Excel or Google Sheets Chart for the Point You Want to Make

    Get one recommended chart tied to your message, exact build steps for Excel or Google Sheets, a takeaway title, and one chart to avoid with the reason.

  15. Excel & Spreadsheets

    Pick XLOOKUP, VLOOKUP or INDEX MATCH and Get the Exact Formula

    You get one recommended lookup method for your Excel version and data layout, a paste-ready formula, and clear handling for values that have no match.

More hand-picked lists

  • ChatGPT prompts for job seekers
  • ChatGPT prompts for students
  • ChatGPT prompts for small business owners
  • ChatGPT prompts for writing emails
  • AI photo prompts for Instagram
  • All categories
prompts-gpt.com

Free prompts for ChatGPT, Claude, Gemini and coding agents, ready to copy and paste.

  • Prompts
  • Categories
  • Build a prompt
  • About
  • Contact

Categories

  • Email
  • Career
  • Social media
  • Excel
  • Personal finance
  • Marketing
  • Business
  • Image

By AI tool

  • ChatGPT
  • Claude
  • Gemini
  • Claude Code
  • Cursor
  • Codex

Best lists

  • Job seekers
  • Students
  • Small business
  • Email
  • Excel
  • Instagram photos

© 2026 Prompts-GPT.com

  • Privacy
  • Terms
  • Cookies