The Scenario
Your editor-in-chief dropped a workbook in shared drive at 8 AM with a note: "CMS migration Monday, editorial routing has to be done by end of Friday." You're a news wire editor and the workbook has 300 article summaries in column B of the 'Articles' sheet — wire copy from the past month. The CMS auto-routes articles to editorial desks based on IPTC media topic codes, and right now none of these articles have them.
The bad version:
- Look up the IPTC NewsCodes taxonomy to understand the two-level hierarchy of subject codes and labels.
- Open the TextRazor API documentation to find the correct classifier name for IPTC media topics and figure out what the response structure looks like.
- Copy the first summary, paste it into an API call, read through the response to find the topic array, note the label and score, enter them into columns C and D by hand.
- Do that 299 more times before Friday.
The migration doesn't move without the codes. Three hundred rows by hand means Thursday night. Except you also have a 4 PM editorial meeting, a corrections backlog from Tuesday, and a reporter waiting on a callback.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your article summaries, understands the column structure, and through its built-in TextRazor integration can classify every row using the IPTC media topics taxonomy and write labels and scores back in one run.
For each row in the 'Articles' sheet, classify the text in column B using IPTC media topics and write the primary topic code and label into columns C and D.
What You Get
- Column C receives the primary IPTC topic label for each summary — e.g., "Politics and Government" or "Natural Resources."
- Column D receives the confidence score for that label.
- Rows that return no confident IPTC match get a flagged value in column C rather than a blank that breaks the CMS import.
- All 300 rows process in a consistent format, ready to import directly into the CMS routing field.
What If the Data Is Not Quite Ready
Some summaries are very short — 20 words or less
For each row in the 'Articles' sheet, if the text in column B is under 25 words, combine it with the title in column A before sending to TextRazor IPTC classification. Write the primary topic label and score into columns C and D.
The CMS expects the numeric IPTC code, not the label
Classify each summary in column B of the 'Articles' sheet using TextRazor's IPTC media topics taxonomy, write the primary topic label into column C and the numeric IPTC code into column D.
Articles span multiple IPTC categories and you need all of them above a threshold
For each row in the 'Articles' sheet, classify the text in column B using IPTC media topics and write all topic labels with a confidence score above 0.5 as a comma-separated list into column C, and their corresponding scores into column D.
Full kill chain: deduplicate, classify, validate
Remove duplicate article summaries from column B of the 'Articles' sheet (keep the first occurrence), classify the remaining rows with TextRazor IPTC media topics, write the top two topic labels and scores into columns C through F, and add a 'Topic Distribution' sheet showing each unique topic label, how many articles it covers, and the average confidence score — sorted by article count descending.
The distribution summary is what matters for validating the routing logic — getting it in one prompt means you're not building it manually after the fact.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your article summaries waiting for IPTC codes. Ask SheetXAI to classify every row and write the topic labels and scores into the columns your CMS import is expecting. If the CMS also needs IAB categories for the same articles, the IAB classification spoke covers that workflow.