Shopping cart
Your cart empty!
Select theme:
Your cart empty!
The Excel Raw Data export gives you direct access to your survey responses in spreadsheet form. It is especially useful when you want to work with the original dataset outside Enquete and examine responses in more detail.
This export is valuable for researchers because it allows you to review individual responses, understand how the dataset is structured, and prepare the results for deeper analysis in Excel, SPSS, or other data tools. It comes in handy when you want to clean data, validate answers, filter respondents, inspect coded variables, or share the raw results with another researcher or analyst.
To export the Excel Raw Data file:
The exported workbook contains several sheets. Each one helps you look at the data in a different way.
The Excel Raw Data export contains these sheets:
Together, these sheets give you both a summary view and a response-level view of the survey data.
This sheet gives you a summary of how answers are distributed for each question. It includes columns such as Question, Answer, Chosen, Total, and Percentage.
This is useful when you want a quick overview of the results without going through each respondent one by one. Researchers can use it to identify the most selected answers, compare response patterns, and review basic frequency distributions before moving into deeper analysis.
When using this sheet, pay attention to which answers were selected most often, whether responses are spread evenly or concentrated around a few options, and whether some answers were rarely chosen. It is often the best place to start when you want a fast summary of the data.
These two sheets work together and are especially important for researchers.
The B. Variable View sheet acts as a codebook for the dataset. It shows the variable name, its description, and the coded values used in the raw data. For example, it may show that a field like Q0001 belongs to a specific question, or that a value such as 1 means Yes and 0 means No.
This sheet is useful because it helps you understand how the survey data has been stored. Researchers use it to interpret variable names correctly, decode numeric values, and prepare the dataset for structured analysis.
The B. Data View sheet contains the actual response data in coded format. Each row represents one respondent, and each column represents one variable. The first columns usually contain respondent and technical information, such as respondent number, start date, finish date, completion status, browser, browser version, and operating system. The other columns contain the answers given in the survey.
This sheet is useful when you want to filter data, sort responses, build pivot tables, prepare data for SPSS, or run more technical analysis. Because the headers use coded variable names, this sheet is more analysis-ready, but it should be read together with the Variable View sheet so you can understand what each code means.
When reviewing these sheets, pay attention to coded values such as 0 and 1, blank cells, metadata columns, and question variables split into multiple columns for matrix or multiple-choice questions. These details are important for accurate interpretation.
This sheet also contains the response-level data, but in a more readable format. Each row still represents one respondent, but the columns use full question text and more readable labels instead of coded variable names.
This makes the sheet easier to understand for manual review. It is especially useful when you want to inspect responses without having to decode variable names first. Researchers can use it to validate the exported data, review open-ended answers, and cross-check the coded data shown in the other sheet.
This sheet is also helpful when sharing the file with colleagues or stakeholders who may not be familiar with coded research datasets. Instead of seeing short variable codes, they can read the question text more directly.
When using this sheet, pay attention to the full question wording in the headers, the readable answer values, and any open text or contact-related fields that are easier to interpret here than in the coded sheet.
