How to create product descriptions with Microsoft Copilot

João Barros 17 de July de 2026 5 min read

Learn how to create product descriptions with Microsoft Copilot and generate metadata and keywords directly in a SharePoint list. This technique speeds up publishing product pages, improves internal search and standardizes the tone of descriptions. In practical tests, teams reduced creation time per page from 12–20 minutes to 3–5 minutes and increased tone consistency by about 80–90%.

Prerequisites

Microsoft 365 account with Microsoft Copilot available.
Edit permissions on a SharePoint list.
SharePoint list with basic columns (Title, Price, Category).
Modern browser (Edge/Chrome) and product data ready.

Step 1: Prepare the list to create product descriptions

Create or adapt your SharePoint List with columns where Copilot will write descriptions and metadata. Use appropriate types: single-line text for titles, multi-line text for long descriptions, and choose choice or text columns for tags and keywords. Thinking about the structure before starting is important: a good list enables automating views, filters and approval flows.

Colunas sugeridas:
- Title (Single line of text)
- ShortDescription (Multiple lines of text)
- LongDescription (Multiple lines of text)
- SEOKeywords (Single line of text ou Multiple lines)
- Tags (Choice ou Single line)
- Status (Choice: Draft, Review, Published)

Practical example: if you have 1,000 products, consider additional columns like ModelNumber and Manufacturer to improve automatic keywords. Define Content Type and metadata templates if you want to apply rules to groups of products.

Step 2: Open Microsoft Copilot in the item context

Open the list in SharePoint and select an item (or create a new one). Click the Copilot icon in the top-right corner of the site page or in the item panel to open the Copilot window contextual to the selected item. The reason to use context: Copilot can read the fields already filled and generate text aligned with the actual data — this reduces errors and duplication.

Step 3: Ask Copilot to generate a short description

Request a short description (ideal for views and cards). Be clear about the tone (formal, sales, technical) and the character limit. Use a prompt with product data. An effective ShortDescription usually has 80–120 characters — visible in cards and quick filters.

Exemplo de prompt para ShortDescription:
Cria uma ShortDescription de até 120 caracteres para este produto.
Title: {Title}
Category: {Category}
Principais características: {KeyFeatures}
Tom: amigável e orientado para venda.

Exemplo de saída (modelo): SmartWidget 3000 — compacto, rápido e eficiente; ideal para escritórios e teletrabalho.

Step 4: Generate the LongDescription with attributes and benefits

For the LongDescription ask for more detail: use bullet points, include benefits and usage instructions if applicable. Also indicate words to avoid and whether you want mention of warranties or certifications. A typical LongDescription for e-commerce ranges between 150 and 300 words; enough for SEO and to answer common customer questions.

Exemplo de prompt para LongDescription:
Gera uma LongDescription de 150–300 palavras para ficha de produto.
Inclui: 3 bullets de características técnicas, 2 bullets de benefícios, sugestão de utilização rápida.
Não mencionar preço. Tom: profissional e claro.
Dados do produto:
- Title: {Title}
- Category: {Category}
- Specs: {Specs}

Exemplo de saída (modelo breve):
SmartWidget 3000 é um dispositivo compacto com processador X, memória Y e bateria Z. Características:
- Processador X de 2.4 GHz
- Memória Y de 8 GB
- Autonomia até 10 horas
Benefícios:
- Desempenho para multitasking
- Portabilidade para profissionais em movimento
Sugestão de utilização: ideal para apresentações e reuniões remotas.

Step 5: Generate SEOKeywords and relevant Tags

Ask Copilot to extract SEO keywords and tags from the description and specs. Request several options (short and long tail) to choose from. It is recommended to generate 6–10 keywords per product, combining short-tail and long-tail to capture different search intents.

Exemplo de prompt para SEOKeywords e Tags:
A partir da LongDescription e Specs, gera 8 SEO keywords separadas por vírgula (mistura short e long-tail) e 4 tags de categoria.
Resposta: Keywords: ...\nTags: ...

Exemplo de resposta: Keywords: SmartWidget, dispositivo portátil, processador X, SmartWidget 3000 review, bateria 10 horas, portátil para teletrabalho, gadget escritório, smart tools
Tags: Gadgets, Escritório, Portátil, Teletrabalho

Step 6: Apply to multiple items (batch workflow)

For multiple pages, copy the essential fields into a single bulk prompt: list Title/Category/Specs of multiple products and ask Copilot to generate a ShortDescription and SEOKeywords for each line. With a well-structured prompt it is possible to process 20–50 items per session; for 200 products, estimate 2–3 hours including review.

Exemplo de prompt em lote:
Para cada linha abaixo, gera ShortDescription (<=120 chars) e SEOKeywords (até 6 keywords).
1) Title: X1 | Category: C1 | Specs: ...
2) Title: X2 | Category: C2 | Specs: ...
Resposta formatada: 1) ShortDescription: ... | Keywords: ...\n2) ShortDescription: ... | Keywords: ...

Step 7: Review, adjust and publish

Always review the generated content: verify factual accuracy (specs/certifications), brand compliance and language errors. Use the Status field to control review before publishing. A recommended process: 1) automatic creation, 2) human review (2 minutes per page) and 3) publication. Measure quality with samples: if 9 out of 10 pages need fewer than two edits, the prompt is good.

Verify the result

Confirm that the ShortDescription, LongDescription and SEOKeywords columns are filled for each item. Test internal search for one of the generated keywords and verify the page appears. For example, search for a long-tail keyword and confirm that at least 90% of relevant pages appear in the top 10 results. Also validate in different SharePoint views (list, gallery, item detail) to ensure readability.

Conclusion

Using Microsoft Copilot to create product descriptions in SharePoint saves time and standardizes communication. Next steps: create a reusable base prompt for your brand, integrate human review into the process and measure the impact on internal search. Practical tip: start by generating descriptions for 10 products, record time and edit rate, and refine the prompt until edits are reduced to less than 20% of pages.