Skip to main content
Cloud Insights

Exporting query results to a .CSV file

Contributors netapp-alavoie

You can export the results of any query to a .CSV file, which will allow you to analyze the data or import it into another application.

  1. Log in to Cloud Insights.

  2. Click Queries and select Show all queries.

    The Queries page is displayed.

  3. Click a query.

  4. Click Export Button to export the query results to a .CSV file.

Note Export to .CSV is also available in the "three dots" menu in dashboard table widgets as well as most landing page tables.

The exported data will reflect the current filtering, columns, and column names displayed.

Note: When a comma appears in an asset name, the export encloses the name in quotes, preserving the asset name and the proper .csv format.

When opening an exported .CSV file with Excel, if you have an object name or other field that is in the format NN:NN (two digits followed by a colon followed by two more digits), Excel will sometimes interpret that name as a Time format, instead of Text format. This can result in Excel displaying incorrect values in those columns. For example, an object named "81:45" would show in Excel as "81:45:00".

To work around this, import the .CSV into Excel using the following steps:

  1. Open a new sheet in Excel.

  2. On the "Data" tab, choose "From Text".

  3. Locate the desired .CSV file and click "Import".

  4. In the Import wizard, choose "Delimited" and click Next.

  5. Choose "Comma" for the delimiter and click Next.

  6. Select the desired columns and choose "Text" for the column data format.

  7. Click Finish.

    Your objects should show in Excel in the proper format.