Skip to main content

About GPT in Excel

What is GPT in Excel?​

GPT in Excel is an AI writer for Microsoft Excel. It enables you to use ChatGPT directly in Excel. It is built on top of OpenAI ChatGPT API. If ChatGPT was GPT for Chat, you can think of GPT in Excel as ExcelGPT.

GPT in 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
Try it out

Create a tagline for an ice-cream shop directly from a Microsoft workbook.

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 in 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 in Excel will save you a lot of time by allowing you to:

  • Get many variations quickly
  • Apply prompts to Excel tabular data and get responses 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
On this page