Do these work for both Google Sheets and Excel?

Yes — just tell the prompt which one you're using and it adapts the formula syntax. There are also dedicated prompts for Notion formulas, which use their own syntax. Each prompt explains what the formula does so you can tweak it yourself.

Back to Collections

ai-prompts-for-spreadsheetsPublic

AI Prompts for Spreadsheets & Formulas

Google Sheets and Notion formulas, building sheets from scratch, cleaning messy data, dashboards. Describe it in plain words, get the formula.

6 prompts

Prompts in this collection

Showing 6 prompts

ChatGPT

Turn Messy Data Into a Clean Table

Paste the mess. Get back something structured you can actually use.

Data

ChatGPT

Write Me a Google Sheets Formula

Describe what you want the cell to do. Get the exact formula, explained.

Data

ChatGPT

Build a Spreadsheet From Scratch

Tell it what you need to track. Get the whole sheet structure, formulas included.

Data

ChatGPT

Write a Notion Formula

Notion formulas are their own special pain. Describe the goal, get the formula.

Productivity

ChatGPT

Build a Spreadsheet Dashboard

Turn rows of data into a dashboard that shows what matters at a glance.

Data

ChatGPT

Explain (or Fix) This Spreadsheet Formula

Inherited a formula you don't understand or that's throwing an error? Decode it.

Data

Frequently asked questions

More collections

AI Prompts for App Security & Audits

9 prompts

AI Prompts for Creators & Newsletters

7 prompts

AI Prompts for Life Admin

5 prompts

AI Prompts for AI Search & GEO

4 prompts

AI Prompts for Amazon & Etsy Sellers

6 prompts

AI Prompts for Local Businesses

12 prompts