Clarisights provides multiple ways of importing CSV files -
Primary Data Sources - Custom Advertising (CADV), or POD
Secondary Data Source - Custom Analytics (CA)
Data can be uploaded into these sources, in any one of the following modes -
Ad-hoc CSV uploads
CSV attachment in e-mails
CSV through URL
CSV in Amazon S3 bucket
Google BigQuery table
In the case of Google Sheets and Google BigQuery table, Clarisights generates the CSV from these sources, so we are able to automatically ensure that the CSVs are compliant with the standard format.
However, in the rest of the modes, the system which is exporting the CSV and uploading it to Clarisights needs to ensure that the CSV is RFC-4180 compliant. Sending files that comply with RFC standards ensures that Clarisights can process these files without issues.
A few important points to note that will help your CSV be compliant with RFC -
The separator should be a comma and not a semicolon.
If even one field contains commas, then every field needs to be double-quoted.
A double-quote that appears inside a field must be preceded with another double quote.
If you'd like to validate your CSV to know whether it is RFC-compliant or not, we recommend using this tool - CSV Lint.
Now that you know which kinds of CSVs can be processed in Clarisights, learn more on how custom POD channels work.