Importing Excel spreadsheets or CSV files
Displayr can import Excel spreadsheets as .xls or .xlsx files.
- Only the first worksheet (tab) will be imported.
- The first row's cells should contain the survey question names.
- Second and following rows should contain the survey responses.
- Multiple response questions should be stored in a binary format, with one variable for each option in the question.
For example:
|
Gender |
Age |
Would you recommend us to a friend? |
|
Male |
32 |
Yes |
|
Female |
26 |
Yes |
|
Female |
29 |
No |
|
Male |
45 |
No |
Excel files lack a lot of the important metadata that Displayr uses to interpret the data, and so additional setup may be needed after importing the data file.
If your categorical questions are stored with the labels for each respondent, then this may begin as Text in Displayr and will need to be converted by changing the Structure to Percentages in the Data Manipulation section. If the categorical question is stored with numeric values for each respondent instead of labels it may begin being shown as Averages (the data is being interpreted numerically rather than categorically) and you can make the same change to show the percentages in each category instead. In this case you will also need to assign category labels in the table by selecting the row in the table and then clicking the Rename option in the Rows/Columns section of Data Manipulation.
For more details on formatting Excel and CSV files, see Excel and CSV Data File Specifications from the Q Wiki.