Wix Contacts: Troubleshooting Contact Importing Issues

Keep the following in mind when setting up your import file:

Note about the supported value separators and escape characters:

Tip: We recommend you  download a sample CSV file to learn more about how your file should look.

If you've added your contact's phone number and email address to the CSV file but still receive this error, you should verify that the email address is in the correct format: email@email.com.

When you receive this error, it means your file includes multiple contacts with the same email address. In this case, we only import the first one on your list. Make sure every email address only appears once to avoid this error.   

If you receive the error "Row has extra values that don't align with column headers", check if the extra value should go under a titled column. For example, if a phone number appears in an untitled column, you may want to move it to be under the column titled 'Phone'.

Untitled columns will be flagged in the Match step, so you can choose if to match them to existing contact fields, not to import, or create a new custom field.

If your contacts include information in a foreign language with non-Latin characters, such as Japanese, Korean, Hebrew, Hindi, Arabic and others, your CSV file may not upload correctly.

This is often caused by saving the CSV in an incorrect format. To ensure non-Latin characters are properly imported, your file must be saved as "comma -separated".

Note: Not all Microsoft Excel versions have this option.

If you deleted a contact and imported a CSV file with a field that includes that same contact's email or phone number (which are unique fields), previously deleted information will appear in your Contact list (even if it's not in your file). To resolve this issue, contact Customer Care. 

3. Once your existing file is loaded (each column should be divided into correct columns), click "File", "Download", "Comma Separated Values (.csv)".

You can now use this CSV to import your contacts.

1. Download the Wix sample file.

2. Open the file in Google Sheets.

3. Copy-paste information from original file to sample file.

4. Download file as Comma Separated Values (.csv).