The Scenario
You are a content architect at an e-commerce company. The taxonomy team has just finished a six-week classification project: 200 product category terms, each with a label, a definition, and a parent concept. The terms are in an Excel workbook—column A has the label, column B has the definition, column C has the parent concept name.
All 200 terms need to be added to Contentful's organization taxonomy before the catalog relaunch next Tuesday.
The bad version of this week:
- You open Contentful, navigate to Organization > Taxonomy
- You click "Add concept," type the label, type the definition, scroll down to find the parent concept, click Save
- You repeat for 200 terms
- Around term sixty you mistype a definition and do not notice until QA flags it two days later
- Some parent concept names in the workbook do not exactly match the concept names in Contentful
- The catalog relaunch is delayed while someone manually fixes 30 misplaced concepts.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the taxonomy tab and calls Contentful's taxonomy API for each row.
Open the SheetXAI sidebar and type:
Create a Contentful taxonomy concept for each row in this workbook. Use the term label from column A, the definition from column B, and the parent concept from column C. Add each concept to the concept scheme called Product Categories.
SheetXAI reads all 200 rows, creates a concept for each one, and links it to the correct parent in the Product Categories scheme.
What You Get
200 Contentful taxonomy concepts created, organized under the right scheme:
- Labels — from column A, exactly as written
- Definitions — from column B, no retyping
- Parent linkage — each concept placed under the correct parent in the scheme
- Concept IDs — ask SheetXAI to write each new concept ID back to column D for an audit trail
Parent concept matching is handled by SheetXAI, not by you.
What If the Data Is Not Quite Ready
Taxonomy workbooks assembled over six weeks tend to accumulate inconsistencies.
When parent concept names are inconsistent
Column C has "Electronics," "Consumer Electronics," and "Electronics / CE" all pointing to the same parent.
Normalize the parent concept names in column C to the canonical names in the Contentful taxonomy. Map "Consumer Electronics" and "Electronics / CE" to "Electronics." Then create each concept under the correct parent.
When some terms are missing definitions
About thirty rows have a blank column B.
For rows where column B is blank, write a one-sentence definition based on the label in column A. Then create the Contentful taxonomy concept for each row using the label, the generated or existing definition, and the parent from column C.
When you only want to add concepts for a specific parent branch
Filter to rows where column C is "Home & Garden" or a child of that concept. Create Contentful taxonomy concepts only for those rows.
When the workbook has duplicate labels
Deduplicate rows by the label in column A, keeping the first occurrence. Then create a Contentful taxonomy concept for each unique row using the label, definition, and parent concept from columns A, B, and C. Write the new concept ID to column D.
The pattern: taxonomy cleanup and concept creation happen in the same prompt.
Try It
Get the 7-day free trial of SheetXAI and open any taxonomy planning workbook, then ask it to create the concepts in Contentful. The Contentful integration is included in every SheetXAI plan. For related workflows, see how to bulk-create content entries or the Contentful in Excel overview.