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).
Note: GPT for Excel is compatible with Microsoft 365 subscription and retail perpetual Office 2016 and later (version 2002+, Build 12527.20092+), Excel on Mac (version 16.35+), and Excel on the web.
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 two 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
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(s).
- 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, you can download our Microsoft Excel example template.
GPT for Sheets provides two 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
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(s).
- 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, you can use our Google Sheets example template.
▶ (optional) Select the right model to begin with
▶ (optional) Choose to use your API key or not
- Use GPT for Excel or GPT for Sheets across various scenarios.
- Check our pricing page for detailed information on costs.