Which tab would you click to find the command for importing data from a text file?
Import data from spreadsheets and text filesThis feature is available in NVivo Pro and Plus editions. Learn more Show
You can import data from a Microsoft Excel spreadsheet or a text file containing comma or tab-separated values. For example, you might want to import a spreadsheet containing survey responses. If you have collected survey responses using SurveyMonkey or Qualtrics, you can import the responses directly into NVivo. Refer to Import from SurveyMonkey and Import from Qualtrics for more information. NOTE: The Survey Import Wizard is available in NVivo 11 (Update 2). If you are using an earlier version of NVivo, you will see the Import Dataset Wizard. Refer to Software updates for information about upgrading. What do you want to do?
Gather your dataYou cannot add additional rows or columns to a dataset after import, so it is important to gather your data before you start the import operation. For each dataset that you want to create, your data must be gathered into one of the following:
Text files must be organized as a tab or comma-delimited field values, so that the Survey Import Wizard can divide the contents into rows and columns. Each record must be on a separate line, and each field must be separated by the delimiter. The following is an example of a comma-delimited text file: You cannot select multiple worksheets (within a spreadsheet), so the data you want to import must be gathered into a single worksheet. The maximum amount of data that can be imported into a single dataset is 256 fields (columns) and 1,048,576 records (rows). Top of PageConsider how you want to use your data in NVivoYou cannot change the analysis type (codable or classifying) of a column after import, so you should decide how you want to use your data before you import a dataset. Open-ended questions that contain data you want to analyze are created and coded to nodes (codable)—for example, responses to open-ended survey questions such as How do you think we can reduce our carbon emissions? Close-ended questions that describe your data (metadata) are created as attributes (classifying)—for example, the ID number, Age, Gender and Annual Income of your survey respondents. Values in classifying fields:
Surveys must contain a unique identifier that identifies the responses of each individual. A unique identifier could be the respondent's name, however, in a large survey, names may not be unique. For uniqueness and to protect the identity of your respondents, you may prefer to manually assign each respondent a unique ID number. You can then gather all responses of an individual respondent to a single node—refer to Approaches to analyzing survey results for more information. Top of PagePrepare a spreadsheet or text file for import
Top of Page Import a spreadsheet or text fileThe Survey Import Wizard examines the data you are importing and helps you to ensure that the data is imported the way that you want.
If you coded for themes and sentiment, NVivo presents the results visually in a results matrix and hierarchy chart. (NVivo Plus only) NOTE
Work with your datasetAfter importing a dataset, a node is created for each open-ended survey question—a useful starting point for further exploration. A case node is created for each respondent which gathers all of a respondent's answers together. Descriptive data is created for the cases using the closed-ended (classifying) information in the dataset—this allows you to compare respondent attitudes based on attributes like age or gender. You can use a number of techniques to analyze the data—for example, you could:
Refer to Approaches to analyzing survey results for more detailed information. | <a href="http://www.qsrinternational.com/support" target="_blank">Technical support</a> | <a href="http://www.qsrinternational.com/nvivo-training" target="_blank">Training</a> <p class="Body_Text"> </p> </div> </div> </div> </body> </html> |