Jump to content

Problem linking classification sheet with data from open-ended questions

Recommended Posts


I use Nvivo 12 Pro

I am trying to link each case from my classification sheet (uploaded in Excel) to the each short-answer in my data set. Both the case and the answer are well identified with an Id number. The way i've done this in the past is right clicking on each answer and code it to the respective case. It has worked in the past, when I had a limited number of cases/responses.

For my current project, I have 2400 cases/responses. Doing this manually will take me an scandalous amount of time, not to mention the potential human error of erroneous coding. 

Does Nvivo have a way to speed up this process? A way to do this automatically? 

I will appreciate the help 

Share this post

Link to post
Share on other sites


You can do this automatically by importing an Excel file which has Id number as the first column and attributes, codeable data in the rest of the columns.

Refer to 'Import a spreadsheet or text file' section in the link below for more information:


I hope this helps.

Kind Regards,


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now