Skip to main content

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
You have installed GPT in Excel on your account.

  1. Get ready to use the example template:

    1. Download the example template.

    2. Open the XLSX file you have juste downloaded and Enable Editing.

    3. Click GPT in Excel in the Home tab.

      You can now execute any GPT function from the workbook.

  2. Quickly translate data:

    1. 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 cell A12 (Apples) into Spanish (Manzanas).

    2. 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.

  3. Quickly extract data:

    1. Select cell B35. The formula indicates that this cell is the outcome of the extraction of an email address from cell A35.

    2. 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.

Go further