Importing Excel spreadsheets or CSV files

DataCracker 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 DataCracker 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 DataCracker 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.

Feedback and Knowledge Base