Facebook
Gmail
Slovenščina
Export to Excel
You activate the export of data to Excel in the 'DATA' - 'Export' - 'CSV' menu.
You can transfer the Excel file to your computer by clicking on the 'Export to CSV' option.
As with other exports, you can filter the data according to variables, statuses, conditions or time period, in the upper right-hand corner. You can also enable the export of paradata, identifiers, and system variables.
In the top right corner, there are also settings where you can further specify whether you want to export only system data, only data or data and metadata. When you select "Export only system data", only the system data of the respondent will be exported, without any other data. However, if you do not export the system data, you can export individual paradata of the respondent.
- How can I create a quick list of responses?
- How to edit answers within the data?
- What is the difference between a computed value and a computation?
- What is the limitation on the number of questions and respondents?
- Database data is demolished, values are not correct or there is no data.
- Where does free help end?
- Why is the question numbering not in consecutive order?
- How to properly methodologically set the answers 'Don’t know', 'Invalid', 'None of the above' and 'Refused'?
- How safe is it to store data on 1KA?
- Can I make changes to a survey after it has been activated and published?
- I am experiencing difficulties when exporting my data to SPSS
- How can I find a specific record in the data (respondents answers)?
- Is the survey saved if the respondent does not answer a certain question?
- What do negative values in the survey data mean and where can I set them?
- Export to Excel: Why does a warning window always pop up when I'm exporting the file to Excel?
- Why is it necessary to enable Javascript?
- Can I restore data I accidentally deleted?
- What kind of customer support does 1KA offer?
- How do I quote / cite the use of 1KA in my work?
- I am not sure if all units are included in the analysis
- How do I remove the test units from the data?
- How to obtain data on individual surveys from the summary (sums)?
- Is the data deleted from 1KA after I export it?
- Why are some of my data missing?
- What is the difference between coding and recoding?
- Why are the repondent's answers lost in case of 'step by step mode' with question type 'table' if respondent moves to the previous page?
- Why can't I select 'All units' when overviewing data?
- How do I delete the answers of one or more respondents from the data table?
- How is the tool tested?
- What about underage respondents?
- How do I change or update my browser?
- How do I clear my browser's cookies?
- Export to Excel: Why is the numeric variable exported as a 'string' or text?
- Why did several respondents from the same IP address fulfilled the survey?
- Viewing respondents' answers: how to view them in questionnaire form (instead of a table)?
- Are mobile surveys supported by 1KA?
- Export to Excel: Why are answers incomplete when I export the data to Excel?
- Can I export only a certain set of variables (and not all of them)?
- Can I exclude unfinished questionnaires from survey data?
- Manual coding
- Merging data
- Public URL to view data and analysis
- Granting access to helpdesk
- Data updates (file vs. database)
- Recommendations for minimizing non-response
- Adding data (append)
- 1KA registration and login
- Computed values
- Automatic coding
- Computations
- Recoding
- Measurement and time limitations for responses
- Export to text file
- Survey data, paradata, identifiers, and system variables
- Export to SPSS
- Your first survey
- Status of units, relevance, validity and missing values
- Insight into the respondents' answers
- Export to Excel
- Settings for exporting PDF/RTF files with responses