Skip to main content
Import Students/Clients/Residents

Mass import all of your students/consumers/residents from Excel spreadsheet.

Trent Kocurek avatar
Written by Trent Kocurek
Updated over 3 weeks ago

If you're managing an organization with several consumers, manually adding them individually can be time-consuming. Equip streamlines this process, allowing you to import multiple consumers simultaneously in a quick and efficient manner.

Import Steps

  1. Sign in to Equip

  2. Click on Consumers

  3. Click on Import Consumers

  4. Drag your Excel file into the bordered box or click to upload

  5. Follow the Prompts

Column Guide

Required Columns

  • name

  • email

  • dob

Optional Columns

  1. title

  2. pronouns

  3. phone

  4. sex

  5. bio

  6. office_phone

  7. race

  8. ethnicity

  9. enrolled_at

  10. self_guardianship

  11. guardianship_comment

  12. gid

  13. diagnoses

  14. card_message

  15. ssn

  16. counselor_name

  17. medicaid_number

Available Options for Enum Fields

  1. Sex:

    • male

    • female

    • undisclosed

  2. Race:

    • american_indian_or_alaska_native

    • asian

    • black_or_african_american

    • native_hawaiian_or_other_pacific_islander

    • white

    • two_or_more_races

    • other_race

  3. Ethnicity:

    • hispanic_or_latino

    • non_hispanic_or_latino

  4. Self Guardianship:

    • true

    • false

Important Notes

  • The 'email' field must be unique for each consumer.

  • Sensitive information like SSN and medicaid_number are encrypted in the database.

  • Date fields (like DOB and enrolled_at) should be in a recognized format (e.g., YYYY-MM-DD).

  • Boolean fields (like self_guardianship) should be either 'true' or 'false'.

By following this guide, you can efficiently import multiple consumers into your Equip organization, saving time and reducing the potential for data entry errors.

Did this answer your question?