Skip to main content

Get started with GPT for Excel

GPT for Excel provides bulk tools and GPT functions for various applications. Get started with a very common use case: translating text.

Prerequisites
You have installed GPT for Excel on your account.

Get started with bulk tools

Bulk tools allow you to perform tasks on a whole column at once and don't require you to write any formula. These include translation, extraction, classification, web browsing, and summarization tools. The custom bulk tool additionally allows for addressing any other use case. The following steps focus on using the translation bulk tool.

  1. Open an Excel workbook containing text you want to translate.

  2. Click GPT for Excel Word in the Home tab.

  3. Click Translate from the Bulk tools tab, and:

    1. Select which column to Translate.
    2. Enter the language to translate To.
    3. Select the column to Write results in.
  4. Click Run cells.

Your content is translated and displayed in the selected column. Learn more on the Translate bulk tool.

Get started with GPT functions

GPT functions allow complex operations that can be chained together for maximum flexibility. You can use the GPT function to prompt OpenAI API and get the result in a single cell, or use one of the dedicated functions to perform specific tasks like translating, classifying , summarizing, extracting data, searching the web or describing images. The following steps focus on using the GPT_TRANSLATE function.

  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 for Excel Word 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.

You have successfully executed the GPT_TRANSLATE function in Microsoft Excel.

What's next