Jump to content


Work around to enable making classification sheet from excel spreadsheet

classification sheets autocoding

  • Please log in to reply
1 reply to this topic

#1 helen marshall

helen marshall

    Casual Member

  • Members
  • Pip
  • 8 posts
  • Gender:Female
  • Location:Centre for Applied Social Research , RMIT Melbourne Australia
  • Interests:My background is Sociology of the family.
    I am currently working on issues around analysing qualitative data.
    I teach and consult in qualitative research methods. I convene the Qualitative Interest Group which meets monthly at RMIT city campus

Posted 16 February 2017 - 11:32 AM

I am thinking about using the Mac version  and working with survey data.  If I can’t import  an Excel spreadsheet as a classification sheet in NVivo for Mac, can I import it as a dataset and use autocode and 'classify a dataset at cases for each value in a column' to create the classification sheet?  Will this give the same capacity to run queries (especially  coding and matrix queries) as the windows version?

Dr Helen Marshall
School of social science and Planning
Melbourne AustraliaWebpage for Social Science and Planning

#2 QSR Support

QSR Support

    Advanced Member

  • QSR Staff
  • PipPipPip
  • 2,085 posts
  • Gender:Not Telling

Posted 17 February 2017 - 03:54 PM

Hello Helen,


In this situation, please convert the excel spread sheet to .csv or to tab delimited .txt format. This can be done simply by using the save as button in Excel. Once it has been saved as any of the advised formats, you will be able to import it as a classification sheet.


Please refer to the below link which provides more information on acceptable file formats:




Kind Regards,


QSR Support

QSR International Pty Ltd
2nd Floor, 651 Doncaster Road | Doncaster Victoria 3108 Australia

Find answers to your support questions or raise new support requests online at:


Also tagged with one or more of these keywords: classification sheets, autocoding

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users