helen marshall

Work around to enable making classification sheet from excel spreadsheet

2 posts in this topic

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?

Share this post


Link to post
Share on other sites

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:

 

http://help-nv11mac.qsrinternational.com/desktop/procedures/import_(or_export)_classification_sheets.htm

 

Kind Regards,

Sameer

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