Exporting View Data

Preview in Excel

If you want to quickly review the data in Excel and then discard it, you can use the Preview in Excel feature. On clicking  or Preview in Excel option, Visual Analytics opens an Excel file containing the data and saves the file in your system's temporary directory. On closing Aqua Data Studio, the temporary Excel file is deleted from your system.

• Click  or click the down arrow next to the icon (  ) and click Preview in Excel.

Export to Excel

1. On the Dimension pane, click . 
2. Alternatively, if you want to export summarized or underlying data of a particular data point, then hover your mouse on a data point, and then on the tooltip, click .
3. In the View Data window, click the down arrow next to the icon () and then Export to Excel.
   
4. Specify the export settings.
   
   • Choose to export the column headers and row count.
   • Choose to replace blank cells representing NULL data by "(null)" text. 
   • Choose to open the exported worksheet immediately after the export process completes.
5. Click Next, then browse and select a folder where you want to export the worksheet, type a name for the exported Excel file, and then click Export.

You can also export selected records to Excel. The process of exporting selected records is same as exporting complete view data. When in the View Data window, select the records you want to export to Excel. The Export to Excel dialog will display a message about highlighted cells exporting. 

Export to CSV

1. On the Dimension pane, click . 
2. Alternatively, if you want to export summarized or underlying data of a particular data point, then hover your mouse on a data point, and then on the tooltip, click .
3. In the View Data window, click the down arrow next to the icon () and then Export to CSV.
   
4. Specify export settings.
   
   • Choose a delimiter to separate the values in each row. 
   • Choose a string and date quoted identifier. The string and date quoted identifiers add quotes to string and date type values.
   • Choose an encoding and platform into which the file will be saved.
   • Choose to export the column headers and row count.
   • Choose to replace blank cells representing NULL data by "null" text. 
   • Choose to open the exported file immediately after the export process completes.
5. Click Next, then browse and select a folder where you want to export the file, type a name for the exported CSV file, and then click Export.