Create lists by uploading records in comma-separated value (.csv) format. Format the data that you want to comply with .csv syntax encoded in UTF-8 before uploading or appending it to a list:

• Each record is one line terminated by a line feed (LF) or carriage return line feed (CRLF) pair.
• Column names cannot contain special characters, such as a backslash. (\).
• Use commas to delimit data items, known as fields.
• The first line must be a header row of field names separated by commas.
• Enclose fields that contain spaces or commas in double quotes.
• Enclose a string that contains leading or trailing spaces in double quotes.
• If a field is empty, insert a comma at that position in the record.
• Enclose fields that contain commas inside a pair of double quote characters. For example, “firstname,lastname”,”phonenumber”,”address”.
• If a field contains double quotes, enclose the entire field in double quotes and convert each double quote character to two double quote characters.
• Important Note: The .csv file must not include any blank rows at the end of the data, which can cause an import failure.

Required columns

At minimum, a .csv file must contain one column of telephone numbers. For example, a single column for a Do Not Contact list might look like this:

Define all the columns required for your .csv file, such as contact name, and account code. When you upload the .csv file to create a new list, the system creates a table with matching columns in the cloud. After this table is created, you cannot append data that contains a different set of columns. 

Do not exceed 50 columns

The maximum number of columns allowed in a contact list is 50. An error message appears if this new contact list exceeds that limit, but an entry does not appear for it in the Event Viewer.

Column names must be unique

All column names in the first row must be unique. If you duplicate a column name, the file does not import.

Include a unique identifier column

Include a column in the .csv file that uniquely identifies each row. This ensures that you can accurately append new or updated data in the future. Typical unique identifiers are a customer’s ID or account number. Later, when you append records to your contact list, select your Unique Identifier column. Using that column, the append process can most accurately match incoming data against existing contacts.

Without a unique identifier the entire row is the primary key. If you append a modified record, a subsequent upload appends that record as a new row, even if an existing row has the same identifier. This behavior is not what people expect when they export a list, change it, and then append and upload their data. When you use a unique identifier, the system replaces the existing record instead.

Use zone columns

Contact list records often store multiple phone numbers per contact, such as work, cell, and home numbers. To use the callable times feature, each phone number column must have a corresponding time zone name column which contains the name you previously configured for callable time entries in the contactable time set in Genesys Cloud. For example, a column named Home Time Zone to contain the time zone name corresponding to each number in the Home Phone column. Note that zone columns are not used in Do Not Contact lists.

• As a best practice, specify both a unique Id and a time zone name column corresponding to each phone number column–for example, home or work–when you create a contact list.
• You cannot add time zone name columns later, but you can populate or update existing zone name columns by appending–uploading–records that have the same unique ID. When Genesys Cloud finds a matching row, it updates columns using data in the append file. For example, the system updates any zone name columns in a record with time zone data read from the .csv file. The zone name columns must exist.
• Associate each time zone name column with a contact number column when you create a list. You can also edit the contact list later, and map its time zone columns to phone number columns by selecting from the time zone column list.

Do not remove leading and trailing white space

When you save a contact list, the leading and trailing white space is removed from the contact field of the contact list. If you do not want to remove the white space from your contact list, switch the Trim leading/trailing white space toggle to No.

Use a spreadsheet program to edit .csv files

We recommend that you save in .csv format from a spreadsheet program, not a text editor. When the spreadsheet saves a .csv file, it inserts needed quotes and commas automatically. Using a spreadsheet is less error prone than formatting records manually.

For example, the File > Save As > CSV (Comma Delimited) command in Microsoft Excel generates the following .csv records: