You may encounter various error messages when importing lists of people. Below are some common error messages and their solutions.
Error 1: "Invalid import file: Not a CSV extension"
Solution: Be sure to save your file as a Unicode text file (.txt) and try again. You can also save as a CSV file, however we recommend TXT (UTF-16 Unicode Text) for best results.
Error 2: "Invalid import file: The following columns are required in the csv: email, firstname, lastname (username cannot be used)(1001)"
Solution: Make sure you are using "email", "firstname", and "lastname" spelled exactly at it is here. All lower case, without spaces.
Error 3: Invalid data item (displayed by a cell highlighted in deep red)
Solution: Correct the data in the highlighted cell. Usually caused by an invalid email address or missing value.
Error 4: Special/accented characters missing or displayed incorrectly
Solution: Try saving your file as a TXT (UTF-16 Unicode text) instead of CSV to allow all characters to show properly.
Other articles you may find useful: