Upload a CSV File

The CSV format is one of the most common formats to export datasets. A CSV file can be opened on tools such as Excel that provides you with a table view of the data.

On this page, we explain how to upload a CSV file to the Relevance AI platform.

Prepare the Source File

There are special preprocessing that help improve your experience on Relevance AI's platform. For a CSV file, we categorize them under Field/column names and Values.

Field names

  • Unique​
  • Short but descriptive ​
  • Can only contain letters, numbers, dashes or underscores​

Values

  • All values have a header
  • All values under a column follow the same format
  • Recommended: For categorical fields (e.g. ”subscriber”), use labels (e.g. β€œno” / β€œyes”) instead of numeric codes (e.g. 0 / 1 )​
  • Recommended: Ensure any date fields are in β€œyyyy-mm-dd” format​
  • Recommended: If there is no values in a cell, make sure there is absolutely nothing typed in the cell (i.e. hit delete on the cell) instead of values such as white spaces, none, nil, NA

Dataset name

Upload the CSV file

Sign in to your Relevance AI account, go to the Datasets tab and click on "Create dataset".

Relevance AI - Upload a new dataset

Relevance AI - Upload a new dataset

A new page similar to the image below with open where you can select the datatype and proceed to upload. By default, CSV is selected. However, you can also

  • upload image files
  • upload audio files
  • upload pdf files
  • use sample datasets provided by the platform
  • automatically get review data from platforms like AppStore
Relevance AI - Upload a new dataset

Relevance AI - Upload a new dataset

Drag and drop your file(s), type a name for your dataset and hit Next. If you do not type a name for your dataset, the file name is used as the dataset name.

Relevance AI - Upload a new dataset from a CSV file

Relevance AI - Upload a new dataset from a CSV file

For CSV files, if the file is under the accepted format, a table view of the data will be displayed on the page and the "Upload" button will be activated. Click on the "Upload" to continue or use "Cancel upload" if you need to modify your source CSV file.

Relevance AI - Upload a new dataset from a CSV file

Relevance AI - Upload a new dataset from a CSV file

Upload time depends on the dataset size but it is normally less than 10 seconds and you will be directed to the dataset when the upload is completed.

Handling upload errors

If the CSV file is not in the correct format or not following the required conventions, the platform will provide you with an explanation of the issue. Below is one sample:

Value type error

The following error usually appears when updating a dataset. Imagine an existing dataset contains a field X with only digit or float values. If you try to add entries to the dataset but include any string values under field X in your CSV file, you will be notified of formatting type issue.

Solution is to update the file and keep the data format the same across the dataset.

Relevance AI - Sample of value type error

Relevance AI - Sample of value type error