Note: Only Super Admins/Admins can use this feature

If you are moving your team from another HR system to Charlie or have previously been storing all your company information in spreadsheets there's no need to add team member's one by one onto Charlie! You can use our CSV importer to easily transfer and upload your team member information into Charlie!

To Bulk Import Your Team Members by CSV:

  • Head over to the People tab on the lefthand side

  • Click on the drop down arrow next to 'Add a Person'

  • Click on 'Import People'

  • You will see the option to download our CSV template, click download

    download CSV template

  • Copy and paste your team member data into the CSV template

    NOTE: Not all fields are mandatory but you most input first name, last name and email address as the bare minimum for a bulk import.

    It is also important to not remove or change any of the CSV headings, if a column is not relevant just leave it blank. You can read more about our template guidance and breakdown of all columns here)

  • Once you have input your data into the required fields, make sure to save the file as a .CSV (only .CSVs can be uploaded into Charlie any other file type will receive an error upon uploading).

    csv upload spreadsheet

  • Return to the import people page on your Charlie account, either drag and drop the completed CSV or click upload to select the file.

  • Charlie will then import your team members and then you can get started finishing your Charlie account set up!

    upload a csv


FAQs:

  • Are team members automatically sent an invite when they are added by CSV?

    If you input TRUE in the invitation field then invites will automatically be sent to team members, if FALSE is input in the invitation field no invites will be sent and you will be able to send invitations out at a later time.

  • Do I have to populate all the fields?

    No, the only required fields are first name, last name and email address.

    Note: If you want to import any salary information, all the salary fields will need to be populated, if you leave any salary field blank (payroll currency, current salary amount, current salary frequency, date salary came into effect) you will receive an error when trying to upload the CSV.

  • I tried to upload the CSV but received an error:

    Double check your formatting (you cannot remove or change any of the headings), check your input formatting and have a look at our template guidance article for specific breakdown of the columns.

  • Can I use a CSV to update existing team member profiles? Yes you can download a current up to date CSV, make changes to the fields and re-upload the CSV onto the People tab.

Any other questions? Contact us via Live Chat or [email protected] and we'll be happy to help!

Did this answer your question?