For a successful import of your audience from a CSV file, please follow these recommendations while creating your file before uploading it to your Retently account:
1. Make sure that it is a CSV format file (with the .csv extension). Other file types, such as Excel are not supported. If however you have your customers stored in a .xls file, open it in Microsoft Excel or Google Spreadsheets and export it as a CSV file.
2. It is mandatory to have a column with your customers' email addresses. Also make sure these addresses have a valid email structure (firstname.lastname@example.org).
3. It is highly recommended (although optional) to include in the file a few other columns for First Name, Last Name, or Company. Retently provides a list with default customer properties, such as Country or Job Tile, but you can also create custom properties for other types of data, for instance your customers' signup date.
4. It is recommended to name your columns in the first row of your file. This will help our system automatically identify the right labels for your columns (ex: First Name, Last Name, Email, Company)
5. Make sure that your CSV file is encoded in UTF-8 characters encoding.
6. In a CSV file (Comma-separated values), the columns are usually separated by comma ",". Retently recognizes the majority of separators, but to make sure that the file is uploaded and processed successfully, it is recommended to use either the comma or semicolon separators.
Also read: How to import a CSV list with customers?