Export to Excel
You activate the export of data to Excel in the tab 'DATA' - 'Export' - 'CSV' or in the tab 'DATA' - 'Export' - 'Excel (xls)'. Data export is only available to 2KA and 3KA private package users.
You can transfer the Excel file to your computer by clicking on the 'Export to CSV' or 'Export to Excel' options.
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 the individual paradata of the respondent.
- Viewing Respondents’ Answers: How to View Them in Questionnaire Form (Instead of a Table)?
- Is the Survey Saved if the Respondent Does Not Answer a Certain Question?
- Why Is It Necessary to Enable Javascript?
- Why Are Some of My Data Missing?
- Export to Excel: Why Is the Numeric Variable Exported as a ‘String’ or Text?
- I Am Experiencing Difficulties When Exporting My Data to SPSS Syntax
- Export to Excel: Why Does a Warning Window Always Pop up When I’m Exporting the File to Excel?
- How to Properly Methodologically Set the Answers ‘Don’t Know’, ‘Invalid’, ‘None of the Above’ and ‘Refused’?
- What Is the Difference Between Coding and Recoding?
- Where Does Free Help End?
- How Is the Tool Tested?
- How Do I Clear My Browser’s Cookies?
- How to Obtain Data on Individual Surveys From the Summary (Sums)?
- What About Underage Respondents?
- How Can I Create a Quick List of Responses?
- What Is the Limitation on the Number of Questions and Respondents?
- 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?
- I Am Not Sure if All Units Are Included in the Analysis
- Is the Data Deleted From 1KA After I Export It?
- Are Mobile Surveys Supported by 1KA?
- How Do I Delete the Answers of One or More Respondents From the Data Table?
- How Do I Quote / Cite the Use of 1KA in My Work?
- What Do Negative Values in the Survey Data Mean and Where Can I Set Them?
- Why Is the Question Numbering Not in Consecutive Order?
- Can I Restore Data I Accidentally Deleted?
- How Do I Change or Update My Browser?
- What Kind of Customer Support Does 1KA Offer?
- What Is the Difference Between a Computed Value and a Computation?
- How Can I Find a Specific Record in the Data (Respondents Answers)?
- How Do I Delete Data and Test Units After Testing?
- How to Edit Answers Within the Data?
- Why Can’t I Select ‘All Units’ When Overviewing Data?
- Export to Excel: Why Are Answers Incomplete When I Export the Data to Excel?
- Can I Make Changes to a Survey After It Has Been Activated and Published?
- How Safe Is It to Store Data on 1KA?
- Database Data Is Demolished, Values Are Not Correct or There Is No Data.
- Can I Export Only a Certain Set of Variables (And Not All of Them)?
- Why Did Several Respondents From the Same IP Address Completed the Survey?
- Can I Exclude Unfinished Questionnaires From Survey Data?
- Computations
- Manual Coding
- Export to Text File
- Recommendations for Minimizing Non-response
- Export to Excel
- Data Updates (File vs. Database)
- Insight Into the Respondents’ Answers
- Merging Data
- Automatic Coding
- Your First Survey
- Measurement and Time Limitations for Responses
- Settings for Exporting PDF/RTF Files With Responses
- Public URL to View Data and Analysis
- Export to SPSS
- Granting Access to Helpdesk
- Adding Data (Append)
- Status of Units, Relevance, Validity and Missing Values
- Recoding
- Survey Data, Paradata, Identifiers, and System Variables
- Computed Values
- 1KA Registration and Login