- Media library
- Question limits
- Creating a survey from MS Word doc
- How to edit live surveys
- Survey blocks
- Survey block randomizer
- Question randomization
- Scale Library
- What is monadic testing?
- What is sequential monadic testing?
- Extraction Support for Image Chooser Question Types
- What is comparison testing?
- Custom validation messages
- Survey Builder with QxBot
- Testing Send
- Survey Preview Options
- Standard question types
- Advanced question types
- Multiple choice question type
- Text question- comment box
- Matrix multi-point scales question type
- Rank order question
- Smiley-rating question
- Image question type
- Date and time question type
- CAPTCHA question type
- Net Promoter Score question type
- Van Westendorp's price sensitivity question
- Choice modelling questions
- Side-By-Side matrix question
- Homunculus question type
- Predictive answer options
- Presentation text questions
- Multiple choice: select one
- Multiple choice: select many
- Page timer
- Contact information question
- Matrix multi-select question
- Matrix spreadsheet question
- Closed card sorting question
- Flex Matrix
- Text Slider Question Type
- Graphical Rating Scales
- Rank Order - Drag and Drop
- Bipolar Matrix - Slider
- Bipolar Matrix Likert Scale
- Gabor Granger
- Verified Digital Signature
- Star Rating Question Type
- Push to social
- Attach Upload File Question
- Constant Sum Question
- Video Insights
- Platform connect
- Communities Recruitment
- TubePulse
- Open Card Sorting
- Map Question Type
- Answer type
- Reorder questions
- Question tips
- Text box next to question
- Text question settings
- Adding other option
- Matrix question settings
- Image rating question settings
- Scale options for numeric slider question
- Constant sum question settings
- Setting default answer option
- Exclusive option for multiple choice questions
- Validate question
- Bulk validation settings
- Remove validation message
- Question separators
- Question Code
- Page breaks in survey
- Survey introduction with acceptance checkbox
- RegEx Validation
- Question Library
- Embed Media
- Slider Start Position
- Answer Display - Alternate Flip
- Matrix - Auto Focus Mode
- Text validations
- Numeric Input Settings- Spreadsheet
- Answer Groups
- Hidden Questions
- Decimal Separator Currency Format
- Allow Multiple Files - Attache/Upload Question Type
- Text box - Keyboard input type
- Deep Dive
- Answer Display Order
- Alternate colors
- Add logo to survey
- Custom Themes
- Display Settings
- Auto-advance
- Progress bar
- Automatic question numbering option
- Enabling social network toolbar
- Browser Title
- Print or export to PDF, DOC
- Survey Navigation Buttons
- Accessible Theme
- Back and Exit Navigation Buttons
- Focus Mode
- Survey Layout
- Survey Layout - Visual
- Telly Integration
- Telly Integration
- Workspace URL
- Classic Layout
- Branching - Skip Logic
- Compound Branching
- Compound or delayed branching
- Response Based Quota Control
- Dynamic text or comment boxes
- Extraction logic
- Show or hide question logic
- Dynamic show or hide
- Scoring logic
- Net promoter scoring model
- Piping text
- Survey chaining
- Looping logic
- Branching to terminate survey
- Logic operators
- Selected N of M logic
- JavaScript Logic Syntax Reference
- Block Flow
- Block Looping
- Scoring Engine: Syntax Reference
- Always Extract and Never Extract Logic
- Matrix Extraction
- Locked Extraction
- Dynamic Custom Variable Update
- Advanced Randomization
- Custom Scripting Examples
- Survey settings
- Save & continue
- Anti Ballot Box Stuffing (ABBS) - disable multiple responses
- Deactivate survey
- Admin confirmation email
- Action alerts
- Survey timeout
- Finish options
- Spotlight report
- Print survey response
- Search and replace
- Survey Timer
- Allowing multiple respondents from the same device
- Text Input Size Settings
- Admin Confirmation Emails
- Survey Close Date
- Respondent Location Data
- Review Mode
- Review, Edit and Print Responses
- Geo coding
- Dynamic Progress Bar
- Response Quota
- Age Verification
- Tools - Survey Options
- Live survey URL
- Customize survey URL
- Create email invitation
- Personalizing emails
- Email invitation settings
- Email list filter
- Survey reminders
- Export batch
- Email status
- Spam index
- Send surveys via SMS
- Phone & paper
- Adding responses manually
- SMS Pricing
- Embedding Question In Email
- Deleting Email Lists
- Multilingual Survey Distribution
- SMTP
- Reply-To Email Address
- Domain Authentication
- Email Delivery Troubleshooting
- QR Code
- Survey Dashboard - Report
- Overall participant statistics
- Dropout analysis
- Pivot table
- Turf analysis
- Trend analysis
- Correlation analysis
- Survey comparison
- Gap analysis
- Mean calculation
- Weighted mean
- Spider chart
- Cluster Analysis
- Dashboard filter
- Datapad
- Download Options - Dashboard
- HotSpot analysis
- Heatmap analysis
- Weighted Rank Order
- Cross-Tabulation Grouping Answer Options
- A/B Testing in QuestionPro Surveys
- Data Quality
- Data Quality Terminates
- Matrix Heatmap Chart
- Column proportions test
- Response Identifier
- TURF Reach Analysis
- Bulk Edit System Variables
- Weighting and balancing
- Conjoint analysis designs
- Conjoint part worths calculation
- Conjoint calculations and methodology
- Conjoint attribute importance
- Conjoint profiles
- Market segmentation simulator
- Conjoint brand premium and price elasticity
- What is MaxDiff scaling
- MaxDiff settings
- Anchored MaxDiff Analysis [BETA Release]
- MaxDiff FAQ
- MaxDiff- Interpreting Results
- Automatic email report
- Data quality - Patterned responses
- Data quality - gibberish words
- Import external data
- Download center
- Consolidate report
- Delete survey data
- Data quality - All checkboxes selected
- Exporting data to Word or Powerpoint
- Scheduled reports
- Datapad
- Notification Group
- Unselected Checkbox Representation
- Merge Data 2.0
- Plagiarism Detection
- IP based location data
- SPSS Export
- SPSS variable name
- Update user details
- Update time zone
- Teams
- Add Users
- Usage dashboard
- Single user license
- License restrictions
- Troubleshooting login issues
- Software support package
- Welcome Email
- User Roles & Permissions
- Bulk Add Users
- Two-Factor Authentication
- Network Access
- Changing ownership of the survey
- Unable to access Chat support
- Navigating QuestionPro Products
- Agency Partnership Referral Program
- Response Limits
Matrix spreadsheet question
A matrix spreadsheet question is a group of open-ended text box questions under a specifically defined rows and columns. It is a matrix table like question with ability to give text inputs instead of radio button or check box selections.
Click to download video
How do I add a matrix spreadsheet type question?
Go to: Login » Surveys (select a survey) » Edit » Workspace
Click on the Add Question button.
Under Basic question types, from the Basic Matrix group, select the Spreadsheet question.
The matrix spreadsheet question will be added to your survey.
You can now add your question text, rows, columns, etc.
Respondents can now answer this question by entering data in each field.
What are the customization options for the matrix spreadsheet question?
Once you have added the spreadsheet question, you can:
- Add Rows
- Add Columns
- Add N/A option
- Edit or update rows and columns in bulk
- Enabled forced validation or request response validation
- Customize validation messages if required
- Under settings, you can also select and enforce numeric input for fields
What are the analytics and reporting options for the spreadsheet question?
Data and exports for the spreadsheet question types are available under Analytics.
Spreadsheet question data is not available on the dashboard of the survey. You can view the data under Analytics » Responses
Enable the toggle for display questions
You can also export data in raw data excel or csv format.
License
This feature is available with the following licenses :
You may also be interested in...
Matrix Settings
N/A - Not Applicable option for matrix questions
Matrix multi-point scales
Matrix multi-select questions
Matrix extraction
Side-by-side matrix
Matrix mobile rendering
Complex grid | Flex matrix
Side-By-Side Matrix - Select List Vs. Radio Buttons
Sub-section numbering for Matrix
