Spreadsheet - Survey
Analyze survey results with spreadsheets
Spreadsheet Survey module integrates survey analysis with spreadsheets, automatically creates analysis spreadsheet with ODOO.SURVEY formula for dynamic data.
Supports all question types including matrix and automatically creates columns based on survey configuration.
Analyze survey results
Create automatic analysis spreadsheet from survey results with one click.
Steps
1. Go to Survey → Surveys → select survey.
2. Click Analyze results.
3. System automatically creates spreadsheet with ODOO.SURVEY formula.
4. Spreadsheet displays survey data in real-time.
5. Create charts and pivot tables for analysis.
Interface terminology
| English | Description |
|---|---|
| Analyze results | Create survey analysis spreadsheet |
| Timestamp | Survey completion time |
| User | Survey respondent |
| Attempts | Number of survey attempts |
| Score (%) | Survey score (if quiz) |
| Quiz passed | Whether quiz passed |
Work with analysis spreadsheet
Analysis spreadsheet is automatically created with ODOO.SURVEY formula for dynamic data.
Key points
• ODOO.SURVEY formula automatically updates when new responses arrive.
• Columns are automatically created based on survey questions.
• Supports all question types: text, choice, multiple choice, matrix, date, datetime.
• Can create charts (Line, Bar, Pie) from survey data.
• Can create pivot tables for cross-analysis.
Data types in spreadsheet
Analysis spreadsheet displays different data types depending on survey configuration.
Key points
• Matrix questions are split into multiple columns (one column per row).
• Multiple choice questions display all selected choices.
• Date/datetime questions display in standard format.
Survey data columns
| Column | Meaning |
|---|---|
| Timestamp | Survey completion time |
| User | Respondent (if logged in) |
| Respondent email (if available) | |
| Attempts | Number of survey attempts |
| Score (%) | Score (if quiz) |
| Quiz passed | Whether quiz passed |
| [Question Title] | Answer for each question |
Practical tips
Key points
• Use Analyze results immediately after first response to track real-time.
• Create charts to visualize answer distribution.
• Use pivot tables for cross-analysis (e.g., score by department).
• Freeze & Share spreadsheet to archive results at specific time.
• Export Excel to share with people not using Odoo.
• Use filters to analyze specific respondent groups.