Exporting a Report to Excel Using Rapid Results

Authoring can export the results of your survey to Excel.

Note: Microsoft Excel 2003 is required to view exports from Rapid Results.

1. Scroll through the report and check the Mark for follow-up checkbox for those questions that you wish to export to Excel - .



Figure 1 - The Mark for follow up checkbox

2. In the Rapid Results menu bar, click Send to Excel.

The Send to Excel window opens - .

Note: You can click the button before you have selected the questions, and select them in the Send to Excel window.



Figure 2 - The Send to Excel window

The questions in the survey are listed in the Available Questions column, while any questions already selected by checking the Mark for followup boxes will be moved to the Selected Questions column. You can now edit your selection.

Note: Rapid Results has a time limit when exporting. If you must export a large number of questions, a message may appear to inform you that the export function has timed-out and not all of the questions have been exported. If this occurs, divide the export job into smaller batches.

3. Using standard Windows techniques, select in the left column any additional questions for which you wish to export the results.
4. Click the >> button to move the selected result sets to the right column.

If you move a result set to the right column in error, select it and click the << button to return it to the left column.

In each column, click All to select all the questions, None to deselect all.

Note: The result sets will be exported to Excel in the order in which they are moved into the right column.

If a value is specified in the Significance Testing field on the Report Settings page (go to Reportal Reports Overview for more information), then an "Include significance testing" checkbox is displayed in the question selection page below the "Display all questions ..." checkbox. Select the "Include..." checkbox to include the significance testing data in the report.

5. Click Send to Excel.

The Excel file is created and the result tables imported. On completion, the File Download dialog opens - .



Figure 3 - The Export Response Data overlay

6. Click Open to start Excel and view the results, or Save to open a standard Save As dialog box and then save the .xls file.
7. Click Back to report to close the Export Report window and return to the report.