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).
GPT for Excel is compatible with the following versions of Microsoft Excel:
| Office for Windows | Office for Mac | Office 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 |
Install GPT for Excel or GPT for Sheets.
Start the right way
Use GPT for Work in Microsoft Excel or Google Sheets.
Microsoft Excel
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:
Install GPT for Excel.
Open the extension from your spreadsheet menu.
Select the Bulk tools tab in the sidebar.
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.
Select if you want to run a specific number of rows or All rows. Then, click Run rows.
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:
Install GPT for Excel.
Open the extension from your spreadsheet menu.
Select a cell and start writing a formula using one of the available GPT functions for Excel. For example:
=GPT("Write a tagline", A2).
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:
Install GPT for Excel.
Open the extension from your spreadsheet menu.
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.
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.
GPT for Sheets 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:
Install GPT for Sheets.
Open the extension from your spreadsheet menu.
Select the Bulk tools tab in the sidebar.
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.
Select if you want to run a specific number of rows or All rows. Then, click Run rows.
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:
Install GPT for Sheets.
Open the extension from your spreadsheet menu.
Select a cell and start writing a formula using one of the available GPT functions for Sheets. For example:
=GPT("Write a tagline", A2).
For hands-on practice, use our Google Sheets 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:
Install GPT for Sheets.
Open the extension from your spreadsheet menu.
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.
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.
▶ (optional) Select the right model to begin with
▶ (optional) Choose to use your API key or not
What's next
- Use GPT for Excel or GPT for Sheets across various scenarios.
- Check our pricing page for detailed information on costs.