CSV File Formatting

Currently, EverTrue only accepts CSV (comma-separated values) files. Tab or pipe delimited files are not accepted. 

File Formats

  • File must be CSV (comma-separated values)
    • See Comma Separated Values
    • We adopt the RFC 4180 standard
      • Fields containing line breaks, double quotes, and commas should be enclosed in double-quotes. 
      • If double-quotes are used to enclose fields, then a double-quote appearing inside a field must be escaped by preceding it with another double quote. 
  • File must use CRLF or LF newline EOL markers (unix standard or MS-DOS)
  • File must be UTF8 encoded.
    • Encoding a file is different for every database.  For most databases, it is possible to set the encoding of your file when you are exporting. It can be selected as a setting, along with the file type.  In other instances, this may require additional programming to set the encoding or manual tweaking after the fact.  Unfortunately, there are a few databases that do not allow this type of encoding, but most of the time it can be done post-export.
  • File can be compressed when using SFTP.  We support zip or gzip compression (.zip or .gz), and recommend compressing all files before uploading.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.