{"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-06-07T15:10:41.586Z"},"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 a real-time webhook system for automated pipelines. 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 API and webhooks — 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. Navigate to the **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, JSON export pairs well with webhooks to create real-time pipelines: configure a webhook on `interview.completed` to receive each new interview's full analysis as it happens.\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 and navigate to the **Recruit** tab\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. Koji's Insights Chat feature — which lets you ask any question about your data — is a better option for sensitive research since it keeps data within the Koji platform.\n\n---\n\n## Export Format 4: API and Webhooks for Real-Time Pipelines\n\n**Best for:** Automated research operations, CRM enrichment, Slack and Notion notifications\n\nFor teams that want research data flowing automatically into other systems, Koji's API and webhook system enables real-time pipelines that require no manual export steps.\n\n### Webhook events\n\nConfigure webhooks to receive automatic notifications when:\n\n- `interview.completed` — a participant finishes an interview (includes full analysis)\n- `interview.started` — a participant begins an interview\n- `study.published` — your study goes live\n\nWith the `interview.completed` webhook, 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 in the Recruit tab 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**: use the `interview.completed` webhook to post Slack summaries in real time, 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) — build real-time research pipelines that push data automatically\n- [Headless API Overview](/docs/headless-api-overview) — programmatic interview management and data access\n- [Managing Research Participants](/docs/managing-research-participants) — the Recruit tab 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-05-14T03:18:53.717222+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 real-time webhook pipelines 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 a real-time webhook system for automated pipelines. 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 real-time pipelines using webhooks and the API","Understand when to use each export format"],"aiDifficulty":"intermediate","aiEstimatedTime":"8 min read"}],"pagination":{"total":1,"returned":1,"offset":0}}