Start using bulk AI tools in Excel

Bulk AI tools allow you to run prompts on specific spreadsheet columns at once without writing any formulas. You configure and run bulk tools from the add-in sidebar. You can also easily reuse past prompts and configurations with the History feature.

To get started with bulk AI tools, let's generate some text with the Custom prompt tool:

1. Download our bulk AI tools starter template, and open it in Excel as a new workbook.

2. In the Home tab, click GPT for Excel Word.

   

   info

   You can also select Home > Add-ins > My Add-ins > GPT for Excel Word.

3. In the sidebar menu, select Bulk AI tools.

   

4. Select Custom prompt.

5. Define the following settings:

   • Header row: Select 5. The bulk tool will process all rows with content below this row.

   • Prompt to run for each row: Enter the following prompt for the AI:

     Write a short SEO-optimized product description for a bike based on its specifications: {{Specifications}}

   • Put results in column: Select C.

   • Leave all other settings to their default values.

6. Run the bulk tool:

   1. Select All rows

   2. Click Run all rows.

   The bulk tool executes the prompt for every row with content, starting from row 6, and puts the responses generated by the AI in column C.

The following video shows the entire process.