Shopping cart
Your cart empty!
Select theme:
Your cart empty!
The Excel (Adv.) export gives you a more detailed analysis workbook than the regular Excel raw data export. While the regular Excel export is mainly focused on the raw dataset, coded variables, and respondent-level answers, the advanced Excel export goes further by organizing the results into a report-style workbook with separate sheets for each question type.
This makes it especially useful when you want more than raw data. It comes in handy when you need a workbook that already presents the results in a structured analytical format, with key metrics, distributions, and question-based breakdowns. For researchers, this is useful because it reduces the amount of manual work needed to inspect patterns across different question types. Instead of only receiving the underlying data, you also receive question-by-question analysis in a way that is easier to review and share.
To export the advanced Excel file:
On your dashboard, select the survey you want to export.
Click the Export button.
From the list of export options, select Excel (Adv.).
The file will download to your computer.
Open the file on your local computer.
The workbook contains a summary area, a question overview, and then separate sheets for the individual questions in the survey.
The workbook begins with two important overview sheets and then includes separate sheets for the survey questions.
The Summary sheet gives you a quick high-level view of the entire survey export. It includes the survey title, the date and time the report was generated, the total number of responses, and the number of completed responses.
This sheet is useful when you want to confirm which survey the file belongs to and get an immediate sense of the response volume before looking at the detailed sheets. It works as the entry point to the workbook and gives context for the rest of the report.
The Questions Overview sheet gives you a structured list of all questions in the survey. It includes the question number, question text, question type, total answers, skipped responses, and skip percentage.
This sheet is very useful because it lets you quickly see how each question performed before opening the individual question sheets. Researchers and analysts can use it to identify questions with high skip rates, compare completion levels across question types, and understand the structure of the survey at a glance. It also helps you decide which questions may need closer review.
The remaining sheets each focus on a specific question in the survey and provide an analysis layout that matches that question type. In this workbook, those include sheets for multiple choice, open text, ranking, rating, matrix rating, matrix single choice, matrix multiple choice, matrix open text, contact form, and date questions.
Rather than presenting only raw responses, these sheets summarize the results in a more structured way. Depending on the question type, they may include key metrics, response distributions, score breakdowns, rankings, category analysis, or readable response listings. This means the advanced workbook gives you a broader analytical view across the whole survey, with each question separated into its own dedicated analysis space.
Because of this structure, the advanced export is especially useful when you want an Excel file that is already organized for review and interpretation, instead of one that only provides the raw dataset.
