I’ve been noticing something odd with the way Survey Gold exports a dataset into Excel and SPSS formats. I perform both exports for my surveys.
If I perform SPSS export ahead of Excel then everything is all right. But should I happen to perform an Excel export prior to an SPSS export for any survey (not necessarily for same dataset), then all succeeding SPSS exports are messed up. The difference is that the first row in Excel dataset, i.e. the row headers, are then included in the SPSS dataset as the first data record. This is so odd.
For your reference I have attached an Excel dataset and 2 versions of its corresponding SPSS dataset. “SPSS dataset1.sav” was downloaded ahead of Excel. I repeated the SPSS download (SPSS dataset2.sav) after the Excel conversion so you can see what I mean.
Could you please look into it? (Grace Perez)