Get started with GPT in Excel
Get started by discovering two example use cases: translating text and extracting email addresses directly in your Microsoft sheet. You can follow along by downloading our example template.
Prerequisites
Get ready to use the example template:
- Download the example template.
Open the XLSX file you have juste downloaded and Enable Editing.
Click GPT in Excel in the Home tab.
You can now execute any GPT function from the workbook.
Quickly translate data:
Open the Get started sheet, and select cell B12. The formula indicates that the value in this cell is the outcome of the
translation
of cellA12
(Apples) intoSpanish
(Manzanas).Drag the formula down to apply it to the values below.
All the fruit and vegetable names from column A are translated into Spanish, and displayed in column B.
Quickly extract data:
Select cell B35. The formula indicates that this cell is the outcome of the
extraction
of anemail
address from cellA35
.Drag the formula down to apply it to the values below.
All the email addresses are extracted from the input cells in column A, and displayed in column B.
You have successfully executed two GPT functions in Microsoft Excel: GPT_TRANSLATE and GPT_EXTRACT.
- Discover more examples from the template.
- Learn how to use the GPT function.