-
If the export of your survey's raw data has nonsense characters it's likely because your survey data is in a language that uses special characters like accents, tildes and such. Fortunately, it's easy to fix this!
-
If you're working in SPSS, but prefer Alchemer's CSV export settings, here is a way to open a CSV in SPSS for analysis.
-
Leading zeroes can be removed if you have auto-formatting turned on in Excel. This feature will try to do you a favor by recognizing data and applying an applicable format.
-
This can happen if you have auto-formatting turned on in Excel. This feature will try to do you a favor by recognizing data and applying an applicable format. For example, any numeric compatible with a MM-DD or MM-DD-YYYY format will show as a date. If Excel has made some assumptions that do not apply to your data you can fix this up easily!
-
By default, Checkbox and Image Select (multi select) questions export with multiple columns; one column for each answer option of the question. You can change this for your CSV/Excel Exports.
-
If you're looking at your responses and the time-stamp for looks incorrect, you probably just need to adjust your account time zone.