Jump to content

Importing a codebook from Excel

Recommended Posts

Is it possible to import a codebook from Excel into NVivo? I don't mean importing a classification sheet -- I mean importing a codebook with hierarchical codes.

Link to post
Share on other sites

Hello @Lisa2017,

You can import a codebook QDC format. Therefore, from the project you would like to use coding structure, export codebook in QDC format then you import that coding structure in your new project or share with your colleagues.

You can find detailed information here.

Hope this helps,


Link to post
Share on other sites

Thanks, Canarik! Unfortunately, I don't have a QDC file -- my codebook is in an Excel file. After posting my question, I learned that NVivo can't directly import codes from  Excel. It can be imported as a dataset (after inserting dummy data) and then one can auto-code the columns. Afterwards, the dataset can be deleted.

Drawbacks: (1) Multiple steps (2) Does not generate hierarchical codes (3) Does not include code descriptions

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Privacy Policyhttps://www.qsrinternational.com/privacy-policyhis site, you agree to our Terms of Use.