Jump to content

Search the Community

Showing results for tags 'excel'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Welcome
  • Discussions
    • NVivo Use Cases
    • Collaboration
    • Visualizations
    • Transcription
  • Ask a question
    • NVivo for Mac
    • NVivo for Windows
    • NVivo 12 for Mac and Older Versions
    • NVivo 12 for Windows and Older Versions
  • Make a suggestion
    • NVivo for Mac
    • NVivo for Windows
  • Ethnography's Ethnography
  • Mixed Methods's Mixed Methods
  • Grounded Theory's Grounded Theory
  • Arts Based Research Methods's Art Based Research Methods
  • Coding's Coding
  • Research Team Collaboration's Research Team Collaboration
  • Literature Review's Literature Review
  • Citavi and NVivo Integration - Product Advisory Board's Citavi
  • Citavi and NVivo Integration - Product Advisory Board's NVivo Integration

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start




Website URL


Research Interests


Job Title

Found 19 results

  1. Hi everyone, Our project involves qualitative coding of 6 open-ended questions at the end of a long survey of quantitative fields. There are >200 columns of quantitative data in the spreadsheet that we want to keep for attributes (e.g. demographic info) and to crosstab by later on in matrices. There are hundreds of observations in this dataset, which was imported from an Excel spreadsheet. Trying to code the open-response fields in this large spreadsheet is very laggy and we're looking for better solutions. Would it be possible to keep the quantitative attributes in a separate imp
  2. I'm using NVivo to code open-response fields of a larger survey with many close-ended questions. My NVivo file only has 1 source imported: 1 Excel file with lots of survey respondents as rows and many columns of quant data in addition to a couple columns containing the open-response question qual text. We inductively coded the qual text to quantify topics that came up. Now my ideal would be to append columns to my original survey data set; 1 column per node, with values of 1 assigned in the column if the participant had text coded to that node and values of 0 assigned if their passage was
  3. Hi, I'm wondering if there is a way to isolate the coding in the filtered rows in an excel spreadsheet? I need to only look at the coding in a portion of a fully coded excel spreadsheet so want to see 1/3 of the rows, with 1/3 of the coding so I can analysis as per a time period. Is there any way of doing this? Or is the only way to copy to file, and then uncode each of the rows I don't want to see? Thank you. Becky
  4. I have imported an excel spreadsheet into NVivo as a source document. I have coded to this document, but now I want to look at just a portion of it. Is it possible to delete or hide some of the rows, while retaining the coding in the other rows? Or, is it possible to export it as an excel spreadsheet with the coding in, and then I could change in excel and upload as a new project? Thank you!
  5. Hello, I have two questions in this post actually,but first background. I have 3 weeks of data which I took off of Twitter. I did a search for a particular hashtag and then collected on a week to week basis all the tweets that included that hashtag. I realized after the fact that I cannot collect these tweets as anything but a PDF file because they are not from the past 2 weeks. I have started going through the tweets one by one and copy and pasting data from the PDF into an excel to make it look like a dataset file taken from twitter. My questions are as follows: 1) is there
  6. Hi, I was wondering if the community can help me understand something. I am trying to finish my thesis which involves a content analysis of a subsample of roughly 104 public comments. I developed a codebook with which myself and a second person can code these comments (codes are the child nodes of the parent node which identifies the variable I am measuring). I want to use Choen's Kappa as a measure of inter-coder reliability and from what I understand, in order to get a coefficient for one node across all sources, I do something similar to the excel sheet found at the bottom of NVivo's F
  7. Hello everyone! My organization recently purchased Nvivo 11 for qualitatively analyzing our open ended survey responses. I am using the text search query function to create nodes based on pre-established themes for our data. I input the data from an excel spreadsheet that has the following items: respondent id, gender, class year, open ended comment. I have been able to create the nodes based on our themes and export the findings in excel as: id, comment. What I would like to do is export the node with the case classifications as well, similar to how it was imported. My goal is to
  8. I’m working with a fairly large dataset (300+ respondents for a mixed open- and close-ended response survey). I did some preliminary analysis of themes for the open-ended questions using Excel, just to get things moving. I want to know if there is any way in NVivo to create theme nodes based on what I created in Excel—the alternative seems to be that I need to do ALL of my coding from the start in NVivo, which seems like it will take forever with so many observations. Here are some screen shots of my question; hopefully it makes more sense this way. I did the following in Excel. You ca
  9. Hello I am a real newcomer to NVivo, so appreciate any help! I have imported survey responses from excel (free text) into NViVO and coded them in the source sheet using only nodes so far. As well as the comment there are other text columns to show which course they are on and department- is there a way to get a summary report of which comments have been coded which also includes the other info - course and school? At the moment it is just showing the section of the comment I coded. It would also be useful to get a count of how many people from a department made a certain type of comment et
  10. I am still quite new to NVivo and to QDA and am looking for a batch method of extracting textual information (i.e., basic information about cases) from documents that is NOT in tabular form -- although it occurs in a regular sequence at the beginning of each PDF file. I have about 800 sources and would like to do this using an automated program, but I have not been able to find one. Any assistance would be much appreciated. Best, David
  11. I have sources that have the name of a person, say Ahmed Hamza. I have an excel spreadsheet with lots of attribute data about each person, like Ahmed Hamza. I can import the excel spreadsheet as a node classification sheet. 1) When I do this, there is a way NVivo will recognize that each entry in one column, the names, should become nodes? The process here does not specify if the column with item 1,2,... become nodes in NVivo. 2) Assuming that #1 works and now I have a classification sheet where each row is a person coded as a node and also classified as person with his a
  12. I imported an excel datasheet that has both node classification data as well as codable, narrative fields. I would like to keep adding to this datasheet. After importing, the "layout" ribbon has "add rows". But it is greyed out and not usable. How does one make a table in an internal to add rows, or, simply edit an imported datasheet? The function is there, so clearly it does something.
  13. Good Day, I've been trying to get my data analysis in gear but cannot get beyond an issue when importing my dataset (from surveys) into NV. My survey has been complied into one Excel file (.xlsx) and I've cleaned the columns as best I can given the responses from participants (deleting spaces, capitalizing lower cases for proper nouns, spelling etc.). When I import into NV here is what I do and the problems I'm encountering: External data> dataset> Import wizard All columns are selected as classifying fields except the last 4 (net use, drawing, website, TV) This is the 1st issue:
  14. Hi, I have been exporting node summary reports to excel, so that I can easily sort and manipulate them. I can get what I am seeking. The challenge is that it takes a very long time to delete the many extraneous rows that do not contribute information. Is there a way to export without these extraneous lines? Thanks, Ellen Z.
  15. Having watched this video that explains how to import datasets into Nvivo (https://www.youtube.com/watch?v=XWBUH-hCAEY), I still can't manage to import my chosen dataset. I have an excel spreadsheet containing a forecast for a product demand in different countries. So my column A is UK, Germany, France, and Denmark, and the headings for Column B, C, D, E, etc are 1990, 1991, 1992, etc until 2020. The content of the spreadsheet is just numbers. Now I want to create a relational database where the demand in Germany in 1993 will return that specific value from the spreadsheet. I imported my
  16. I am working on a project that analyzes university program websites. My Internal Source folder structure is Internals/Websites/University. Each university's folder contains multiple webpages (home page, faq, courses, etc). Some of the universities offer multiple degrees that are part of my study. I originally coded the webpages with multiple nodes (nodes for degree requirements, college located in, department, type of masters, etc), but when trying to work with models and relationships, I couldn't filter the programs as I needed. It was recommended to me that I create classifications instead
  17. Apologies if the answer to this is in your extensive Help and online tutorials - but I've looked and so far been unable to find an answer. I'm classifying nodes which represent my interview participants. I want to import demographic data for each participant (age, income, education level etc). This info is in Excel, but during data entry was entered into the spreadsheet as a number rather than the value (ie Education level had 5 possible responses (1,2,3,4, or 5) which correspond to 1= up to Year 10, 2=Year 12, 3=TAFE etc). I want to import the data from this spreadsheet, but want it
  18. Hi ! I’m working with qualitativ data of a longitudinal study and need some help with Nvivo. I have a datasheet (excel) with study number of participant in the first column and answer to a question in the second column. I wonder if it’s possible to make appear the study number (which is in column 1) as name of source for each reference I code ? Each study number is related to demographic variables as sex, age, etc. So in my final report I’ll need to see, for each node, parts of answers with the study number to know if it’s from a woman, man, and how old they are. How can I do t
  19. Hello, I have been maintaining several spreadsheets in Excel because they are capturing qualitative data about ongoing events and my understanding is that I cannot edit a spreadsheet once it has been imported into NVivo. However, I would like to use NVivo for this purpose so that I can start coding the data and linking it to other sources. I note that Framework matrices are editable. Is there any reason why I shouldn't use them for the initial data entry rather than Excel providing they are clearly labeled and separated from the Framework analysis I plan to do across all my data? Thank you,
  • Create New...

Important Information

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