Upload an existing codebook, reuse one from another project, or export your topic collection.
In Caplena, your codebook is called a topic collection: the categories, topics, codes, and descriptions used to analyze a text column. You might also know it as a code frame, code plan, or coding scheme.This page covers the three ways to move a codebook in and out of Caplena:
I want to…
Use
Where
Use a codebook I already have in a file
Upload File
When starting the analysis
Reuse a codebook from another Caplena project
Import from another project
When starting the analysis, or from the Topics tab
Get my codebook out of Caplena
Topic summary export
Export dialog in the Topics view
Import a codebook from a file
If you already have a list of codes, for example from a previous study or a client’s coding scheme, you can upload it instead of letting the AI generate topics from scratch.
1
Prepare your file
Put your codebook in a CSV or Excel file, one topic per row, using the column names below. A plain text list can’t be imported directly. Paste it into Excel first, with one topic per row in a topic column.
2
Start the analysis
Open your project and click Start analysis now on the Overview panel.
3
Choose Import existing topics
Choose how to start, select Import existing topics, then Upload File, and upload your file.
File format
Column
Required
What it’s for
topic
Yes
The topic name (label).
category
Yes
The category the topic belongs to.
code
No
A unique numerical ID for the topic. Use this to keep your existing code numbers. If you leave it out, Caplena assigns codes automatically.
sentiment
No
The sentiment setting for the topic.
description
No
When the topic should apply. The AI uses this as a primary input when assigning topics.
keywords
No
Comma-separated keywords, used in Semi-Open mode to match responses. Each keyword must be 30 characters or fewer, including spaces.
Your file must match one of these two layouts.
With sentiment
Without sentiment
With descriptions
Add descriptions if you can. A topic like Pricing is assigned much more reliably with a description such as “Mentions of cost, price, fees, or value for money, including comments about discounts and subscription tiers.” If the column is empty, Caplena generates descriptions on the first run, but your own keep assignments aligned with how your team defines each topic.
Imports with a keyword longer than 30 characters are rejected with an error. Shorten or split long keywords before uploading.
You can upload an exported codebook as-is. A Topic summary export from another project can be uploaded directly, with no renaming or cleanup needed. Caplena matches the columns it needs and ignores the rest, such as colors and answer counts. This is an easy way to reuse a codebook across projects or accounts, or to edit it in Excel and bring it back.
Reuse a codebook from another Caplena project
Running the same survey again? For recurring studies, such as quarterly NPS, yearly employee surveys, or a new wave of the same questionnaire, you usually don’t need a second project. Keep everything in one project: append the new rows and add a wave or year column to tell the waves apart. The new responses are coded with the same codebook, and you can compare waves directly in your reports.
Reusing a codebook across projects makes sense when the projects really need to be separate, for example a different study that should use the same coding scheme, or a DEV/PROD tracker setup. There is a way to do it.
1
Start the analysis
In the project that needs the codebook, click Start analysis now.
2
Choose Other project
Select Import existing topics, then Other project.
3
Select the source
Choose the project and the text column whose codebook you want, then click Inherit topic collection.
Inheriting topics with the LLM model works best when the new dataset asks the same question in the same context. If the question wording or column context differs, review the inherited descriptions before running the AI. See Learning Relationships Between Projects for details.
Export your codebook
Topic summary (download your codebook)
The Topic summary export is how you download your codebook. The export also includes a category overview with the number and share of answers per category. An answer with several topics in the same category is counted once.
For topics with sentiment enabled, each sentiment variant (neutral, negative, positive) is a separate row with its own code. For example, AI Topic Detection might appear as codes 1 (neutral), 2 (negative), and 3 (positive). Keep this in mind when matching codes in SPSS or another tabulation tool.
1
Open the export dialog
Go to the Topics view and click Export (top right).
2
Choose Topic summary
Click the Topic summary tab and choose a file type, for example Excel.
3
Export
Click Export.
The Topic summary is exported per topic collection, so one text column at a time. If your project has several text columns, export the summary for each one.
Common questions
How do I download my codebook?
Go to the Topics view, click Export, open the Topic summary tab, and export to Excel or CSV. You’ll get every topic with its code, category, sentiment, description, and keywords. See Topic summary.
Can I edit my codebook in Excel and upload it again?
Yes. Export the Topic summary, make your changes in Excel, and upload the file through Import existing topics → Upload File. You don’t need to rename or remove columns. Caplena picks up the ones it needs.
Can I keep my existing code numbers?
Yes. Include a code column in your upload file. You can also set codes manually on each topic. See Code.
I have my codes as a plain text list. Can I paste them in?
Not directly. Paste the list into Excel with one topic per row under a topic header, add category or other columns if you have them, and upload the file.
I want the same codebook for two waves of the same survey
The simplest setup is one project for all waves. Append the new wave’s rows to the existing project and add a wave or year column to tell them apart, so every wave uses the same codebook and you can compare them in one report. See Append Rows to an Existing Project and Creating a Helper Column.
Can I import a codebook into a project that's already been analyzed?
Yes, but importing a new codebook restarts the analysis, and topics are assigned again from scratch. Before you import, export the current Topic summary so you have a copy of the existing codebook to go back to.
I want to test changes to my codebook without losing the current version
Use a separate test project and copy the codebook there, then copy it back once you’re happy. See Tracker Setup: Best Practices.
Related pages
Starting the analysis
All the ways to create your first topic collection.
Key concepts
Categories, topics, codes, and sentiment explained.
Tracker Setup: Best Practices
Manage recurring studies with a DEV and PROD project.
Exporting Your Data
All export formats for coded data.
Last modified on October 12, 2026
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Caplena Documentation","description":"Caplena is your intelligence layer for\ncustomer feedback\nGet full control over how open ends become deep insights. Command powerful text analysis, flexible enrichment, and agentic capabilities so every team can act on the Voice of Customer.","colors":{"primary":"#191919","light":"#cff3ff","dark":"#191919"},"logo":{"light":"https://mintcdn.com/caplena-32172960/QDllrFkrr8IVUaqz/logo/light.svg?fit=max\u0026auto=format\u0026n=QDllrFkrr8IVUaqz\u0026q=85\u0026s=4fa4c95df2a6b3ed361772ae422145d4","dark":"https://mintcdn.com/caplena-32172960/QDllrFkrr8IVUaqz/logo/dark.svg?fit=max\u0026auto=format\u0026n=QDllrFkrr8IVUaqz\u0026q=85\u0026s=70434179c7c4b0ed736edf91212fce68","href":"https://caplena.com/en"},"favicon":"https://mintcdn.com/caplena-32172960/f4FlmiD764B78gVE/favicon.png?fit=max\u0026auto=format\u0026n=f4FlmiD764B78gVE\u0026q=85\u0026s=ab734ecca6877a72f2d1e66dd161dce7","appearance":{"default":"light"},"navbar":{"links":[{"href":"https://app.caplena.com/","label":"Log in"}],"primary":{"type":"button","label":"Contact us","href":"mailto:support@caplena.com"}},"footer":{"socials":{"linkedin":"https://www.linkedin.com/company/linkedin","youtube":"https://www.youtube.com/@caplena"}},"seo":{"metatags":{"robots":"all"}},"fonts":{"heading":{"family":"Wasa","source":"https://caplena.com/fonts/wasa-700.woff2","format":"woff2"}},"contextual":{"options":["copy","view","chatgpt","claude","perplexity","mcp","cursor","vscode"],"display":"header"},"metadata":{"timestamp":true},"styling":{"latex":false},"navigation":{"global":{"anchors":[{"anchor":"Blog","icon":"newspaper","href":"https://caplena.com/en/blog"}]},"languages":[{"language":"en","href":""}]}},"deployment":{"deploymentMetadataValue":{"subdomain":"caplena-32172960","hasAudioNarration":false,"actualSubdomain":"caplena-32172960","customDomains":["docs.caplena.com"],"gitSource":{"type":"github","owner":"caplena","repo":"docs","deployBranch":"main","isPrivate":true,"contentDirectory":"","mountPath":"","label":""},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"REMOVE_BRANDING":{"status":"DISABLED"},"CONTEXTUAL_FEEDBACK":{"status":"DISABLED"},"CODE_SNIPPET_FEEDBACK":{"status":"DISABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6afaec4d3f5f5eede31d2f6b","clientVersion":"0.0.4160","searchFilterCounts":[{"language":"en","tag":"Insight \u0026 Reports","count":26},{"language":"en","tag":"Data Management","count":15},{"language":"en","tag":"Topic Analysis","count":13},{"language":"en","tag":"Insight Elements","count":11},{"language":"en","tag":"Get Started","count":10},{"language":"en","tag":"Reports","count":9},{"language":"en","tag":"Settings \u0026 Administration","count":9},{"language":"en","tag":"Smart Columns","count":8},{"language":"en","tag":"Integrations","count":8},{"language":"en","tag":"General Settings","count":5}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":"#navbar,#navbar-transition{background:#D0F4FF!important;backdrop-filter:none!important}.dark #navbar,.dark #navbar-transition{background:#020617!important}#table-of-contents-layout{border-left:1px solid rgba(0, 0, 0, 0.08)}.dark #table-of-contents-layout{border-left-color:rgba(255, 255, 255, 0.1)}"}],"page":{"pagePath":"topic-assignment/understanding-the-basics/import-copy-export-codebook","slug":"/topic-assignment/understanding-the-basics/import-copy-export-codebook","pageMetadata":{"title":"Import, copy, and export your codebook","sidebarTitle":"Import, copy \u0026 export a codebook","description":"Upload an existing codebook, reuse one from another project, or export your topic collection.","icon":"book-bookmark","keywords":["codebook","code book","code frame","codeframe","code plan","codeplan","Codeplan","plan de code","coding scheme","topic collection","import topics","export topics","download codebook","upload codes"],"href":"/topic-assignment/understanding-the-basics/import-copy-export-codebook"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Upload an existing codebook, reuse one from another project, or export your topic collection.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,em:`em`,p:`p`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,..._provideComponents(),...props.components},{Accordion,AccordionGroup,Card,CardGroup,Frame,Heading,Note,OptimizedImage,Step,Steps,Tab,Table,Tabs,Tip,Warning}=_components;if(!Accordion)_missingMdxReference(`Accordion`,true);if(!AccordionGroup)_missingMdxReference(`AccordionGroup`,true);if(!Card)_missingMdxReference(`Card`,true);if(!CardGroup)_missingMdxReference(`CardGroup`,true);if(!Frame)_missingMdxReference(`Frame`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Note)_missingMdxReference(`Note`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);if(!Step)_missingMdxReference(`Step`,true);if(!Steps)_missingMdxReference(`Steps`,true);if(!Tab)_missingMdxReference(`Tab`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Tabs)_missingMdxReference(`Tabs`,true);if(!Tip)_missingMdxReference(`Tip`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[`In Caplena, your codebook is called a `,_jsx(_components.strong,{children:`topic collection`}),`: the categories, topics, codes, and descriptions used to analyze a text column. You might also know it as a `,_jsx(_components.em,{children:`code frame`}),`, `,_jsx(_components.em,{children:`code plan`}),`, or `,_jsx(_components.em,{children:`coding scheme`}),`.`]}),`\n`,_jsx(_components.p,{children:`This page covers the three ways to move a codebook in and out of Caplena:`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`I want to…`}),_jsx(_components.th,{children:`Use`}),_jsx(_components.th,{children:`Where`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Use a codebook I already have in a file`}),_jsx(_components.td,{children:_jsx(_components.strong,{children:`Upload File`})}),_jsx(_components.td,{children:`When starting the analysis`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Reuse a codebook from another Caplena project`}),_jsx(_components.td,{children:_jsx(_components.strong,{children:`Import from another project`})}),_jsx(_components.td,{children:`When starting the analysis, or from the Topics tab`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Get my codebook out of Caplena`}),_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`Topic summary`}),` export`]}),_jsx(_components.td,{children:`Export dialog in the Topics view`})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`import-a-codebook-from-a-file`,children:`Import a codebook from a file`}),`\n`,_jsx(_components.p,{children:`If you already have a list of codes, for example from a previous study or a client’s coding scheme, you can upload it instead of letting the AI generate topics from scratch.`}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`Prepare your file`,children:_jsxs(_components.p,{children:[`Put your codebook in a `,_jsx(_components.strong,{children:`CSV or Excel`}),` file, one topic per row, using the column names below. A plain text list can’t be imported directly. Paste it into Excel first, with one topic per row in a `,_jsx(_components.code,{children:`topic`}),` column.`]})}),_jsx(Step,{title:`Start the analysis`,children:_jsxs(_components.p,{children:[`Open your project and click `,_jsx(_components.strong,{children:`Start analysis now`}),` on the Overview panel.`]})}),_jsx(Step,{title:`Choose Import existing topics`,children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Choose how to start`}),`, select `,_jsx(_components.strong,{children:`Import existing topics`}),`, then `,_jsx(_components.strong,{children:`Upload File`}),`, and upload your file.`]})})]}),`\n`,_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/CleanShot-2026-05-19-at-19.08.43.gif?s=365ae2779cd4bb0c4f96460c719e38d8`,alt:`Importing existing topics`,\"data-og-width\":`800`,width:`800`,\"data-og-height\":`291`,height:`291`,\"data-path\":`images/CleanShot-2026-05-19-at-19.08.43.gif`,\"data-optimize\":`true`,\"data-opv\":`3`})}),`\n`,_jsx(Heading,{level:`3`,id:`file-format`,children:`File format`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Column`}),_jsx(_components.th,{children:`Required`}),_jsx(_components.th,{children:`What it’s for`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`topic`})}),_jsx(_components.td,{children:`Yes`}),_jsx(_components.td,{children:`The topic name (label).`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`category`})}),_jsx(_components.td,{children:`Yes`}),_jsx(_components.td,{children:`The category the topic belongs to.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`code`})}),_jsx(_components.td,{children:`No`}),_jsx(_components.td,{children:`A unique numerical ID for the topic. Use this to keep your existing code numbers. If you leave it out, Caplena assigns codes automatically.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`sentiment`})}),_jsx(_components.td,{children:`No`}),_jsx(_components.td,{children:`The sentiment setting for the topic.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`description`})}),_jsx(_components.td,{children:`No`}),_jsx(_components.td,{children:`When the topic should apply. The AI uses this as a primary input when assigning topics.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`keywords`})}),_jsx(_components.td,{children:`No`}),_jsxs(_components.td,{children:[`Comma-separated keywords, used in `,_jsx(_components.a,{href:`/get-started/starting-a-new-project/semi-open-mode-quick-guide`,children:`Semi-Open mode`}),` to match responses. Each keyword must be `,_jsx(_components.strong,{children:`30 characters or fewer`}),`, including spaces.`]})]})]})]}),`\n`,_jsx(_components.p,{children:`Your file must match one of these two layouts.`}),`\n`,_jsxs(Tabs,{children:[_jsx(Tab,{title:`With sentiment`,id:`with-sentiment`,children:_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/Screenshot-2026-05-19-at-19.15.55.png?fit=max\u0026auto=format\u0026n=jzzwh32UssPO_LPX\u0026q=85\u0026s=7aad1d5a9963245ad214720b971d3b44`,alt:`Codebook file format with sentiment`,\"data-og-width\":`2786`,width:`2786`,\"data-og-height\":`956`,height:`956`,\"data-path\":`images/Screenshot-2026-05-19-at-19.15.55.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/Screenshot-2026-05-19-at-19.15.55.png?w=280\u0026fit=max\u0026auto=format\u0026n=jzzwh32UssPO_LPX\u0026q=85\u0026s=abc0237f9d9edfb4ae0d1a93b3204f20 280w, https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/Screenshot-2026-05-19-at-19.15.55.png?w=560\u0026fit=max\u0026auto=format\u0026n=jzzwh32UssPO_LPX\u0026q=85\u0026s=b8b272b600626bbe9424b78af18bedc4 560w, https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/Screenshot-2026-05-19-at-19.15.55.png?w=840\u0026fit=max\u0026auto=format\u0026n=jzzwh32UssPO_LPX\u0026q=85\u0026s=0b6d8db35fa8314f91eb4894e59867ad 840w, https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/Screenshot-2026-05-19-at-19.15.55.png?w=1100\u0026fit=max\u0026auto=format\u0026n=jzzwh32UssPO_LPX\u0026q=85\u0026s=e42362fe985ca201920e4e080893b3f2 1100w, https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/Screenshot-2026-05-19-at-19.15.55.png?w=1650\u0026fit=max\u0026auto=format\u0026n=jzzwh32UssPO_LPX\u0026q=85\u0026s=f0fc57420f54ad2231102260f33c6a4a 1650w, https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/Screenshot-2026-05-19-at-19.15.55.png?w=2500\u0026fit=max\u0026auto=format\u0026n=jzzwh32UssPO_LPX\u0026q=85\u0026s=f5aa369609925f17eb209f450b586f9d 2500w`})})}),_jsx(Tab,{title:`Without sentiment`,id:`without-sentiment`,children:_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/Screenshot-2026-05-19-at-19.18.02.png?fit=max\u0026auto=format\u0026n=jzzwh32UssPO_LPX\u0026q=85\u0026s=82f60b15e15485b23292971e4716592a`,alt:`Codebook file format without sentiment`,\"data-og-width\":`2210`,width:`2210`,\"data-og-height\":`914`,height:`914`,\"data-path\":`images/Screenshot-2026-05-19-at-19.18.02.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/Screenshot-2026-05-19-at-19.18.02.png?w=280\u0026fit=max\u0026auto=format\u0026n=jzzwh32UssPO_LPX\u0026q=85\u0026s=c6835514da330e5e736a688fe0acac7d 280w, https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/Screenshot-2026-05-19-at-19.18.02.png?w=560\u0026fit=max\u0026auto=format\u0026n=jzzwh32UssPO_LPX\u0026q=85\u0026s=0a340c0f34f349fe66f947ecb3c3c54f 560w, https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/Screenshot-2026-05-19-at-19.18.02.png?w=840\u0026fit=max\u0026auto=format\u0026n=jzzwh32UssPO_LPX\u0026q=85\u0026s=0f9fc3e8ab89bd1e636839dc16d67c60 840w, https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/Screenshot-2026-05-19-at-19.18.02.png?w=1100\u0026fit=max\u0026auto=format\u0026n=jzzwh32UssPO_LPX\u0026q=85\u0026s=a6cccfeb5163354f5daed84d564b5f0a 1100w, https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/Screenshot-2026-05-19-at-19.18.02.png?w=1650\u0026fit=max\u0026auto=format\u0026n=jzzwh32UssPO_LPX\u0026q=85\u0026s=50a7a31bfad1616d92b8a97782eed03b 1650w, https://mintcdn.com/caplena-32172960/jzzwh32UssPO_LPX/images/Screenshot-2026-05-19-at-19.18.02.png?w=2500\u0026fit=max\u0026auto=format\u0026n=jzzwh32UssPO_LPX\u0026q=85\u0026s=e18be98d4719c4c97299a75adf1eb02d 2500w`})})}),_jsx(Tab,{title:`With descriptions`,id:`with-descriptions`,children:_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/caplena-32172960/wNeVaDSnwot20T5D/images/topic-assignment/codebook/codebook-file-example.png?fit=max\u0026auto=format\u0026n=wNeVaDSnwot20T5D\u0026q=85\u0026s=37e036023d534fc3b04661fd26f99e18`,alt:`Codebook file format with descriptions`,\"data-og-width\":`2298`,width:`2298`,\"data-og-height\":`346`,height:`346`,\"data-path\":`images/topic-assignment/codebook/codebook-file-example.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/caplena-32172960/wNeVaDSnwot20T5D/images/topic-assignment/codebook/codebook-file-example.png?w=280\u0026fit=max\u0026auto=format\u0026n=wNeVaDSnwot20T5D\u0026q=85\u0026s=8579090371a7cb005053f86174961cca 280w, https://mintcdn.com/caplena-32172960/wNeVaDSnwot20T5D/images/topic-assignment/codebook/codebook-file-example.png?w=560\u0026fit=max\u0026auto=format\u0026n=wNeVaDSnwot20T5D\u0026q=85\u0026s=49e4f5182a500229907edfd58f425b48 560w, https://mintcdn.com/caplena-32172960/wNeVaDSnwot20T5D/images/topic-assignment/codebook/codebook-file-example.png?w=840\u0026fit=max\u0026auto=format\u0026n=wNeVaDSnwot20T5D\u0026q=85\u0026s=dcd0102251b1a17bbc6c06c7565cee4d 840w, https://mintcdn.com/caplena-32172960/wNeVaDSnwot20T5D/images/topic-assignment/codebook/codebook-file-example.png?w=1100\u0026fit=max\u0026auto=format\u0026n=wNeVaDSnwot20T5D\u0026q=85\u0026s=0ebef9dddf2ce79845f94f4f673c0c9d 1100w, https://mintcdn.com/caplena-32172960/wNeVaDSnwot20T5D/images/topic-assignment/codebook/codebook-file-example.png?w=1650\u0026fit=max\u0026auto=format\u0026n=wNeVaDSnwot20T5D\u0026q=85\u0026s=a3f79d937d38a32e8992b80dcfe8ef36 1650w, https://mintcdn.com/caplena-32172960/wNeVaDSnwot20T5D/images/topic-assignment/codebook/codebook-file-example.png?w=2500\u0026fit=max\u0026auto=format\u0026n=wNeVaDSnwot20T5D\u0026q=85\u0026s=10622545745cd5e2a4f0880d3c95e25f 2500w`})})})]}),`\n`,_jsx(Tip,{children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Add descriptions if you can.`}),` A topic like `,_jsx(_components.code,{children:`Pricing`}),` is assigned much more reliably with a description such as `,_jsx(_components.em,{children:`“Mentions of cost, price, fees, or value for money, including comments about discounts and subscription tiers.”`}),` If the column is empty, Caplena generates descriptions on the first run, but your own keep assignments aligned with how your team defines each topic.`]})}),`\n`,_jsx(Warning,{children:_jsx(_components.p,{children:`Imports with a keyword longer than 30 characters are rejected with an error. Shorten or split long keywords before uploading.`})}),`\n`,_jsx(Tip,{children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`You can upload an exported codebook as-is.`}),` A `,_jsx(_components.a,{href:`#topic-summary-download-your-codebook`,children:`Topic summary export`}),` from another project can be uploaded directly, with no renaming or cleanup needed. Caplena matches the columns it needs and ignores the rest, such as colors and answer counts. This is an easy way to reuse a codebook across projects or accounts, or to edit it in Excel and bring it back.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`reuse-a-codebook-from-another-caplena-project`,children:`Reuse a codebook from another Caplena project`}),`\n`,_jsx(Tip,{children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Running the same survey again?`}),` For recurring studies, such as quarterly NPS, yearly employee surveys, or a new wave of the same questionnaire, you usually don’t need a second project. Keep everything in one project: `,_jsx(_components.a,{href:`/data-project-management/adding-replacing-data/append-rows-to-an-existing-project`,children:`append the new rows`}),` and add a `,_jsx(_components.a,{href:`/data-project-management/common-smart-columns-intro/creating-a-helper-column-e.g.-wave-or-year`,children:`wave or year column`}),` to tell the waves apart. The new responses are coded with the same codebook, and you can compare waves directly in your reports.`]})}),`\n`,_jsxs(_components.p,{children:[`Reusing a codebook across projects makes sense when the projects really need to be separate, for example a different study that should use the same coding scheme, or a `,_jsx(_components.a,{href:`/topic-assignment/new-ai/tracker-setup`,children:`DEV/PROD tracker setup`}),`. There is a way to do it.`]}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`Start the analysis`,children:_jsxs(_components.p,{children:[`In the project that needs the codebook, click `,_jsx(_components.strong,{children:`Start analysis now`}),`.`]})}),_jsx(Step,{title:`Choose Other project`,children:_jsxs(_components.p,{children:[`Select `,_jsx(_components.strong,{children:`Import existing topics`}),`, then `,_jsx(_components.strong,{children:`Other project`}),`.`]})}),_jsx(Step,{title:`Select the source`,children:_jsxs(_components.p,{children:[`Choose the project and the text column whose codebook you want, then click `,_jsx(_components.strong,{children:`Inherit topic collection`}),`.`]})})]}),`\n`,_jsx(Note,{children:_jsxs(_components.p,{children:[`Inheriting topics with the LLM model works best when the new dataset asks the same question in the same context. If the question wording or column context differs, review the inherited descriptions before running the AI. See `,_jsx(_components.a,{href:`/topic-assignment/understanding-the-basics/learning-relationships-between-projects-legacy-ai-vs-new-ai`,children:`Learning Relationships Between Projects`}),` for details.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`export-your-codebook`,children:`Export your codebook`}),`\n`,_jsx(Heading,{level:`3`,id:`topic-summary-download-your-codebook`,children:`Topic summary (download your codebook)`}),`\n`,_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Topic summary`}),` export is how you download your codebook. `,_jsx(`br`,{})]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/caplena-32172960/3kDgRWsd3gh3-deP/images/Screenshot-2026-10-02-at-16.11.49.png?fit=max\u0026auto=format\u0026n=3kDgRWsd3gh3-deP\u0026q=85\u0026s=0e09e86e4ed6fb725e0f90ee22962c8a`,alt:`Screenshot 2026 10 02 At 16 11 49`,\"data-og-width\":`1962`,width:`1962`,\"data-og-height\":`334`,height:`334`,\"data-path\":`images/Screenshot-2026-10-02-at-16.11.49.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/caplena-32172960/3kDgRWsd3gh3-deP/images/Screenshot-2026-10-02-at-16.11.49.png?w=280\u0026fit=max\u0026auto=format\u0026n=3kDgRWsd3gh3-deP\u0026q=85\u0026s=51c885400694d26ec68a02f5265c28a9 280w, https://mintcdn.com/caplena-32172960/3kDgRWsd3gh3-deP/images/Screenshot-2026-10-02-at-16.11.49.png?w=560\u0026fit=max\u0026auto=format\u0026n=3kDgRWsd3gh3-deP\u0026q=85\u0026s=ca0cada5729af172ee0c0164dd8faa5f 560w, https://mintcdn.com/caplena-32172960/3kDgRWsd3gh3-deP/images/Screenshot-2026-10-02-at-16.11.49.png?w=840\u0026fit=max\u0026auto=format\u0026n=3kDgRWsd3gh3-deP\u0026q=85\u0026s=4bd66eb2bbb89991ad2c4041cf34edcd 840w, https://mintcdn.com/caplena-32172960/3kDgRWsd3gh3-deP/images/Screenshot-2026-10-02-at-16.11.49.png?w=1100\u0026fit=max\u0026auto=format\u0026n=3kDgRWsd3gh3-deP\u0026q=85\u0026s=eed21432231e84e4c6b9a3c3f3d9dd6b 1100w, https://mintcdn.com/caplena-32172960/3kDgRWsd3gh3-deP/images/Screenshot-2026-10-02-at-16.11.49.png?w=1650\u0026fit=max\u0026auto=format\u0026n=3kDgRWsd3gh3-deP\u0026q=85\u0026s=7377b79d2c6b5a5bb7117a96f3a70de7 1650w, https://mintcdn.com/caplena-32172960/3kDgRWsd3gh3-deP/images/Screenshot-2026-10-02-at-16.11.49.png?w=2500\u0026fit=max\u0026auto=format\u0026n=3kDgRWsd3gh3-deP\u0026q=85\u0026s=26d4aee3c82e4fa6de2cb1d22c849314 2500w`}),`\n`,_jsxs(_components.p,{children:[`The export also includes a `,_jsx(_components.strong,{children:`category overview`}),` with the number and share of answers per category. An answer with several topics in the same category is counted once.`]}),`\n`,_jsx(Note,{children:_jsxs(_components.p,{children:[`For topics with sentiment enabled, each sentiment variant (neutral, negative, positive) is a `,_jsx(_components.strong,{children:`separate row with its own code`}),`. For example, `,_jsx(_components.code,{children:`AI Topic Detection`}),` might appear as codes 1 (neutral), 2 (negative), and 3 (positive). Keep this in mind when matching codes in SPSS or another tabulation tool.`]})}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`Open the export dialog`,children:_jsxs(_components.p,{children:[`Go to the `,_jsx(_components.strong,{children:`Topics view`}),` and click `,_jsx(_components.strong,{children:`Export`}),` (top right).`]})}),_jsx(Step,{title:`Choose Topic summary`,children:_jsxs(_components.p,{children:[`Click the `,_jsx(_components.strong,{children:`Topic summary`}),` tab and choose a file type, for example Excel.`]})}),_jsx(Step,{title:`Export`,children:_jsxs(_components.p,{children:[`Click `,_jsx(_components.strong,{children:`Export`}),`.`]})})]}),`\n`,_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/caplena-32172960/iGmU8JfudIwExHbA/images/Screenshot-2026-05-23-at-15.23.47.png?fit=max\u0026auto=format\u0026n=iGmU8JfudIwExHbA\u0026q=85\u0026s=1439204b1ce2f9622f3e7e0a6c423ab4`,alt:`Topic summary export tab`,\"data-og-width\":`1488`,width:`1488`,\"data-og-height\":`956`,height:`956`,\"data-path\":`images/Screenshot-2026-05-23-at-15.23.47.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/caplena-32172960/iGmU8JfudIwExHbA/images/Screenshot-2026-05-23-at-15.23.47.png?w=280\u0026fit=max\u0026auto=format\u0026n=iGmU8JfudIwExHbA\u0026q=85\u0026s=cf2b48403b60c4c8b99b2bacc9cfdd43 280w, https://mintcdn.com/caplena-32172960/iGmU8JfudIwExHbA/images/Screenshot-2026-05-23-at-15.23.47.png?w=560\u0026fit=max\u0026auto=format\u0026n=iGmU8JfudIwExHbA\u0026q=85\u0026s=c0fa9cb608345b8d07dae88b0aadb605 560w, https://mintcdn.com/caplena-32172960/iGmU8JfudIwExHbA/images/Screenshot-2026-05-23-at-15.23.47.png?w=840\u0026fit=max\u0026auto=format\u0026n=iGmU8JfudIwExHbA\u0026q=85\u0026s=25dcc57285767873aad19bb2cd20a378 840w, https://mintcdn.com/caplena-32172960/iGmU8JfudIwExHbA/images/Screenshot-2026-05-23-at-15.23.47.png?w=1100\u0026fit=max\u0026auto=format\u0026n=iGmU8JfudIwExHbA\u0026q=85\u0026s=ae8077db1c925c44d75f31ce6eda409e 1100w, https://mintcdn.com/caplena-32172960/iGmU8JfudIwExHbA/images/Screenshot-2026-05-23-at-15.23.47.png?w=1650\u0026fit=max\u0026auto=format\u0026n=iGmU8JfudIwExHbA\u0026q=85\u0026s=12bc5066ef1e3e261030bdba1169818b 1650w, https://mintcdn.com/caplena-32172960/iGmU8JfudIwExHbA/images/Screenshot-2026-05-23-at-15.23.47.png?w=2500\u0026fit=max\u0026auto=format\u0026n=iGmU8JfudIwExHbA\u0026q=85\u0026s=4cc71e374da5edbc302322a6bd5b5455 2500w`})}),`\n`,_jsx(Note,{children:_jsxs(_components.p,{children:[`The Topic summary is exported `,_jsx(_components.strong,{children:`per topic collection`}),`, so one text column at a time. If your project has several text columns, export the summary for each one.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`common-questions`,children:`Common questions`}),`\n`,_jsxs(AccordionGroup,{children:[_jsx(Accordion,{title:`How do I download my codebook?`,id:`how-do-i-download-my-codebook`,children:_jsxs(_components.p,{children:[`Go to the `,_jsx(_components.strong,{children:`Topics view`}),`, click `,_jsx(_components.strong,{children:`Export`}),`, open the `,_jsx(_components.strong,{children:`Topic summary`}),` tab, and export to Excel or CSV. You’ll get every topic with its code, category, sentiment, description, and keywords. See `,_jsx(_components.a,{href:`#topic-summary-download-your-codebook`,children:`Topic summary`}),`.`]})}),_jsx(Accordion,{title:`Can I edit my codebook in Excel and upload it again?`,id:`can-i-edit-my-codebook-in-excel-and-upload-it-again`,children:_jsxs(_components.p,{children:[`Yes. Export the `,_jsx(_components.a,{href:`#topic-summary-download-your-codebook`,children:`Topic summary`}),`, make your changes in Excel, and upload the file through `,_jsx(_components.strong,{children:`Import existing topics → Upload File`}),`. You don’t need to rename or remove columns. Caplena picks up the ones it needs.`]})}),_jsx(Accordion,{title:`Can I keep my existing code numbers?`,id:`can-i-keep-my-existing-code-numbers`,children:_jsxs(_components.p,{children:[`Yes. Include a `,_jsx(_components.code,{children:`code`}),` column in your upload file. You can also set codes manually on each topic. See `,_jsx(_components.a,{href:`/topic-assignment/understanding-the-basics/main-concepts-categories-topics-sentiment#code`,children:`Code`}),`.`]})}),_jsx(Accordion,{title:`I have my codes as a plain text list. Can I paste them in?`,id:`i-have-my-codes-as-a-plain-text-list-can-i-paste-them-in`,children:_jsxs(_components.p,{children:[`Not directly. Paste the list into Excel with one topic per row under a `,_jsx(_components.code,{children:`topic`}),` header, add `,_jsx(_components.code,{children:`category`}),` or other columns if you have them, and upload the file.`]})}),_jsx(Accordion,{title:`I want the same codebook for two waves of the same survey`,id:`i-want-the-same-codebook-for-two-waves-of-the-same-survey`,children:_jsxs(_components.p,{children:[`The simplest setup is one project for all waves. Append the new wave’s rows to the existing project and add a wave or year column to tell them apart, so every wave uses the same codebook and you can compare them in one report. See `,_jsx(_components.a,{href:`/data-project-management/adding-replacing-data/append-rows-to-an-existing-project`,children:`Append Rows to an Existing Project`}),` and `,_jsx(_components.a,{href:`/data-project-management/common-smart-columns-intro/creating-a-helper-column-e.g.-wave-or-year`,children:`Creating a Helper Column`}),`.`]})}),_jsx(Accordion,{title:`Can I import a codebook into a project that's already been analyzed?`,id:`can-i-import-a-codebook-into-a-project-thats-already-been-analyzed`,children:_jsxs(_components.p,{children:[`Yes, but importing a new codebook `,_jsx(_components.strong,{children:`restarts the analysis`}),`, and topics are assigned again from scratch. Before you import, export the current `,_jsx(_components.a,{href:`#topic-summary-download-your-codebook`,children:`Topic summary`}),` so you have a copy of the existing codebook to go back to.`]})}),_jsx(Accordion,{title:`I want to test changes to my codebook without losing the current version`,id:`i-want-to-test-changes-to-my-codebook-without-losing-the-current-version`,children:_jsxs(_components.p,{children:[`Use a separate test project and copy the codebook there, then copy it back once you’re happy. See `,_jsx(_components.a,{href:`/topic-assignment/new-ai/tracker-setup`,children:`Tracker Setup: Best Practices`}),`.`]})})]}),`\n`,_jsx(Heading,{level:`2`,id:`related-pages`,children:`Related pages`}),`\n`,_jsxs(CardGroup,{cols:2,children:[_jsx(Card,{title:`Starting the analysis`,icon:`play`,href:`/topic-assignment/understanding-the-basics/starting-the-analysis`,children:_jsx(_components.p,{children:`All the ways to create your first topic collection.`})}),_jsx(Card,{title:`Key concepts`,icon:`book`,href:`/topic-assignment/understanding-the-basics/main-concepts-categories-topics-sentiment`,children:_jsx(_components.p,{children:`Categories, topics, codes, and sentiment explained.`})}),_jsx(Card,{title:`Tracker Setup: Best Practices`,icon:`repeat`,href:`/topic-assignment/new-ai/tracker-setup`,children:_jsx(_components.p,{children:`Manage recurring studies with a DEV and PROD project.`})}),_jsx(Card,{title:`Exporting Your Data`,href:`/data-project-management/data-export/exporting-your-data`,children:_jsx(_components.p,{children:`All export formats for coded data.`})})]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Import, copy, and export your codebook","sidebarTitle":"Import, copy \u0026 export a codebook","description":"Upload an existing codebook, reuse one from another project, or export your topic collection.","icon":"book-bookmark","keywords":["codebook","code book","code frame","codeframe","code plan","codeplan","Codeplan","plan de code","coding scheme","topic collection","import topics","export topics","download codebook","upload codes"],"href":"/topic-assignment/understanding-the-basics/import-copy-export-codebook"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Import a codebook from a file","slug":"import-a-codebook-from-a-file","depth":2,"children":[{"title":"File format","slug":"file-format","depth":3,"children":[]}]},{"title":"Reuse a codebook from another Caplena project","slug":"reuse-a-codebook-from-another-caplena-project","depth":2,"children":[]},{"title":"Export your codebook","slug":"export-your-codebook","depth":2,"children":[{"title":"Topic summary (download your codebook)","slug":"topic-summary-download-your-codebook","depth":3,"children":[]}]},{"title":"Common questions","slug":"common-questions","depth":2,"children":[]},{"title":"Related pages","slug":"related-pages","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"caplena-32172960","siteName":"Caplena Documentation","title":"Import, copy, and export your codebook - Caplena Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/topic-assignment/understanding-the-basics/import-copy-export-codebook","matchLevel":0}}},"lastModified":"2026-10-12T11:05:02.803Z","gitLastModified":"2026-10-12T11:04:49.000Z","originalFileLocation":"topic-assignment/understanding-the-basics/import-copy-export-codebook.mdx","locale":"en"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"light\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Upload an existing codebook, reuse one from another project, or export your topic collection.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Caplena Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003cmeta data-mint-head name=\"robots\" content=\"all\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/caplena-32172960/H_wPWMWa1gVp5JBt/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/caplena-32172960/H_wPWMWa1gVp5JBt/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/caplena-32172960/H_wPWMWa1gVp5JBt/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/caplena-32172960/H_wPWMWa1gVp5JBt/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/caplena-32172960/H_wPWMWa1gVp5JBt/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/caplena-32172960/H_wPWMWa1gVp5JBt/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/caplena-32172960/H_wPWMWa1gVp5JBt/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/caplena-32172960/H_wPWMWa1gVp5JBt/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/caplena-32172960/H_wPWMWa1gVp5JBt/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Import, copy, and export your codebook - Caplena Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Upload an existing codebook, reuse one from another project, or export your topic collection.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Caplena Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.caplena.com/topic-assignment/understanding-the-basics/import-copy-export-codebook\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://caplena-32172960.mintlify.site/_mintlify/api/og/v2?division=Understanding+the+Basics\u0026amp;title=Import%2C+copy%2C+and+export+your+codebook\u0026amp;description=Upload+an+existing+codebook%2C+reuse+one+from+another+project%2C+or+export+your+topic+collection.\u0026amp;theme=1b671347511233134e88d27f\u0026amp;signature=68b65644d11125c8df4aaa532d688e572bb67efb3f57bb3152573f0cdab2f74b\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Import, copy, and export your codebook - Caplena Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Upload an existing codebook, reuse one from another project, or export your topic collection.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://caplena-32172960.mintlify.site/_mintlify/api/og/v2?division=Understanding+the+Basics\u0026amp;title=Import%2C+copy%2C+and+export+your+codebook\u0026amp;description=Upload+an+existing+codebook%2C+reuse+one+from+another+project%2C+or+export+your+topic+collection.\u0026amp;theme=1b671347511233134e88d27f\u0026amp;signature=68b65644d11125c8df4aaa532d688e572bb67efb3f57bb3152573f0cdab2f74b\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/caplena-32172960/H_wPWMWa1gVp5JBt/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Caplena Documentation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#191919\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.caplena.com/topic-assignment/understanding-the-basics/import-copy-export-codebook\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/topic-assignment/understanding-the-basics/import-copy-export-codebook.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.caplena.com/#organization\",\"name\":\"Caplena Documentation\",\"url\":\"https://docs.caplena.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/caplena-32172960/QDllrFkrr8IVUaqz/logo/light.svg?fit=max\u0026auto=format\u0026n=QDllrFkrr8IVUaqz\u0026q=85\u0026s=4fa4c95df2a6b3ed361772ae422145d4\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.caplena.com#website\",\"name\":\"Caplena Documentation\",\"url\":\"https://docs.caplena.com\",\"publisher\":{\"@id\":\"https://docs.caplena.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.caplena.com/topic-assignment/understanding-the-basics/import-copy-export-codebook#webpage\",\"url\":\"https://docs.caplena.com/topic-assignment/understanding-the-basics/import-copy-export-codebook\",\"name\":\"Import, copy, and export your codebook\",\"description\":\"Upload an existing codebook, reuse one from another project, or export your topic collection.\",\"dateModified\":\"2026-10-12T11:04:49.000Z\",\"isPartOf\":{\"@id\":\"https://docs.caplena.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.caplena.com/topic-assignment/understanding-the-basics/import-copy-export-codebook#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.caplena.com/topic-assignment/understanding-the-basics/import-copy-export-codebook#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Understanding the Basics\",\"item\":\"https://docs.caplena.com/topic-assignment/understanding-the-basics/main-concepts-categories-topics-sentiment\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import, copy, and export your codebook\",\"item\":\"https://docs.caplena.com/topic-assignment/understanding-the-basics/import-copy-export-codebook\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.caplena.com/topic-assignment/understanding-the-basics/import-copy-export-codebook#article\",\"headline\":\"Import, copy, and export your codebook\",\"name\":\"Import, copy, and export your codebook\",\"description\":\"Upload an existing codebook, reuse one from another project, or export your topic collection.\",\"url\":\"https://docs.caplena.com/topic-assignment/understanding-the-basics/import-copy-export-codebook\",\"mainEntityOfPage\":{\"@id\":\"https://docs.caplena.com/topic-assignment/understanding-the-basics/import-copy-export-codebook#webpage\"},\"dateModified\":\"2026-10-12T11:04:49.000Z\",\"keywords\":\"codebook, code book, code frame, codeframe, code plan, codeplan, Codeplan, plan de code, coding scheme, topic collection, import topics, export topics, download codebook, upload codes\",\"publisher\":{\"@id\":\"https://docs.caplena.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.caplena.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Caplena Documentation\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Caplena Documentation\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/topic-assignment/understanding-the-basics/import-copy-export-codebook.md","siteName":"Caplena Documentation","nav":{"global":{"anchors":[{"anchor":"Blog","icon":"newspaper","href":"https://caplena.com/en/blog"}]},"languages":[{"language":"en","tabs":[{"tab":"Home","icon":"house","pages":[{"title":"Home","href":""}]},{"tab":"Get Started","icon":"angles-right","pages":[{"title":"Get Started","href":"/get-started/getting-started-with-caplena"}]},{"tab":"Topic Analysis","icon":"arrow-down-a-z","groups":[{"group":"Understanding the Basics","icon":"book","pages":[{"title":"Key concepts: Categories, topics \u0026 sentiment","href":"/topic-assignment/understanding-the-basics/main-concepts-categories-topics-sentiment"},{"title":"Starting the analysis","description":"Generate your first topic structure and start making sense of your data.","href":"/topic-assignment/understanding-the-basics/starting-the-analysis"},{"title":"Import, copy, and export your codebook","sidebarTitle":"Import, copy \u0026 export a codebook","icon":"book-bookmark","href":"/topic-assignment/understanding-the-basics/import-copy-export-codebook"},{"title":"Using the Topic Assistant","description":"AI-powered suggestions to refine your topic structure — add missing topics, merge overlaps, and surface rare themes.","href":"/topic-assignment/understanding-the-basics/using-the-topic-assistant"}]},{"group":"LLM Model","icon":"brain","pages":[{"title":"How the LLM Topic Assignment Works","href":"/topic-assignment/new-ai/how-the-new-llm-topic-assignment-works"},{"title":"AI Advanced Output (Phrase Extraction)","sidebarTitle":"AI Advanced Output (Phrase Extraction)","href":"/topic-assignment/new-ai/ai-advanced-output-phrase-extraction"},{"title":"Prompt-Based Topic Generation","href":"/topic-assignment/new-ai/prompt-based-topic-generation"},{"title":"How to Ensure High-Quality Results with the LLM","href":"/topic-assignment/new-ai/how-to-ensure-high-quality-results-with-the-new-llm"},{"title":"Tracker Setup: Best Practices","href":"/topic-assignment/new-ai/tracker-setup"}]},{"group":"Advanced Functionality","icon":"gear","pages":[{"title":"How to Use Bulk Assign","href":"/topic-assignment/advanced-functionality/how-to-use-bulk-assign"},{"title":"Topic Assignment History","href":"/topic-assignment/advanced-functionality/topic-assignment-history"},{"title":"Learning Relationships Between Projects","href":"/topic-assignment/understanding-the-basics/learning-relationships-between-projects-legacy-ai-vs-new-ai"},{"title":"Group Identical Rows","href":"/topic-assignment/understanding-the-basics/group-identical-rows"}]},{"group":"Legacy Model","icon":"clock","hidden":true,"pages":[{"title":"How AI Assigns Topics (Legacy AI)","href":"/topic-assignment/legacy-ai/how-ai-assigns-topics"},{"title":"AI Training (Legacy AI)","href":"/topic-assignment/legacy-ai/ai-training"},{"title":"AI Score \u0026 Quality Measures (Legacy AI)","href":"/topic-assignment/legacy-ai/ai-score-and-quality-measures"},{"title":"Managing AI Updates (Legacy AI)","href":"/topic-assignment/legacy-ai/managing-ai-updates"}]}]},{"tab":"Insight \u0026 Reports","icon":"chart-bar","pages":[{"title":"Insight \u0026 Reports","href":"/insight-and-reports/insight-agent/insight-agent"}]},{"tab":"Data Management","icon":"database","pages":[{"title":"Data Management","href":"/data-project-management/project-management/managing-an-existing-project-settings-permissions"}]},{"tab":"Integrations","icon":"plug","pages":[{"title":"Integrations","href":"/integrations"}]},{"tab":"Settings \u0026 Administration","icon":"user-gear","pages":[{"title":"Settings \u0026 Administration","href":"/settings-administration/understanding-access/introduction-permission-types"}]}]}]},"basePath":"","title":"Import, copy, and export your codebook - Caplena Documentation","buildId":"dpl_GRSyrvXT6FFTpZZTGz5iZPp3D2zE","deploymentId":"dpl_GRSyrvXT6FFTpZZTGz5iZPp3D2zE","dynamics":["07c022d89b","a74be98ba7"],"chunks":["Frame-RDXR0lmt.js","DynamicMarkdown-Z_y464fM.js","zoom-image-lightbox-D5uLWhtj.js","lightbox-handle-r17bVUz3.js"]}