Skip to main content

Quickstart for spreadsheets

With GPT for Work, use ChatGPT and other AIs to power through thousands of repetitive, tedious tasks in bulk directly in Microsoft Excel and Google Sheets.

Choose between Microsoft Excel and Google Sheets

If you have the choice, use Microsoft Excel as it is generally faster, smoother, and better handles large numbers of rows (200,000+ rows).

info

GPT for Excel is compatible with the following versions of Microsoft Excel:

Office for WindowsOffice for MacOffice for the web

Microsoft 365 subscription:

Excel: Version 2002 (Build 12527.20092)

Retail perpetual:

Excel: Version 2002 (Build 12527.20092)

Volume-licensed perpetual:

Excel 2021: Version 2108 (Build 12527.20092)

Excel: Version 16.35 (Build 20030802)

Excel: Supported

Which version of Excel am I using?

Install GPT for Excel or GPT for Sheets.

Start the right way

Use GPT for Work in Microsoft Excel or Google Sheets.

GPT for Excel provides three powerful features:

  • Bulk tools for a user-friendly prompting located in the add-on sidebar and for high volume (above 1000 rows)
  • GPT functions for a formula-like experience and for experimenting or working with up to a few hundred cells
  • Formula assistant for creating and troubleshooting formulas

Bulk tools

Use bulk tools if:

  • You want to perform bulk (row-by-row) operations on columns.
  • You are working with thousands of rows.
  • You prefer a simpler interface.
  • You don't want to deal with spreadsheet formulas.

To use bulk tools:

  1. Install GPT for Excel.

  2. Open the extension from your spreadsheet menu.

  3. Select the Bulk tools tab in the sidebar.

  4. Choose a tool (e.g., Custom prompt) and configure it:

    • Enter the Prompt to apply to your column or columns.
    • Select the column to Put results in.
  5. Select if you want to run a specific number of rows or All rows. Then, click Run rows.

    Custom prompt demo for Excel

GPT functions

Use GPT functions if:

  • You're comfortable using spreadsheet formulas.
  • You're just experimenting or working with up to a few hundred cells.
  • You need the flexibility of function parameters, function chaining, or combining with native formulas such as IF or CONCATENATE.

To use GPT functions:

  1. Install GPT for Excel.

  2. Open the extension from your spreadsheet menu.

  3. Select a cell and start writing a formula using one of the available GPT functions for Excel. For example: =GPT("Write a tagline", A2).

    GPT functions demo for Excel
tip

For hands-on practice, download our Microsoft Excel example template.

Formula assistant

Use the formula assistant if:

  • You need help with creating formulas.
  • You want to understand what an existing formula does.

To use the formula assistant:

  1. Install GPT for Excel.

  2. Open the extension from your spreadsheet menu.

  3. In the sidebar, in the formula assistant section:

    • To generate a formula, expand Generate formula, describe in plain English what you want to achieve, and click the Generate formula button. After the AI has generated the formula, insert or copy the formula into your sheet.

      Formula assistant generation demo for Excel
    • To explain a formula, expand Explain formula, either enter the formula or get one from the currently active cell, and click the Explain formula button. The AI generates an explanation of what the formula does.

      Formula assistant explanation demo for Excel

(optional) Select the right model to begin with


(optional) Choose to use your API key or not


What's next