Empty cells after exporting to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1338948%22%20slang%3D%22en-US%22%3EEmpty%20cells%20after%20exporting%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1338948%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20createad%20a%20survey%20form%20which%20included%20a%20question%20where%20students%20had%20to%20rate%20an%20item%20on%20a%207-step%20likert%20scale.%20So%20I%20created%207%20empty%20bullets%20and%20the%20could%20select%20the%20one%20of%20there%20preference.%20Above%20the%20one%20most%20to%20the%20left%20I%20placed%20the%20word%20'never'.%20Above%20the%204th%20I%20place%20'Every%20now%20and%20then'.%20And%20above%20the%207th%20I%20placed%20'Always'.%20After%20exporting%20to%20Excel%20I%20found%20out%20only%20the%20bullets%20underneath%20the%20words%20were%20transformed%20into%20those%20words.%20When%20a%20student%20had%20picked%20bullet%202%2C%203%2C%205%2C%20or%206%2C%20an%20empty%20cell%20was%20returned.%20So%20I%20have%20not%20all%20the%20info%20I%20need.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20checked%20the%20first%20300%20respondents%20manually%20and%20thus%20I%20was%20able%20to%20reconstruct%20there%20answers%20in%20my%20Excel%20sheet.%20For%20every%20later%20respondent%20I%20can%20only%20see%20there%20responses%20in%20Excel%2C%20which%20makes%20me%20returning%20to%20my%20first%20problem.%3C%2FP%3E%3CP%3EI%20tried%20to%20delete%20the%20form%20of%20respondent%201.%20But%20still%20then%20I%20can%20only%20see%20forms%201%20to%20299.%20Nr.%20300%20doesn't%20excist%20anymore.%26nbsp%3B%3C%2FP%3E%3CP%3EWho%20can%20help%20me%20with%20this%3F%3CBR%20%2F%3E%3CBR%20%2F%3EKind%20regards%2C%3CBR%20%2F%3EJeroen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1338948%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi there,

 

I createad a survey form which included a question where students had to rate an item on a 7-step likert scale. So I created 7 empty bullets and the could select the one of there preference. Above the one most to the left I placed the word 'never'. Above the 4th I place 'Every now and then'. And above the 7th I placed 'Always'. After exporting to Excel I found out only the bullets underneath the words were transformed into those words. When a student had picked bullet 2, 3, 5, or 6, an empty cell was returned. So I have not all the info I need. 

I checked the first 300 respondents manually and thus I was able to reconstruct there answers in my Excel sheet. For every later respondent I can only see there responses in Excel, which makes me returning to my first problem.

I tried to delete the form of respondent 1. But still then I can only see forms 1 to 299. Nr. 300 doesn't excist anymore. 

Who can help me with this?

Kind regards,
Jeroen

0 Replies