Generate

Generate content by combining cells from multiple columns in Microsoft Excel. For example, you can generate product descriptions based on specifications from different columns.

Run the bulk tool

Prerequisites

• You have installed GPT for Excel.
• You have opened an Excel spreadsheet containing text in one or more columns for generating new content.

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

   

   info

   You can also go to Home > Add-ins > My add-ins > GPT for Excel Word.

2. In the sidebar, select Bulk tools, and click Generate.

   

3. Set up your bulk tool run.

   

   	Field	Description	Example
   	Column name row (optional)	If your column names aren't in the first row, select the number of the row that contains the column names. The bulk tool will run on the rows below this one.	2
   	Using cells in column(s)	Select one or more columns containing the cells you want to use as context for the generation.	A: Model name, B: Type, C: Price, D: Weight, E: Frame
   	Generate for each row	Select the type of content you want to generate, such as a title or description. You can also enter a custom content type to generate, such as Social media ad or Email body.	Description
   	With these instructions	Customize the output by setting the language, tone, writing style, audience, format, length, and custom instructions specific to this generation task.	Language: English Tone: Optimistic Custom instructions: Use a few emojis
   	Put results in column	Select the column to put the results in. Cells in this column won't be overwritten with the results if they contain text.	F: Description
   	Get 2 variants per row (optional)	Enable this option to generate two variants for each row. The variants are placed in adjacent columns.	Disabled

4. Run the Generate bulk tool starting from the first empty cell in the results column:

   1. Select a specific number of rows to run or select All rows.

   2. Click Run rows.

      
      info

      GPT for Work saves the setup in its bulk tool run history. You can reuse the setup by selecting it from History.

      

You have set up and run the Generate bulk tool. If needed, try improving the results.

Improve results

Try different models

Find out which models work best for different use cases in our AI models overview. You can try different models by selecting them in the model switcher.

info

The model selection is a spreadsheet setting. It applies to all bulk tool runs and all GPT function executions in the current spreadsheet.

tip

When using the sonar model for web search, enable Show sources to write the source references in the column to the right of the results column. This helps you understand the origin of the content and assess its reliability.

Provide generation instructions

You can improve generation quality by providing specific instructions that help the AI more closely follow your requirements for tone, writing style, format, and other aspects.

You can define the following types of instructions for the AI:

• Generation instructions are defined for the current bulk tool run.
• Global instructions can also be defined in the spreadsheet settings and apply to all bulk tools and GPT functions in the current spreadsheet.

If both and global instructions are defined, the AI uses both as a combined set of instructions. For consistent results, make sure both sets of instructions are aligned and do not contradict each other.

For example, set the current run to use a few emojis and instruct the AI to be concise in all runs:

Adjust the creativity level

Adjust the level of creativity (accuracy vs. freedom) the AI is allowed in generating results. Use a high level for a creative writing task.

info

Creativity is a spreadsheet setting. It applies to all bulk tool runs and all GPT function executions in the current spreadsheet.

What's next

Try another bulk tool.