When you open a survey in Excel, the text and format of the spreadsheet are locked. You must use the spreadsheet that  Iasta SmartSource exported because some fields are protected and it provides the correct question format. Do not unlock and modify these elements of the spreadsheet or you will not be able to import the spreadsheet back into Iasta SmartSource. Follow these rules when editing survey response in Excel:

• Use the Excel file produced by exporting the survey from Iasta SmartSource.
• Do NOT change tab names in the exported Excel file. The tab names link to the appropriate survey sections.
• Do not add or remove worksheets (tabs), columns, or cells.
• The cells in exported spreadsheets are color-coded to facilitate data entry. Yellow cells are required, you must enter information to submit your response. Blue cells are for optional comments. You may enter data in them but they are not required. Black cells contain statements made by the survey owner. No responses are required.
• You cannot embed or attach files within the Excel file. If you want to attach a file, you must do it manually after importing your response from Excel back into Iasta SmartSource. See Attaching a File to a Survey for more information.
• Do not use special characters. They cannot be imported. Only normal keyboard characters should be typed in the responses.
• Text formatting and pasted images will not import.
• All answers must be in one Excel file. Do not use multiple versions of the exported file with different sections completed. If you import a file with section 1 completed and then import a second file with only section 2 completed, any questions left blank on the second file will import blank answers, overwriting the previously imported answers to section 1.
• Importing overwrites any editing done online via the Iasta SmartSource Portal's Survey Editor. Responses are overwritten even if the cells in the imported spreadsheet are empty. The empty cells will overwrite any previously entered answers.

NOTE: Since Excel does not support attachments, you must upload any attached files to the survey directly on the Iasta SmartSource Portal Site. See Attaching a File to a Survey Answer for more information.

»To edit a survey in Excel

1. Launch Excel and open the file you exported. Each section or "page" in the survey is in a separate worksheet. Each each table question is also in its own worksheet.
2. Complete all required (yellow) cells in the answer column, and add optional comments in the Comment (blue) cells. A table question will contain a "Sheet for Question x.x," link. Click the link to open the worksheet for that table question. Black cells are statements that require no response.

3. The respondent selects File > Save to save changes.

Related Topics

The Respondent Process (Portal)

Exporting a Survey (Portal)

Importing a Survey (Portal)

Attaching a File to a Survey Answer