Troubleshooting CSV uploads on Workplace
This article is only applicable to admins of Workplace Essential and Workplace Advanced.
If you're having trouble uploading a CSV file, it may be due to one of these common issues:
- Not in CSV Format: All files must be in the valid CSV format (file extension .csv). Other file types and formats aren't accepted.
- Not UTF-8 Encoded: All files must be encoded in UTF-8 character encoding.
- Values Contain Commas: If a value contains a comma, the whole value must be escaped by using double quotes (ex. "value_with_comma"). For example London, England should be stored in the CSV as "London, England".
- Duplicates: Duplicate employee records will cause errors in the CSV validation.
- Incorrect Capitalization: Incorrect capitalization won't normally cause an error, but names, locations, and other fields will be stored with the same capitalization as in the CSV file.
- Invalid Phone Number: Phone numbers should be in the format [country code] + [area code] + [phone number] (ex. +1 800 555 0150).
- Invalid Locale: The locale should be one of the valid abbreviations listed in Facebook locales.