Skip to main content

About GPT for Excel

GPT for Excel enables you to use ChatGPT directly in Excel. It is built on top of GPT-3.5 and GPT-4 models. Use GPT in Excel to edit, translate, explain, ask, classify, extract, summarize directly from your Excel workbook. With GPT for Excel, you get one GPT per cell. Applying a prompt to many cells is as easy as dragging a formula.

GPT for Excel is extremely powerful at:

Working with textWriting text
  • Cleaning data
  • Fixing grammar and spelling
  • Extracting entities
  • Tagging and categorizing
  • Translating
  • Taglines, headlines
  • Ad copy
  • Product descriptions
  • Subject lines, emails
  • Outlines, blogposts

Discover GPT functions

The add-in offers GPT functions for different use-cases. You can discover them by typing =GPT_ in a cell.

GPT_LIST and GPT_HLIST are particularly well suited to Microsoft Excel.

Why use GPT for Excel instead of ChatGPT?

ChatGPT is a chatbot interface, which is great to learn and play with GPT. But you probably do most of your work in real document editors like Microsoft Excel because your data is already in Microsoft Excel.

Using GPT for Excel will save you a lot of time by allowing you to:

  • Get many variations quickly
  • Apply prompts to Excel tabular data and get results as tables
  • Structure your prompts in Microsoft Excel
  • Save answers in Excel for easier retrieval
  • Avoid constant copy/pasting in ChatGPT
  • Benefit from all the Microsoft Excel features, including real-time collaboration