{"site":{"name":"Koji","description":"AI-native customer research platform that helps teams conduct, analyze, and synthesize customer interviews at scale.","url":"https://www.koji.so","contentTypes":["blog","documentation"],"lastUpdated":"2026-09-22T11:00:24.861Z"},"content":[{"type":"documentation","id":"927f196c-87de-44e4-b7c3-09d5fa70828a","slug":"exporting-research-data","title":"Exporting Research Data from Koji: CSV, JSON, and Transcript Access","url":"https://www.koji.so/docs/exporting-research-data","summary":"Koji provides four data export formats: one-click CSV for spreadsheet analysis and CRM uploads, JSON API for full structured analysis including transcripts and confidence scores, in-app transcript viewer with copy support, and the REST API for automated pipelines (poll the read endpoint or use the embed events; outbound webhooks are not available yet). All exports include AI-generated summaries, quality scores, and theme tags. Structured question responses appear as dedicated columns. No credits are consumed by exports.","content":"## Exporting Research Data from Koji: CSV, JSON, and Transcript Access\n\n**The short answer:** Koji gives you complete ownership of your research data. Export participant data and AI-generated summaries as CSV, download raw structured analysis as JSON, access individual transcripts, and pipe data to external systems via the API, all with a few clicks or a single API call.\n\nYour research data is valuable. The insights you collect through Koji interviews should not live only inside a platform — they need to flow into your product roadmaps, CRM systems, research repositories, stakeholder reports, and analytics pipelines. That is why Koji is built for data portability from the ground up.\n\nThis guide covers every way to get your data out of Koji, when to use each format, and how to build automated pipelines that keep your research connected to the rest of your stack.\n\n---\n\n## Why Data Export Matters in Modern Research\n\nResearch that lives in a silo does not drive decisions. The most effective research teams connect their interview data to:\n\n- **Product roadmaps** — tagging insights to features and epics\n- **CRM systems** — enriching customer profiles with interview notes\n- **Research repositories** — building a searchable archive of findings\n- **BI tools** — creating dashboards that track sentiment and themes over time\n- **Stakeholder reports** — presenting findings in formats teams can consume\n\nWith tools like Koji, all of this is possible without manual copy-pasting. Koji is designed so that data flows to wherever it is needed, in the format that each system requires.\n\n---\n\n## Export Format 1: CSV\n\n**Best for:** Spreadsheet analysis, CRM uploads, research operations reporting\n\nCSV export gives you a flat-file view of your participant data, ideal for quick analysis in Excel, Google Sheets, or Airtable, and for uploading to CRM systems or research repositories.\n\n### What is included in the CSV\n\nWhen you export a study to CSV, Koji includes:\n\n- **Participant metadata**: display name, email (if collected via lead form), source (organic, custom link, CSV import), started and completed timestamps\n- **Session data**: session duration in seconds, message count, interaction mode (voice or text)\n- **AI summary per participant**: the goal-aligned summary of what that participant said\n- **Quality score**: the 1–5 quality score assigned by Koji's analysis engine\n- **Theme tags**: AI-generated tags identifying the main topics discussed\n- **Intake form data**: any fields collected via your lead collection form (name, company, role, etc.)\n- **Structured question responses**: for studies using [structured questions](/docs/structured-questions-guide), each question gets its own column with the participant's response\n\n### How to export CSV\n\n1. Open your study in Koji\n2. Open the **Interviews** page and its **Self-recruit** tab\n3. Click the **Export** button in the top-right corner\n4. Select **CSV** as your format\n5. Click **Download**\n\nThe file downloads immediately — no waiting, no email link. For large studies (100+ participants), export typically completes within a few seconds.\n\n### Tips for CSV export\n\n- **Filter before exporting**: use the quality score filter to export only high-quality interviews (score 3+) before downloading\n- **Re-run analysis first**: if you recently refreshed your report, re-export CSV to get updated theme tags and summaries\n- **Structured question columns**: studies using structured questions (scale, single_choice, yes_no, etc.) will have quantitative columns that are ideal for pivot tables and distribution analysis\n\n---\n\n## Export Format 2: JSON\n\n**Best for:** Developer workflows, research repositories, custom analysis pipelines, AI tools\n\nJSON export provides the full structured analysis for each participant interview — the same data Koji uses internally to generate reports. It is richer than CSV and includes nested data that does not flatten well into rows and columns.\n\n### What is included in the JSON export\n\nEach participant entry in the JSON export includes:\n\n- All CSV fields (metadata, session data, summary, scores)\n- **Full question-answer mapping**: each key question from your research brief paired with the extracted answer and confidence level\n- **Structured answers**: for structured questions, the full StructuredAnswer object including quantitative value, qualitative answer, follow-up insights, and confidence\n- **Pain points, feature requests, and positive highlights** extracted by the AI\n- **Notable quotes**: direct quotes from the transcript worth highlighting\n- **Topic insights map**: for each topic in your research brief, what the participant said\n- **Evaluation**: whether the participant answered key questions, stayed on topic, and provided depth\n- **Full transcript**: all messages in the conversation, including AI follow-up questions\n\n### How to export JSON\n\nJSON export is available through the Koji API:\n\n```\nGET /api/v1/projects/{project_id}/export?format=json\n```\n\nInclude your API key in the `Authorization: Bearer {api_key}` header. The response is a JSON array of participant analysis objects. See the [API Authentication guide](/docs/api-authentication) for how to generate and manage API keys.\n\nFor programmatic access, pair the JSON export with a server job that polls the read endpoint, or with the embed widget's browser events (`koji:interview_completed`), to keep a pipeline current. Outbound webhooks are not available yet.\n\n---\n\n## Export Format 3: Transcript Access\n\n**Best for:** Qualitative analysis, research repositories, compliance, stakeholder deep-dives\n\nIndividual transcripts let you read the full conversation between Koji's AI interviewer and each participant. Transcripts are accessible directly in the Koji interface and can be copied for use in analysis tools.\n\n### Accessing transcripts in Koji\n\n1. Open your study's **Interviews** page\n2. Click on any participant row to open the **Analysis Drawer**\n3. Click the **Transcript** tab to view the full conversation\n4. Use the copy button to copy the entire transcript to your clipboard\n\nTranscripts show both the AI's questions and follow-up probes alongside the participant's responses. This gives context that summary data cannot fully capture — tone, hesitation, unexpected tangents, and specific language patterns.\n\n### Using transcripts with AI tools\n\nMany research teams paste transcripts into AI assistants for custom analysis. Koji's transcripts are clean, well-formatted, and export-ready. Note that if your research involves personal data, review your privacy policy before sharing transcripts with third-party AI services. If you use Claude or another MCP assistant, the [Koji connector](/docs/mcp-overview) reads transcripts and study data directly, so nothing has to be copied and pasted; inside Koji, every claim in the report links to the quote behind it.\n\n---\n\n## Export Format 4: API Polling and Embed Events for Automated Pipelines\n\n**Best for:** Automated research operations, CRM enrichment, keeping your own tools in sync\n\nFor teams that want research data flowing automatically into other systems, Koji's REST API enables pipelines that require no manual export steps: a server job polls the read endpoint for new interviews, and the embed widget emits browser events you can act on.\n\n### Polling and embed events\n\nOutbound webhooks are not available yet. Two mechanisms cover the same jobs:\n\n- **Poll the read endpoint** from a server job (or from Zapier, n8n or Make) to pick up each interview's full analysis once it completes\n- **Embed events**: the embed widget emits browser postMessage events (`koji:ready`, `koji:interview_started`, `koji:interview_completed`) that your own product can react to\n\nWith a polling job in place, you can automatically:\n\n- Create a Notion or Confluence page for each new interview\n- Post a Slack summary to your research channel\n- Update a CRM record with the participant's key insights\n- Trigger analysis in a custom data pipeline\n- Archive transcripts to a research repository\n\n### Headless API for embedded research\n\nIf you have embedded Koji interviews in your product using the Headless API, all data is available through the same export mechanisms. Participants from embedded interviews appear on the Interviews page and are included in all exports.\n\nFor more on API-driven exports, see the [Headless API Overview](/docs/headless-api-overview) and [Webhook Setup](/docs/webhook-setup) guides.\n\n---\n\n## A Complete Research Ops Export Workflow\n\nHere is a common workflow for research teams that need both speed and depth:\n\n1. **During fieldwork**: pin the public report link in Slack, or have a job poll the API and post summaries, keeping your team informed as responses come in\n2. **After fieldwork**: export CSV to review participant-level quality scores and filter out low-quality sessions\n3. **For synthesis**: export JSON or access individual transcripts for deep analysis in your research repository\n4. **For reporting**: use Koji's built-in reports (with optional publishing) for stakeholder distribution — no export needed\n\nThis layered approach means you always have the right level of data for each use case, without drowning in raw data you do not need.\n\n---\n\n## Data Ownership and Privacy\n\nKoji does not sell or share your research data. All interview data, transcripts, and AI analysis belong to your account. You can delete studies and all associated data at any time.\n\nFor enterprise teams with specific data residency or retention requirements, contact the Koji team to discuss enterprise data handling options.\n\n---\n\n## Related Resources\n\n- [Structured Questions Guide](/docs/structured-questions-guide) — add quantitative columns to your exports with scale, choice, and ranking questions\n- [Webhook Setup](/docs/webhook-setup) — keep pipelines current with API polling and embed events\n- [Headless API Overview](/docs/headless-api-overview) — programmatic interview management and data access\n- [Managing Research Participants](/docs/managing-research-participants) — the Interviews page in depth\n- [Research Automation: How to Build Real-Time Research Pipelines](/docs/research-automation-webhooks) — end-to-end automation workflows\n- [Generating Research Reports](/docs/generating-research-reports) — Koji's built-in report system for stakeholder sharing\n\n\n## Further reading on the blog\n\n- [Agile User Research: How to Run Continuous Research in Sprint Cycles (2026)](/blog/agile-user-research-2026) — Most teams know they should do user research every sprint. Almost none actually do. Here's the practical playbook for integrating continuous\n- [AI Agents for User Research in 2026: How Autonomous Research Is Reshaping Customer Insight](/blog/ai-agents-user-research-2026) — AI agents are taking over user research in 2026 — moderating interviews, synthesizing themes, and producing insight reports in hours. The fu\n- [Best AI Market Research Tools in 2026: The Complete Buyer's Guide](/blog/ai-market-research-tools-2026) — AI has fundamentally changed market research. This guide compares the leading AI market research platforms—from AI-native interview tools li\n\n<!-- further-reading:blog -->\n","category":"Reports & Analysis","lastModified":"2026-09-20T18:39:40.876307+00:00","metaTitle":"Exporting Research Data from Koji: CSV, JSON, and Transcript Access","metaDescription":"Learn every way to export your interview data from Koji — CSV downloads, JSON API, transcript access, and API polling for automated research operations.","keywords":["export user research data","research data export","download interview transcripts","CSV export user research","JSON export qualitative data","research data portability"],"aiSummary":"Koji provides four data export formats: one-click CSV for spreadsheet analysis and CRM uploads, JSON API for full structured analysis including transcripts and confidence scores, in-app transcript viewer with copy support, and the REST API for automated pipelines (poll the read endpoint or use the embed events; outbound webhooks are not available yet). All exports include AI-generated summaries, quality scores, and theme tags. Structured question responses appear as dedicated columns. No credits are consumed by exports.","aiPrerequisites":["understanding-the-research-brief","creating-your-first-study"],"aiLearningOutcomes":["Export participant data as CSV with AI summaries and quality scores","Access the full structured JSON analysis via API","Read and copy individual interview transcripts","Build automated pipelines by polling the API and using embed events","Understand when to use each export format"],"aiDifficulty":"intermediate","aiEstimatedTime":"8 min read"}],"pagination":{"total":1,"returned":1,"offset":0}}