# 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 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(s). - Select the column to
*Put results in*.

- Enter the
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(s). - Select the column to
*Put results in*.

- Enter the
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.