Skip to main content

Prompt images in bulk in Excel

Use GPT for Excel to generate content based on images directly in Microsoft Excel. For example, you can generate descriptions for your product images to improve your listings.

info

  • Prompt images (Vision) is the only bulk AI tool that accepts images as input.

  • To use the Prompt images (Vision) bulk AI tool, you must select a vision model.

Run the bulk tool​

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

    GPT for Excel Word in the Home ribbon

    info

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

  2. In the sidebar, select Bulk AI tools, and click Prompt images (Vision).

    Prompt images (Vision) bulk AI tool in the sidebar

  3. In the model switcher, select a vision model.

    A vision model in the model switcher

  4. Set up your bulk tool run.

    Set up a Prompt images (Vision) run
FieldDescriptionExample

1

Header row

(optional)

If your column headers aren't in the first row, select the number of the row that contains the headers. The bulk tool will run on the rows below this one.

4

2

Prompt

Describe the task you want the AI to perform based on the target images. For example, ask a question about the images or request content based on the images.

Write a short description of this product based on how it looks, how it's used, and its build quality.

3

Columns containing image URLs

Select up to five columns that contain image URLs. For each row, the tool processes all images present in the selected columns. URLs must be publicly accessible.

Supported image formats:

  • PNG
  • JPEG
  • WebP
  • Non-animated GIF

B: Front image, C: In-use image, D: Material detail image

4

Image resolution

(optional)

Choose the level of detail for image processing:

  • High: Better image understanding, higher latency and cost
  • Low: Faster processing, lower cost
  • Auto: Let the model decide (default)

Low

5

Put results in column

(optional)

Select the column to put the results in. Cells in this column won't be overwritten with the results if they contain text.

E: Description

  1. Run the Prompt images (Vision) 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. Learn more.

    2. Click Run rows.

      Run the Prompt images (Vision) tool
      info

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

      Bulk AI tool History

You have set up and run the Prompt images (Vision) bulk tool. If needed, try improving the results.

Prompt images (Vision) results

Improve results​

Try different models​

Try different vision models to find the one that works best for your use case. We recommend using gpt-4.1 for most vision tasks.

Adjust the creativity level​

Adjust the level of creativity (accuracy vs. freedom) the AI is allowed in generating results. For example, if you're generating marketing copy, set a high creativity level to generate more engaging and imaginative text. If you're generating technical specifications, set a low creativity level to ensure the generated text is precise and factual.

Creativity level

Refine your prompt​

Be specific about what you want the AI to focus on. For example, specify which kind of description you want the AI to generate.

Instructions

Adjust image resolution​

Choose the appropriate image resolution setting based on your needs:

  • High: Use for detailed analysis where image quality and understanding are critical. This setting provides better image understanding but increases latency and cost.
  • Low: Use for faster processing and lower cost when basic image recognition is sufficient.
  • Auto: Let the model decide the optimal resolution (default).

For product descriptions and detailed analysis, consider using High resolution to ensure the AI captures all important visual details.

What's next​

Try another bulk AI tool.

On this page