Exporting query results to a .CSV file Edit on GitHub Request doc changes

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.

Steps
  1. Log in to your Cloud Insights tenant.

  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.

  5. When prompted, do one of the following:

    1. Click Open with and then OK to open the file with Microsoft Excel and save the file to a specific location.

    2. Click Save file and then OK to save the file to your Downloads folder.

All of the attributes for the objects in the columns currently selected for display are exported to the file, regardless of whether those attributes are being displayed.

When exporting query results, be aware that all rows in the results table will be exported, not just those selected or displayed on the screen, up to a maximum of 10,000 rows.

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.