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
- You have installed GPT for Excel.
- You have opened a workbook containing text to edit in a column.
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.
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:
Goal | Recommended approach |
---|---|
Improve accuracy | Add custom instructions Include context and specific rules to follow.
|
Play with creativity | Set 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 cells | Insert more variables If the model needs more context, you can insert variables for columns, cells and cell ranges in the prompt.
{{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.