LLM QualAnalyzer
A free, open-source Chrome extension that brings LLM-powered qualitative coding into Google Sheets, built for academic researchers.
What it does
LLM QualAnalyzer lets researchers apply large language models to qualitative data — interview transcripts, open-ended survey responses, field notes — without leaving their existing workflow. You write your coding prompt once, point the extension at a Google Sheet of data, and it codes each row using the LLM provider of your choice.
It is designed for the realities of academic qualitative work: reproducibility, transparent prompts, full control over which model is used, and no third-party servers handling your data.
How it works
- Sign in with your Google account so the extension can read your Docs and read/write your Sheets.
- Provide your own API key for OpenAI, Anthropic, OpenRouter, or run a local model through Ollama.
- Define your coding prompt and pick the column of data to analyze.
- Run the job. Results are written back to your Google Sheet, alongside the original data.
Privacy
The extension does not send your data to any server operated by us. We have no servers. Your prompts, results, and API keys stay in your browser and your own Google Workspace. LLM requests go directly from your browser to the provider you configured.
Read the full privacy policy.
Open source
The complete source code is published at github.com/maxlvhao/llm_qual_analyzer. Issues and pull requests are welcome.
Contact
Questions, bug reports, or feature requests: maxlvhao@gmail.com or open an issue on GitHub.