Excel sheet support


Daylight fully supports .csv and .tsv files. It also accepts .xlsx files but this is experimental so we can't guarantee data integrity.


Things to try:





No text data



It looks like Daylight cannot find a Text column in your file. Daylight needs unstructured text data to produce any meaningful analysis.


Things to try:

Add a column of unstructured text in your original dataset file and re-upload it to fix this issue.



Duplicate headers



Daylight will merge columns with the same header.


It might be helpful: If you have a survey question with a multiple answers, such as a checklist. The values for that question might be in different columns. If this is the case ignore the warning or dismiss it by clicking the ‘x’ on the warning box.

Pro tip: Convert vague values for multiple-choice questions to understandable values. E.g. if a question returns 1 for yes and 0 for no, search and replace the numbers with the words.


This might be an unhelpful if: One of those columns has redundant or extraneous data. Or if those columns are actually for separate questions.


Things to try:






No header



Each column requires a header, which will be the name of the filter field. Otherwise they are skipped.


If this is intentional:

Ignore this warning and dismiss it by clicking the 'X' on the warning box.


Otherwise:

Click on the pen icon above the warning and add a name to the header.



You can now use the dropdown to change the column from Skip to whichever is appropriate.






Invalid numbers



Daylight needs each item in a column to be a valid number if it is set to the Number data type. Whole or decimal numbers without any commas are valid e.g. 12, 14.6, 0.4, 200 etc.


If this is intentional:

Ignore this warning and dismiss it by clicking the 'X' on the warning box.


Otherwise, try:





Empty text rows



Daylight does not include any empty Text rows in its analysis. These rows will not be contributing to concept analysis.

If this is intentional: Ignore this warning and dismiss it by clicking the 'X' on the warning box.

Otherwise, try:




How helpful was this article?

Thank you for your feedback!