Jump to content

Search the Community

Showing results for tags 'excel'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • 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
  • Analyzing Qualitative Research: After the Interview Webinar Series's How-To’s for Data Analysis
  • Analyzing Qualitative Research: After the Interview Webinar Series's Transcribing Qualitative Data
  • Analyzing Qualitative Research: After the Interview Webinar Series's Qualitative Analysis of Cross-Cultural and Cross-Language Data
  • Analyzing Qualitative Research: After the Interview Webinar Series's Analytic Memo Strategies and Reflection
  • Analyzing Qualitative Research: After the Interview Webinar Series's Emergent Analysis
  • Analyzing Qualitative Research: After the Interview Webinar Series's Arts-Based Approaches to Qualitative Research
  • Analyzing Qualitative Research: After the Interview Webinar Series's Writing Up Qualitative Research for a Broad Audience
  • Analyzing Qualitative Research: After the Interview Webinar Series's Using Archived Qualitative Data
  • Analyzing Qualitative Research: After the Interview Webinar Series's NVivo Resources
  • Visual Insights's Ways to use visuals in NVivo
  • UNM CTSC Qualitative Network's General
  • UNM CTSC Qualitative Network's Qualitative Research


  • NVivo Use Cases
  • NVivo Video Clips
  • Research Network Recordings


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 23 results

  1. Hello everyone, Nvivo provides you great features for dataset analysis. However, there are certain points that you should consider before importing the data: You cannot edit dataset content inside NVivo, so it is important to check and prepare your data before you bring it into NVivo. For example, you might want to check spelling or hide the identify of people or organizations mentioned in survey responses. You cannot change the analysis type and data type of fields (columns) after import, so you should consider how you want to use the fields, before importing the data. For further details please here. Regards,
  2. Hi everyone, Having a bit of a frustrating issue with NVivo 12 plus. I have a very basic spreadsheet that is refusing to import into NVivo. Every time I try, it tells me 'selected spreadsheet has unsupported data.' I cannot for the life of me figure out what this unsupported data actually is so I can correct it. The spreadsheet has no formulas of any kind, it is a basic database spreadsheet. Can anyone help me out? Cheers, AW
  3. Hi all, I am uploading interview data saved in excel into NVivo 12. The first few sheets were fine, but now I am trying to upload sheets from a different file and I get the following error message: The operation couldn’t be completed. (GetDatasetExtendedProperties error 1.) I checked to make sure the column headers (interview questions) are not longer than 254 characters, but that doesn't seem to help. Any other ideas? Thank you, Hanna
  4. I have a (.xlsx, or .csv) dataset with about 250 respondents, including demographic info and, in one column, full transcripts. Each transcript is about an hour long, and so the viewing format of 100 entries per page is cumbersome. The hour-plus transcripts are also typically in single paragraphs, and so the code-striping seems to stripe the entire cell in the dataset for every applicable code, instead of just the line or two that are relevant. Would you import every row in the dataset as a separate file? If so, would the recommendation be to import them all as documents (.txt or .doc), instead of datasets? Huge thanks. Glad for any advice.
  5. 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 imported file from the coded fields and merge the sources by a linking ID number after the coding is done? Or, I know it's possible to have each observation as its own source and use the spreadsheet as a classification table not to be coded - but then would each of the hundreds of sources/observations have to be manually linked to each row in the classification table? If so, that also sounds too time-intensive to be feasible. Are there any workarounds that you know of? What would your recommendations be? Thanks in advance!
  6. 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 not assigned to that node. Would it be possible to do this, and then export the data set back out to Excel? My hope is that once the raw survey data + node data is exported, I can put it into stats software to do things like run regressions and check the balance of whether the demographics of people who answered "none" or "n/a" to the open-response question varied from those who gave a true answer etc. Sorry if this was asked already - I didn't see it. Thanks in advance!
  7. 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
  8. 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!
  9. 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 a way to convert PDF datasets of Tweets into an excel file simply? 2) if not, is there an easier way to transfer the PDF data from the PDF into an excel without having to copy and paste line by line into the excel file?
  10. 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 FAQ here (Also attached). I understand how Cohen's Kappa works mathematically with an example of two coders and two codes. However, I am having trouble understanding what is going on here with the spreadsheet. I just don't want to copy the formulae and placement without understanding what is being done to get an average kappa coefficient. So my question is this: Can someone break down the spreadsheet for me in descriptive terms? Even understanding What Sum EF, TA and TU would be immensely helpful. Pointing to other resources to lead me the right direction would be great too, unfortunately, I don't have any contacts at my university (and it's summer so feedback is nill anyway) that could help. Thanks in advance!
  11. 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 have a spreadsheet with: id, gender, class year, comment. I'm trying to get this for each node created so that essentially I've whittled down the large number of comments to only those fitting in with the themes we have identified which I will then separate by the other factors (gender and class year). I've used the export function in the data tab, but didn't find it provided anything useful regarding what I'm looking for. What I found more useful was right clicking on the node and using the "export node" option, but as I mentioned it does not indicate the case classifications in the output. If anyone could either provide directions on how to export with both the node comments and the classifications or indicate where to find that information it would be very helpful! Thanks!
  12. 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 can see the open-ended questions in column C, and columns D-F have the themes I created. I imported my dataset into NVivo, and now I want to know if there is any way I can automatically (or very quickly) create nodes based on the themes I found, and then code the open-ended responses with those nodes. It seems like the only way to do this is to literally go through each open-ended response, highlight it, and then code at a new/existing node. This is VERY cumbersome, as I have over 300 responses per question. Is there any way to do this more quickly?
  13. 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 etc.. I tried to do a matrix thing but couldn't work it out- is this the best way? OR can I export the dataset with the coding highlighted? When I export you can't see what has been coded and I want to filter out all of the non-coded comments. I will need to give a list of all relevant comments as an appendix but really don't want to have to code them all over again in Excel! Many thanks Jo
  14. 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
  15. 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 attributes, here is next question. Can I then tell Nvivo to find every instance of each name and code them all at the node of that name (which is classified as a person?) For example, Ahmed Hamza is imported via #1. Now I want to make sure that wherever in my sources "Ahmed Hamza" appears, those references fall under the node I just created. Thanks!
  16. 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.
  17. 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: the column that contains values for hours(net use) to 1 decimal place is NOT readable by NV as a classifying field citing the numbers are off somehow) complete import I create a classifying node named "participants" I select the data set and chose "classify nodes from dataset"> nodes are populated the 2nd issue is when viewing the demographic info, everything looks good when I click and chose "visualize>chart nodes by attribute value" I get the proper numbers and % of age, language, job, education etc. BUT when I try to get info on COUNTRY the "other" category is full of 80 occurrences, this includes 11 references of "Malaysia" as well as references of Thailand and China (all spelt correctly, same format (text) same font, size etc.) This also happens with the RESIDENCE column which has cities and states listed and shows 147 instances of "OTHER" I've tried saving as different file formats checked the Excel file for variations but cannot locate the source of this error and find it very frustrating that NV can't distinguish these are the same words. The only other info I have uploaded to my project are 1700 images, after seeing the error above I deleted my data set and the subsequent nodes I got from auto coding for those 4 codeable fields listed above. I certainly don't want to upload ALL 1700 of them again since NV has no proper drag and drop and files have to be selected again & again using 'browse'(although losing days of work seems to be the norm with NV). I would really appreciate some advice or if someone could identify what the problem is or what I'm doing wrong here so I can proceed with figuring out this cumbersome program. As mentioned elsewhere on these forums the ability to edit datasets after import is crucial especially for a program designed to handle large sets of data which of course will turn up a few mistakes in the process and need correction without having to begin again from the start. Thanks! SURVEY DATA3.xlsx
  18. 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.
  19. 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 dataset, and nothing is created automatically, I have difficulties making the nodes, and somehow I made a classification instead of actually making a node. Some cells are white, some grey, I don't know which cells should be white and which ones should be grey. I don't know how to actually create my nodes automatically. Could you please help me with some steps I could follow, or tell me if what I am trying to achieve is actually doable in Nvivo? I would really appreciate your help. I might not have explained my issues very clearly, so do please tell me if I should explain myself better. Thank you ioana
  20. 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. I have an excel spreadsheet with my sources and the various attributes that I want to assign to each program. My spreadsheet has the first column as Institution, then each following column is an attribute (Type of Institution, College, Department, Type of Masters, Field Experience, Credit Requirement...). My problem is that some of the institutions offer multiple degrees, so under type of Masters there's actually 2 answers. Can I list the institution in Column 1 twice? How would that connect to my sources when I tried to import the spreadsheet? Is there a better way that I can do this? Thanks
  21. 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 to be appear (under Attribute Value) in NVivo using the appropriate education level not the number that was used in the spreadsheet. I can see that under New Attribute you can specify the Value, but I don't want the Value to be 1,2,3,4 or 5 - I want it to be 'Up to Year 10', 'Year 12' etc. Can I import the data as is (ie as numbers) and then change it to the 'descriptive' attribute value that I want to use in NVivo? Or do I have to make the changes in my original Excel spreadsheet? Many thanks Andrea
  22. 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 that ? Is there a way to get the « study number » (which is in column 1) as name of source for each reference even if all numbers are lines in the same excel sheet ? I hope you’ll understand me and thank you for your help. Sarah
  23. 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, Abby
  • Create New...

Important Information

Privacy Policy