Export Data

 

Top  Previous  Next

Before you can export data, you must have downloaded the data from the server (or from CAPI files) and accumulated the data.

 

Click File | Data Management and the Data Management dialog is displayed.  This dialog offers three tabs:

 

Get Data

Export Data

View/Edit Data

 

Select the Export Data tab.

 

Within the Export Data tab, you create Jobs to export.  Each export job may contain a single or multiple files to export.  For example, you may want to export your data to both a .csv and an SPSS data file.  As another example, you may need to export the data in a different manner for different clients.  You can create and save a different job for each client.  The settings for each job are saved in your project, so you can always go back to a job and repeat the export.

 

You can export the data from your Internet questionnaire to one of the following files:

 

Comma Delimited (.csv) (Supported by Microsoft Excel)

This file can be directly opened with Microsoft Excel(TM).  It is a comma-delimited text file, where the first line includes variable labels.

 

Export Labels File.  If you are using Sawtooth Software's online analysis tool, you should export a labels file.  Note that this will slow down the export process.

 

Microsoft Excel 2002- 2003 (.xls)

We suggest this format when using Excel 2002 or 2003 (limited to no more than 256 columns), especially if you are exporting open-end responses that have been typed using double-byte character sets.  The file is saved with a .xls extension.

 

Microsoft Excel 2007 (.xml)

This file format can support up to 16,384 columns.  We suggest this format when using Excel 2007 or later, especially if you are exporting open-end responses that have been typed using double-byte character sets.  The file is saved with an .xml extension.

 

SPSS (.sav)

This file can be directly opened with SPSS.  It is a binary file.

 

Fixed-Width Text (.tab and .lay)

The .tab file is a fixed column text file.  This file can be read by most any statistical processing or cross-tab package.  The layout for the .tab file is included in the .lay file, which is also a text file.  The .lay file specifies the variable names and in which column in the .tab file each variable begins and ends.

 

A default name and path is provided in the Output Filename: field.  You can directly edit the name.  By clicking the browse button, you can specify the folder in which you wish to save the file.

 

Page link: http://www.sawtoothsoftware.com/help/lighthouse-studio/manual/index.html?hid_web_expall.html