By using the export feature in Gem projects, it's possible to bulk import people into Greenhouse from Gem. 

Export a Project from Gem

People in Gem projects can be exported and downloaded into a CSV file. To do this, navigate to a project in Gem and click on the 'Share' button on the top right of the Project page.  Click the 'Download CSV' option. This will initiate a file download of the people in the Gem project.

Prepare the CSV for Greenhouse

Open the project CSV file in your preferred spreadsheet application. Depending on the application, you may be asked to select some options before being able to edit the spreadsheet. Generally, the default options can be used.

With the spreadsheet open in your application, you will need to add three columns: Job, Source, and Who Gets Credit. For each column, enter the appropriate values (eg: 'Engineering Manager', 'Entelo', '<Your Name>'), Most spreadsheet applications will allow you easily copy data in a column once you've entered data into a cell. With a cell selected, click the bottom-right corner of the cell and then drag to quickly copy data into each row of the column.

Make sure to save your work before continuing. Choose CSV or XLS as the format. 

Upload to Greenhouse

With the spreadsheet prepared and saved, go to the Bulk Import page in Greenhouse. It can be accessed by clicking the 'gear' icon at the top of most pages on Greenhouse and then clicking 'Bulk Import' in the left column.

On the Bulk Import page, click 'Upload Prospects Spreadsheet' and select the spreadsheet file. Follow the remaining steps in the Greenhouse data importer to finish uploading the people to Greenhouse.

Be careful, uploading the spreadsheet may create duplicate Greenhouse profiles. It's recommended you click into each Prospect you upload and merge profiles if there was one.

Need help handing bulk importing from a Gem project into Greenhouse? Feel free to reach out to the Gem team by emailing us directly at or press "Chat with Us" in the Gem home page.

Did this answer your question?