Hi XM Community,
I wanted to share a free tool I created to help with Text IQ topic model documentation. Auditing and sharing topic configurations keeps coming up, especially when handing off to stakeholders or comparing models across programs, so hopefully this saves some of you time.
The Challenge: The Text IQ JSON export is powerful, but it's not easy to review outside of Qualtrics. When you need to audit topic coverage, verify query logic, or document your model for compliance or handover, opening a raw JSON file isn't practical, especially for stakeholders who live in Excel.
The Solution: A browser-based tool that converts your Text IQ JSON export into a structured Excel workbook in seconds:
✓ Full topic hierarchy with parent/child relationships visualised
✓ Query logic captured for every topic (OR, AND, NOT, PROXIMITY, EXACT)
✓ Topics missing queries identified at a glance
✓ Flat topic list for filtering, sorting, and gap analysis
✓ Summary statistics: total topics, root categories, hierarchy depth, query coverage
Full guide and tool: https://piraiai.com/textiq-to-excel
Key Features:
- Runs entirely in your browser (your data never leaves your machine)
- GDPR & HIPAA friendly, zero server storage
- Works with any Qualtrics licence type
- No login required, completely free
Use Cases:
- Audit topic model completeness before go-live
- Document query logic for compliance or handover
- Compare topic coverage across programs or survey versions
- Share model structure with stakeholders outside Qualtrics
- Troubleshoot gaps in Text IQ classification
Excel Sheets Generated:
- Topic Overview: summary stats and metadata
- Topic Hierarchy: visual indented tree (up to 5 levels)
- Flat Topic List: Topic ID, Label, Level, Parent, Query, Root Category
- Query Analysis: operators used, complexity score, query type per topic
How to export your Text IQ JSON: In your Text IQ topic model, click the menu, select Export Topics, save the JSON file, then drop it into the tool.
Hope this helps! Happy to answer any questions about how it works.
