Jump to content

Search the Community

Showing results for tags 'excel'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Ask a question or report a problem
    • NVivo for Mac
    • NVivo 10 for Windows and NVivo 9 for Windows
    • NVivo 11 for Windows
  • Make a suggestion
    • NVivo for Mac
    • NVivo for Windows
  • NVivo 10 for Mac Beta


  • Community Calendar

Found 18 results

  1. 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!
  2. 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
  3. 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!

    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?
  5. 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!
  6. 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!
  7. 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?
  8. 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
  9. 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
  10. 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!
  11. 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.
  12. 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
  13. 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.
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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