Export

The Export function allows to export any view type (i.e., Worksheets, Charts, Gauges, Maps and Dashboards) in various file formats in order to utilize and manipulate your data in different ways.

Nectari supports the following export formats—PDF, XLSX, XLS, CSV, HTML, XML, and PNG (for charts and dashboards only).

To export a view:

  1. Click the button in the Settings menu (right panel) and select Export.

  2. In the drop-down list, choose the desired format and click Confirm.

  3. A new window is displayed once the file is exported. Click Download. By default, the file will be saved in your OS Download folder and will have the same name as the view.

Expanding Data in Excel

When exporting a Worksheet to XLS or XLSX format, Nectari allows you to expand its content in Excel.

By default, the Total Row is the first group level that is expanded. That means that if there are three group levels expanded, there would be four levels of indentation rather than three.

Important

You must expand group levels in Nectari in order for them to appear that way in Excel exports. Expanding the group levels gives you more control over the level of detail that is displayed.

There is a maximum of 6 expanded group levels supported (not including the Total Row). If more than 6 group levels are expanded in your Worksheet when you export to XLS or XLSX format, none of the group levels will be expanded in your output file.

  1. Open a Worksheet and expand the desired group levels. In the example below, three groups levels have been expanded.

  1. In the Settings menu (right panel), click on and select Export.
  2. From the drop-down list, select XLS or XLSX and click Confirm.

  3. A new window is displayed once the file has been exported. Click Download. By default, the file will be saved in your OS Download folder and will have the same name as the view.

  1. Open your file in Excel.

  2. Click the + button on the left-side panel to expand a group level and the - button to collapse one.

Note

The numbers in the upper left-hand corner depict the worksheet's current level of indentation.