Skip to main content

Custom content generation within Excel

You can perform any text-based task within Excel using the Custom prompt bulk tool. This guide walks you through generating marketplace titles for pieces of furniture based on their description, and optimizing these results. To learn more about the Custom prompt bulk tool, see How to use the Custom prompt bulk tool.

Step 1: Get started

Prerequisites

Open the GPT for Excel add-in and run the Custom prompt bulk tool with your prompt Write a marketplace title for this product: {{A}} on a few rows to see how it works.

Click Home tab, GPT for Excel Word. Then Bulk tools tab, Custom prompt.

If you find the answers satisfactory, run the tool on all rows. Otherwise, check how to improve your results in Step 2.

Step 2: Improve your results

For best results, use gpt-4o, which offers higher accuracy. If your results are still not satisfactory (e.g., information is inaccurate, lacks coherence, or context), you can further improve them by considering the following approaches:

GoalRecommended approach
Improve accuracyAdd custom instructions
Include context and specific rules to follow.

You are writing copy for a retail website. Take SEO into account.
Play with creativitySet the creativity level
The creativity level must be adapted to the task. Use a high level for a creative writing task.
Use information from other cellsInsert more variables
If the model needs more context, you can insert variables for columns, cells and cell ranges in the prompt.

Write a marketplace title for product {{A}} with characteristics {{B}}. Write it in this language: {{C1}}. Include one of these terms: {{D1:D50}}.
Tip: Use data from other sheets with {{Sheet2!D1:D50}}

Best practice: Compare various results by putting the results in a new column each time you change the settings.

Once you have refined your approach and are satisfied with the results from the initial rows, you are ready to launch your custom prompt in bulk. Select more cells or even all cells, click Run rows, and watch GPT for Excel generate the rest of the titles.