Skip to main content
All CollectionsDataFAQs and troubleshooting
Common issues impacting data uploads
Common issues impacting data uploads

Learn about the common reasons a data set may fail to upload correctly and how to resolve the issues.

Trish Pencarska avatar
Written by Trish Pencarska
Updated over 7 months ago

Relative Insight will automatically detect the file type you are uploading. However, occasionally there might be a discrepancy between what is uploaded and what is expected by the platform.

The table below shows the most common upload issues and how to easily fix them.

Common upload issues and recommended fixes

Issue

Fix

The file is shown with a status of 'Processing'

This indicates the data remains in the queue to be processed. When this occurs all you have to do is wait. Please do not attempt to upload the data again.

Missing column headers/titles

Column headers are used to confirm the format of a data set. Check that all columns in your uploaded file have been properly titled.

Extra header rows

Each column should contain a single header (typically in row 1 of the spreadsheet). Remove any additional or empty header rows from your spreadsheet before uploading.

No text column is included in the imported file

Relative Insight needs text to perform its analysis. Ensure at least one column is classified as text. If using the Relative Insight generic spreadsheet format, ensure the file includes a column titled 'text'.

Too many columns in a file

When a data set contains a very large number of columns, it may fail on upload. Open the spreadsheet, remove any unnecessary columns, save, and try again.

Data spread across multiple tabs with overlapping column headers

Make it easier for the platform to understand your data file by consolidating data onto one tab and removing duplicate headers.

.csv or .txt file not saved in UTF-8 format

There are several different file encoding formats that determine how characters in a file are stored. UTF-8 is the most common way format as it covers the most common character sets and emojis. This can be selected when adjusting file format before saving a file.

Unsupported file format

File types including .docx, .rtf, .xlsm, xls, .pdf are not supported and must be converted into .csv, .xlsx or .txt prior to upload (dependent on the parser you have chosen).

The file shows a word count of zero

This is likely a result of cleaning options being enabled. Simply disable the cleaning options and try again.

Did this answer your question?