Skip to main content

Summarize

Use the Summarize bulk tool to generate a summary for each cell of a given column in the chosen format. You will get one summary per row.

For example, if you have a column containing 1000 articles about the technology sector, you can use this tool to generate 1000 concise summaries for a daily tech press review.

Prerequisites
  1. Click GPT for Excel Word in the Home tab. If you don't see it, go to Home > Add-ins > My add-ins > GPT for Excel Word.

  2. Click Summarize from the Bulk tools tab.

  3. Configure the summarization tool to match the data in your sheet:

    1. Select the column you want to Summarize.

    2. Choose a predefined Format for your summaries.

      info

      Use Custom format to specify a different language if your text is not in English, as the default summarization is in English.

    3. Select the column to Put results in.

      The image shows the process of entering data to summarize, select the format, and choose a column to put the results in.
    info

    Using gpt-3.5-turbo models may result in less accurate results. To achieve enhanced accuracy, select the gpt-4o model. Learn more.

  4. Select if you want to run a specific number of cells or All cells. Then, click Summarize cells.

Each cell is summarized in the selected column using the chosen format.