The Scenario
You're the community manager at a gaming company. Every Monday morning you open the workbook with the past week's user forum posts — around 400 rows in the 'Posts' worksheet — and you're supposed to have it cleaned up and analyzed before the 10 AM product sync. Sentiment, topics, abuse flags, named entities. Four columns of output that didn't exist when you opened the file.
The bad version:
- Export the worksheet to CSV, find the Python script from six months ago that may or may not still work with the current Tisane API version, run it row by row, watch it crash on row 212 because one post is in Japanese and the script only handles English
- Copy the JSON output back into the workbook manually, figure out which nested field maps to which column, realize you pasted entities into the topics column
- Hit the API rate limit at row 300, wait, re-run from there, reconcile the two partial outputs
The product sync is in 45 minutes. You're supposed to be surfacing insights in that meeting, not debugging a pipeline you inherited from a contractor who left eight months ago.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the data and talks to Tisane for you — no script, no JSON parsing, no column mapping by hand.
For each row in my Excel sheet, run Tisane text analysis on the 'Review' column and populate 'Sentiment', 'Topics', 'Abuse Type', and 'Language' columns — leave blank if no value detected
What You Get
- 'Sentiment' column: label per row (positive, negative, neutral) from Tisane's analysis
- 'Topics' column: comma-separated topic tags extracted from the post content
- 'Abuse Type' column: abuse flag if Tisane detected hate speech, profanity, or cyberbullying — blank if clean
- 'Language' column: ISO language code detected by Tisane for each post
- Rows where Tisane finds nothing to report in a given category get a blank cell, not an error
What If the Data Is Not Quite Ready
The posts worksheet has mixed HTML and plain text in the content column
Some posts still have <br> tags and anchor elements from the CMS export.
Before running Tisane analysis on the 'Post Text' column, strip any HTML markup from each cell, then analyze the cleaned text and write sentiment, topics, abuse type, and language into their respective columns
Some rows are empty or contain only whitespace
Analyze the text in the 'Post Text' column with Tisane for sentiment, topics, abuse, and entities — skip any row where the column is blank or contains only spaces — write results into the output columns
Posts are split across two worksheets: 'This Week' and 'Last Week'
Pull all posts from the 'Post Text' column on both the 'This Week' and 'Last Week' worksheets, run Tisane analysis on each, and write sentiment, topics, abuse type, and language back into the respective columns on each worksheet
Full pipeline: clean, analyze, and flag high-severity rows in one shot
Strip HTML from the 'Post Text' column, run Tisane analysis on each cleaned post, write sentiment, topics, abuse type, and entities into their columns, then highlight any row where 'Abuse Type' contains 'hate speech' or 'cyberbullying' in red
One prompt carries the cleanup and the analysis together.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a worksheet of user-generated text, then ask it to run Tisane analysis across the whole column. For a different NLP task, see how to detect language per row or classify content by abuse type. The full list of Tisane workflows is in the hub overview.