Create, Collect, and Analyze Surveys and Web Forms
Microsoft Excel Files
Survey responses are sometimes kept in Microsoft Excel spread sheets. This data must be converted so it can be imported into the WISCO Survey software. The Excel spread sheet may contain extra rows and columns with calculations that are not part of the original survey responses so they need to be removed from the imported information.
We have seen numerous examples of improperly formatted CSV files created by Microsoft Excel. Improperly formatted files can not be imported successfully into WISCO Survey. As one example, Microsoft Excel does not remove extra carriage returns when saving data as a CSV file. Properly formatted CSV files can not contain carriage returns in the middle of a data record. Only one carriage return is allowed per record, and that must be at the end of the record.
Survey Monkey adds non-printable characters in the first 8 or 9 cells of the second row - the ones with the question choices. Some CSV specific software refuses to read a CSV file saved by Excel. Change these cells in Excel to a space character, saving the Excel file with a different name without these null characters.
Resaving the Microsoft Excel file to a different name removes excess hidden Excel metadata in the original file. For example, one Excel file was originally 306 KB. Resaving with a new filename removed the Excel metadata, and shrank the file size to 282 KB.