Error when uploading spreadsheet for bulk import

Question:

I keep encountering an error when uploading a spreadsheet into Greenhouse when trying to bulk import prospects/users

Answer:

The most likely cause for these errors is multiple email addresses being entered in one row's email column of your csv or Excel file. Also special characters such as accents marks within the spreadsheet can cause issues. Because of this, the first step to take would be to review and go over the spreadsheet to ensure everything appears correctly (without special characters and accents or multiple inputs for email addresses).

If you are certain that there are no special characters, it might still be detected by our app due to invalid UTF-8 characters that can be unseen/invisible. These invalid characters might have been copied over when filling out the spreadsheet so there are multiple troubleshooting steps that can be taken: 

1. Copy the entire list over to Google Sheets or to a text editor to removing any formatting and paste it back into the spreadsheet 

2. Manually retype the data within the fields 

3. If all else fails, please feel free to send the spreadsheet over to support@greenhouse.io and we can look deeper into this. 

Applies-To:

The ability to bulk import prospects applies to all admins.

The ability to bulk import users applies to all Site Admins only. 

Metadata

[Organizational, historical, and categorization data that shows whether content is in the right general domain, as well as state and usage information that helps would-be users understand how often a KCS article has been reused (to indicate confidence) and its stage in the development life cycle.]

Author: Karen Situ
Create Date: [15:55: 05-15-17]
Modified Date:[15:55: 05-15-17]
Keywords: [spreadsheet, bulk import, users, prospects, error]

Have more questions? Submit a request

Comments

Powered by Zendesk