playbooks
Learn Cursor Rules Windsurf Rules MCPs Modes
Log in

ChatGPT can make your spreadsheet!

Create, edit and manage spreadsheets with ChatGPT using a simple text-based interface that mimics Excel's rows and columns.
Back to prompts
Category
Productivity
Stats
37 views
0 copies
0 likes

Prompt

Open in ChatGPT
Copy
Act as a text based excel, you'll only reply me the text-based
{{rows}}
rows excel sheet with row numbers and cell letters as columns
{{range}}
, First column header should be empty to reference row number, I will tell you what to write into cells and you'll reply only the result of excel table as text, and nothing else, Do not write explanations, i will write you formulas and you'll execute formulas and you'll only reply the result of excel table as text, First, reply me the empty sheet

{{information}}
Rows
Range
Information

This prompt transforms ChatGPT into a text-based spreadsheet tool similar to Excel, allowing you to create and manage tabular data directly in your conversation. No need to switch to another application for simple spreadsheet tasks!

How to Use

  1. Start by setting your desired spreadsheet dimensions in the prompt
  2. ChatGPT will generate an empty spreadsheet with your specified parameters
  3. Enter cell data, formulas, or commands in your follow-up messages
  4. The AI will update and display the current state of your spreadsheet

To modify your spreadsheet:

  • Specify cell references (like "A1") and their content
  • Enter formulas starting with "=" (e.g., "=SUM(A1:A5)")
  • Request operations like sorting, filtering, or formatting

Variables Explained

  • {{rows}}: The number of rows you want in your spreadsheet (e.g., 10, 20, 50)
  • {{range}}: The column range using Excel-style lettering (e.g., "A-F" for 6 columns)
  • {{information}}: Your data, formulas, or spreadsheet commands

Tips for Best Results

  • Keep spreadsheets reasonably sized (under 50 rows and 15 columns) for better readability
  • Be specific with cell references (e.g., "Put 'Revenue' in cell B1")
  • For complex formulas, break them down into simpler steps
  • If you need to perform math operations, use proper formula syntax (e.g., "=B2*C2")
  • Remember that this is a text-based simulation, so advanced Excel features may be limited

Example Commands

  • "Put 'Total' in A10"
  • "In B2 through B5, put the values 10, 15, 20, 25"
  • "In B6, calculate the sum of B2 through B5"
  • "Sort column B from highest to lowest"
Want to 10x your AI skills?

Get a free account and learn to code + market your apps using AI (with or without vibes!).

Nah, maybe later