File Requirements
File Requirements
Section titled “File Requirements”Supported Formats
Section titled “Supported Formats”| Format | Extension | Notes |
|---|---|---|
| CSV | .csv | Comma-separated values, UTF-8 encoding recommended |
| Excel | .xlsx | Modern Excel format (2007+) |
| Excel (Legacy) | .xls | Older Excel format |
Data Structure
Section titled “Data Structure”Your file should have:
- Header row — Column names in the first row
- Response column — At least one column with text responses
- ID column (optional) — Respondent identifiers for tracking
Example data structure:
| UserID | Response | Age | Gender | Question |
|---|---|---|---|---|
| 001 | ”I love the new design” | 25 | F | ”What do you think about our new design?“ |
| 002 | ”Too expensive for what you get” | 34 | M | |
| 003 | ”Fast shipping was great” | 28 | F |
Excel Files with Multiple Sheets
Section titled “Excel Files with Multiple Sheets”When you upload an Excel file with multiple sheets:
- Each sheet is treated as a separate question
- The sheet name becomes the question identifier
- Results are generated per sheet
This is ideal for surveys with multiple open-ended questions — put each question’s responses in a separate sheet.
Predefined Codebook
Section titled “Predefined Codebook”You can include a predefined codebook in your Excel file to guide the analysis. This is useful when you have specific categories or themes you want to identify in the responses.
Another option is to set the codebook in the analysis settings.
How to use:
- Add two columns - one with codes and one with descriptions - to each sheet of your Excel file where you want to use a predefined codebook
- These columns can be in any position in the sheet, and the rows of the codes are independent of the response rows
- The AI will use these codes to categorize responses. Still it may add new codes if needed, unless “Freeze Codes” is enabled