<< Click to Display Table of Contents >> Navigation:  Reference Manual > Windows and dialog boxes > Data > Export data to CSV/Excel/TXT

This is used to create a data list from a data file.

Notes for CL users.

From the CL window it uses the data in the internal files (IDF).

CL variables are called entries in Companion.

CL Items in svars and mvars are called responses in Companion.

You can choose which entries are output and how they are output.

Load export details

You can load an existing export details XML file which was saved earlier.  This will restore all the information about the export.

Apply a filter

If a filter is applied then only records that pass the filter will be exported.

The number of records to be exported is shown,

You can use the button or type a new definition in the box below.  The display includes an icon to show whether the definition is valid or not.

Important: Those familiar with CL filter definitions should note that in Companion:

Repeated references to the same variable need to repeat the variable name

The dollar sign is not needed before entry names

CL:

$q1/1.3

Companion

q1/1.q1/3

Choose output type

This opens Data export type to change file type and the the format of the output.  The box below shows the selected type.

Changing the type will reset the output type for all entries.

Save export details

This saves all the current settings and the selected list of entries to the XML file chosen.

Central display

This lists all the entries selected to be exported (listed).

Against each entry with responses the type of export is shown.

Individual entries export type can be changed by selecting them here and using the buttons on the right.

Remove selected

Any entries selected in the list will be removed from the list and will not be exported.

Add selected

This opens the Entries choose dialog so that you can choose the entries to be added to the list to be exported.

The list shown will be all the entries in the project that are not already on the list to be exported.

Responses as

Any selected entries in the list which have a list of responses (single-coded or multi-coded) will have their output changed to the type for the button:

[Text]

[Value]

Only relevant selected entries will be changed, other entries to be exported are not changed.

Multi-coded as

Any selected entries in the list which are multi-coded will have their output changed to the type for the button:

[Single]

[Every]

[Spread]

Only relevant selected entries will be changed, other entries to be exported are not changed.

Export now

This will export all the entries on the list as requested.

If [CSV display] is used, the exported data will be displayed in CSV data display.

For other types, the exported data will be stored in a file of the type requested and this file will then be opened by the default program for that type of file to view the exported data.

Cancel

You can save the settings you have made with the [Save export details] button before cancel if you will need  those settings again.