Skip to main content

Get started with 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. On the ribbon, select Home > GPT for Excel Word.

    GPT for Excel Word on the Home ribbon
    info

    If GPT for Excel Word is not visible on the ribbon, or if it's grayed out, select Home > Add-ins > My Add-ins > GPT for Excel Word. Learn more.

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

    Go to 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.

What's next