Follow the steps to export table data:

1. Right-click the selected table and select Export Table Data.

   The Export Table Data dialog box is displayed with the following options:

   • Format - Table data can be exported either as excel (xlsx/xls), CSV, Text or binary format. By default Excel (xlsx) is selected.
   • Include Header - This option is available for CSV and Text files. If selected, it will include the column headers. By default, this option is selected when exporting to CSV or Text file, although it is not a mandatory field. This field will be disabled for excel (xlsx/xls) and binary format.
   • Quotes - Use this option to define the quote character. You should enter only single byte character for this field. Quote character should not be same as the delimiter. For CSV and Text format, by default this field is enabled, although it is not a mandatory field. This field will be disabled for excel (xlsx/xls) and binary format.
     • If table data value has delimiter in their values, then it will use the character mentioned in this field.
     • If the Quote character is present in value, then that character will be escaped with same quotation maks.
     • If the result contains multiline values, then it will be quoted with quotation maks.
   • Escape - Use this option to define the escape value. You should enter only single byte character for this field. Escape value should not be same as quote character. For CSV and Text format, by default this field is enabled, although it is not a mandatory field. This field will be disabled for excel (xlsx/xls) and binary format.
   • Replace NULL with - Use this option to replace null value in the table with string. New line or carriage return characters are non-acceptable values for this field. A maximum of 100 characters can be entered in this field. This field value must be different from the delimiter and quote values. For CSV and Text format, by default this field is enabled, although it is not a mandatory field. This field will be disabled for excel (xlsx/xls) and binary format.
   • Encoding - The Encoding field will be pre-populated with the encoding selection made in Preferences > Session Setting tab. This is not a mandatory field.
   • Delimiter - Use this option to define the delimiter. You can select from the available delimiter or set customized delimiter in the Other field in the Delimiter section. For CSV and Text format commas(,) will be the default delimiter. A maximum of 10 bytes can be entered in the Other field. For CSV and Text format, by default this field is enabled, although it is not a mandatory field. This field will be disabled for excel (xlsx/xls) and binary format. It is mandatory to enter a value when Other field is selected.
   • All Columns - Use this option to quickly select all columns. By default it is checked. To manually select columns, uncheck this and select columns from the Available Columns list.
     • Available Columns - You can use this column to select specific columns to export.
     • Selected Columns - This field displays the selected columns that will be exported. The columns can be re-ordered. By default all columns display in this field.
     

     Refer to Column/Row Size in FAQ for row and column size supported by xlsx and xls.

   • File Name - Use this option to specify the name to save the exported file. By default, the table name is displayed in this field.
     

     File name follows Windows file naming convention.

   • Output Path - Use this option to select the location to save the exported file. The Output Path field is auto-populated with the selected path.
   • Security Disclaimer - The security disclaimer is displayed, and you should read and agree, to continue with the export operation.
     • I Agree - By default this field is selected. You cannot proceed further if this field is not checked.
     • Do not show again - You can select this field to hide the Security Disclaimer for subsequent export table data operation for the current logged instance of Data Studio.
   

   • String, double, date, calendar, and boolean datatype will be stored as is in excel. All other datatypes will be converted into string and stored in excel.
   • For excel export if the cell size is beyond 32767, then exported cell data will be truncated.

2. Complete the required fields and click OK.

   The Save As dialog box is displayed.

3. Click Save to save the exported data in the selected format. The status bar displays the progress of the operation.

   The Data Exported Successfully dialog box and status bar displays the status of the completed operation.

   

   • If the disk is full while exporting the table, then Data Studio displays an I/O error. Perform the following operations to resolve this error:
     1. Click OK to close the connection profile.
     2. Clean the disk.
     3. Re-establish the connection and export the table data.
   • The exported file name will not be the same as table name, if the table name contains characters which are not supported by Windows.