Explorer: How To Export to CSV

Save the whole data, a subset of data or the analysis results to a CSV

Why export?

Surely you have your dataset saved somewhere other than Relevance AI. However, you might want to save the analysis results or a subset of your data; for instance, a category view. The export functionality on Relevance AI is customisable. You can save

  • the general overview alongside the metric results
  • a subset of your data with your desired fields, more importantly alongside their corresponding tags/labels
  • the whole dataset under all fields or your selected subset of fields

How to export to CSV

The export functionality is available on the category view. So make sure a category/cluster view tab/page is set up and selected.

Export the overview

πŸ“˜

This will only export the top-chart information as a CSV file.

To save the graphical view, right-click on the chart and use "save image as".

On a category view page, locate and click on the export icon on the top right.

Relevance AI - Explorer - Export the overview information

Relevance AI - Explorer - Export the overview information

A window will pop open representing the fields (metrics) that will be included in the download. Modify the list if needed, click on "Export data" and the information in the overview section will be downloaded as a CSV file to your device.

Relevance AI - Explorer - Export the overview information

Relevance AI - Explorer - Export the overview information

Export all categories together in one file

To export all dataset together in one file, simply click on the "Export" icon located under the overview section and to the right of the page (as shown in the image below). A window will pop open whose components are explained further down on this page, under "The export window components".

Relevance AI - Explorer - Export all data

Relevance AI - Explorer - Export all data

Export some categories together in one file

To export some categories together in one file, locate the category list access button on the left hand side, just below the overview bar.

Click on the icon and a list appears on the page including all the categories. Select the categories you wish to export as a CSV, then click on the export button marked with 3 in the following image. A window will pop open whose components are explained further down on this page, under "The export window components".

Relevance AI - Explorer - Export multiple categories

Relevance AI - Explorer - Export multiple categories

Export a single category/cluster

To export a single category, locate the category and use the settings on the top right. Click on "Export Category" and a window will pop open whose components are explained next.

Relevance AI - Explorer - Export a single category

Relevance AI - Explorer - Export a single category

The export window components

When the Export icon is clicked, the export window will open which is composed of four main sections:

Relevance AI - Explorer export window

Relevance AI - Explorer export window

  • Header where you can see how many categories are being exported (all or a number)
  • Data to export where you can select to export documents or the resulting metrics
  • Export type
    • Standard format: one column per field
    • Wide format: commonly used for AI Tagging results. In this format, when a tagging field is selected, there will be one column per tag. Values are True or False, indicating if the corresponding entry/document has been labelled with that tag or not.
  • Fields where you can add or remove fields to specify which fields from your dataset to be included in the export

When done with the setup, click on "Export data" and you will receive an email shortly after the export is completed. The link to your file is included in the email. Another way of accessing the results is to locate the export entry under History and use the download button.

πŸ“˜

Links are valid for three days

When a CSV export is generated, the link to the file is valid for 3 days. You will need to rerun the export workflow after the expiry period.