---
title: Bulk Import Clients from Spreadsheet
description: Bulk import clients
---
[Skip to content](https://help.hirasmus.com/knowledge/bulk-import-clients-from-spreadsheet#main-content)
English
Show submenu for translations
[Request Support](https://help.hirasmus.com/knowledge/kb-tickets/new?hsLang=en) [Customer portal](https://help.hirasmus.com/helpdesk?hsLang=en)
Open main navigation
Close main navigation
- English
Show submenu for translations
- [Request Support](https://help.hirasmus.com/knowledge/kb-tickets/new)
- [Customer portal](https://help.hirasmus.com/helpdesk)
- hirasmus.com
hirasmus.com
Hi! How can we help you?
- There are no suggestions because the search field is empty.
1. [Hi Rasmus Help Center](https://help.hirasmus.com/knowledge?hsLang=en)
2. [Managing Clients & Users](https://help.hirasmus.com/knowledge/managing-clients-users?hsLang=en)
May 7, 2026
# Bulk Import Clients from Spreadsheet
## Learn how to easily bulk import clients from a spreadsheet into Hi Rasmus
There are 4 steps to the client import process:
1. [Complete custom client information fields](https://help.hirasmus.com/knowledge/bulk-import-clients-from-spreadsheet#step1)
2. [Export client spreadsheet from Hi Rasmus](https://help.hirasmus.com/knowledge/bulk-import-clients-from-spreadsheet#step2)
3. [Fill out spreadsheet will all client information](https://help.hirasmus.com/knowledge/bulk-import-clients-from-spreadsheet#step3)
4. [Import spreadsheet into Hi Rasmus](https://help.hirasmus.com/knowledge/bulk-import-clients-from-spreadsheet#step4)
---
### 1. Complete custom client information fields
Why this is an important first step: Once a client is in Hi Rasmus, the information cannot be updated via this import process. The system blocks duplicate imports. Any additional information will need to be entered manually in Hi Rasmus.
Some basic client information and demographic fields come pre-set in Hi Rasmus (Address, Phone, DOB, etc), but organizations can also add Custom Client Information Fields to capture additional information. These may be necessary for notes, forms, or reports. [See more information here](https://help.hirasmus.com/knowledge/custom-client-data-fields?hsLang=en).
Once you have completed all custom client information fields you want to import, move to step 2
### 2. Export client spreadsheet from Hi Rasmus
To export the client spreadsheet in the correct format:
1. Navigate to **\[clients\]** on the left side menu
2. Click the **\[gear icon\]** in the top right corner of the client list
3. Select all fields you want to include on the export
1. First Name, Last Name, and Date of Birth are all required fields on the import
2. Age is auto-populated based on birth date, so does not need to be included
4. Select **\[submit\]**
5. Select the **\[export\]** button to download as a spreadsheet
### 3. Fill out spreadsheet will all client information
Using this exported spreadsheet, fill in all known client information
**Important Notes:**
1. First Name, Last Name, and Date of Birth fields are required.
2. Additional columns can be added. To import, the column header should match the name of an information field in Hi Rasmus. If there isn't a corresponding field, the system will prompt you to map the fields
3. For best results, format the Date of Birth column in excel to be a "date" format type. The default export is "automatic" and may cause errors on import
4. Duplicate clients will not be imported. These are clients with exact match to first name, last name, and date of birth.
**Considerations for specific custom client information field types:**
- Date - all date columns should be formatted as dates in excel
- Selection - values on import sheet must exactly match values in information field. Multiple values can be imported with a comma separated list. Example "ASD, ADHD"
- Tip: if errors are occuring in this field, check your client information fields. It is possible an extra space is present at the end of the word. Try deleting the option and typing again
- User - the user must have an active account in Hi Rasmus to import. They need to have accepted the invite. This field will match the "User Name (Display Name)" field.
**Validation Rules for standard Hi Rasmus fields:**
| Preferred Name | Text format, max length: 510 symbols |
| --- | --- |
| First Name | Required field in text format, max length: 255 symbols, min length: 1 symbol |
| Last Name | |
| Alias | Text format, max length: 5 symbols |
| Reference ID | Text format, max length: 255 symbols |
| Gender | Allowed text values: Male, Female, Other |
| Date of Birth | Required field in the date format (MM/DD/YYYY) |
| Age | - - omitted because it is defined dynamically by date of birth |
| Email | Valid email format |
| Phone | Text format, max length: 255 symbols |
| Address Line 1 | Text format, max length: 255 symbols |
| Address Line 2 | Text format, max length: 255 symbols |
| Zip / Postal Code | Text or number format |
| City / District | Text format, max length: 255 symbols |
| State / Province | Text format, max length: 3 symbols, allowed values include the codes for US, Emirates, Australian, and Canadian states used in the Hi Rasmus system. |
| Country | Text format, max length: 2 symbols, allowed values include the country code used in the Hi Rasmus System (e. g., US, AU, CA) |
### 4. Import spreadsheet into Hi Rasmus
Once the spreadsheet is completed:
1. Save in .xlsx or .csv format
2. Navigate to the **\[clients\]** tab on the left side menu in Hi Rasmus
3. Click **\[Bulk Import Clients\]**
4. Select your file
5. If any column headers in your spreadsheet are not an exact match, you can choose to map the column to an existing field.
6. Resolve any warnings or errors. Warnings (orange triangle) will not block import. Errors (red circle) will block import.
1. Errors will present with a description of the error, as well as the location of the error in the spreadsheet. These must be resolved in the sheet and re-uploaded
2. Some common errors:
1. Missing Required Fields (first name, last name, date of birth)
2. Invalid date format - update excel column format
3. No matching value found - in a selection field, the corresponding value is not present in the field
4. Duplicate client
7. Once all errors have been resolved, press **\[import clients\]**
- [Getting Started](https://help.hirasmus.com/knowledge/getting-started?hsLang=en#main-content)
- [Quickstart Guide](https://help.hirasmus.com/knowledge/getting-started?hsLang=en#quickstart-guide)
- [Hi Rasmus 101: Using Hi Rasmus as a Behavior Technician](https://help.hirasmus.com/knowledge/getting-started?hsLang=en#hi-rasmus-101-using-hi-rasmus-as-a-behavior-technician)
- [Hi Rasmus 201: Hi Rasmus Guide for BCBAs / Behavior Analysts](https://help.hirasmus.com/knowledge/getting-started?hsLang=en#hi-rasmus-201-hi-rasmus-guide-for-bcbas-behavior-analysts)
- [Hi Rasmus 101: Using Hi Rasmus in a Multi-Disciplinary Setting](https://help.hirasmus.com/knowledge/getting-started?hsLang=en#hi-rasmus-101-using-hi-rasmus-in-a-multi-disciplinary-setting)
- [Managing Clients & Users](https://help.hirasmus.com/knowledge/managing-clients-users?hsLang=en#main-content)
- [Managing Clients](https://help.hirasmus.com/knowledge/managing-clients-users?hsLang=en#managing-clients)
- [Managing Users](https://help.hirasmus.com/knowledge/managing-clients-users?hsLang=en#managing-users)
- [Client \<\> User Access](https://help.hirasmus.com/knowledge/managing-clients-users?hsLang=en#client-user-access)
- [User Privileges](https://help.hirasmus.com/knowledge/managing-clients-users?hsLang=en#user-privileges)
- [Multi-factor Authentication (MFA)](https://help.hirasmus.com/knowledge/managing-clients-users?hsLang=en#multi-factor-authentication-mfa)
- [Single Sign On](https://help.hirasmus.com/knowledge/managing-clients-users?hsLang=en#single-sign-on)
- [Staff Licenses](https://help.hirasmus.com/knowledge/staff-licenses?hsLang=en)
- [Creating Programs](https://help.hirasmus.com/knowledge/creating-programs?hsLang=en#main-content)
- [Your Program Library](https://help.hirasmus.com/knowledge/creating-programs?hsLang=en#your-program-library)
- [Program Setup: Prompt Levels and Workflows](https://help.hirasmus.com/knowledge/creating-programs?hsLang=en#program-setup-prompt-levels-and-workflows)
- [Program Setup: Program Building Blocks](https://help.hirasmus.com/knowledge/creating-programs?hsLang=en#program-setup-program-building-blocks)
- [Creating Programs by Type](https://help.hirasmus.com/knowledge/creating-programs?hsLang=en#creating-programs-by-type)
- [Specific Program Capabilities](https://help.hirasmus.com/knowledge/creating-programs?hsLang=en#specific-program-capabilities)
- [Featured Programs and Library Catalog](https://help.hirasmus.com/knowledge/creating-programs?hsLang=en#featured-programs-and-library-catalog)
- [Client Progress](https://help.hirasmus.com/knowledge/client-progress?hsLang=en#main-content)
- [Reviewing Client Data](https://help.hirasmus.com/knowledge/client-progress?hsLang=en#reviewing-client-data)
- [Program Modifications](https://help.hirasmus.com/knowledge/client-progress?hsLang=en#program-modifications)
- [Client Progress Reports](https://help.hirasmus.com/knowledge/client-progress?hsLang=en#client-progress-reports)
- [Assessment Results](https://help.hirasmus.com/knowledge/client-progress?hsLang=en#assessment-results)
- [Exporting Data](https://help.hirasmus.com/knowledge/client-progress?hsLang=en#exporting-data)
- [Operational Tools, Reporting and Auditing](https://help.hirasmus.com/knowledge/operational-tools-reporting-and-auditing?hsLang=en#main-content)
- [Single Client Reporting / Auditing](https://help.hirasmus.com/knowledge/operational-tools-reporting-and-auditing?hsLang=en#single-client-reporting-auditing)
- [Cross Client Reporting / Auditing (Premium)](https://help.hirasmus.com/knowledge/operational-tools-reporting-and-auditing?hsLang=en#cross-client-reporting-auditing-premium)
- [Activity Time Change Requests](https://help.hirasmus.com/knowledge/operational-tools-reporting-and-auditing?hsLang=en#activity-time-change-requests)
- [Sessions](https://help.hirasmus.com/knowledge/sessions?hsLang=en#main-content)
- [Setting Up a Client Session](https://help.hirasmus.com/knowledge/sessions?hsLang=en#setting-up-a-client-session)
- [Running a Client Session](https://help.hirasmus.com/knowledge/sessions?hsLang=en#running-a-client-session)
- [Completing Session Notes](https://help.hirasmus.com/knowledge/sessions?hsLang=en#completing-session-notes)
- [Group Sessions](https://help.hirasmus.com/knowledge/sessions?hsLang=en#group-sessions)
- [Reviewing and Editing Sessions / Activities](https://help.hirasmus.com/knowledge/sessions?hsLang=en#reviewing-and-editing-sessions-activities)
- [Supervision Mode](https://help.hirasmus.com/knowledge/supervision-mode?hsLang=en#main-content)
- [Supervision Criteria](https://help.hirasmus.com/knowledge/supervision-mode?hsLang=en#supervision-criteria)
- [Supervising Live Sessions](https://help.hirasmus.com/knowledge/supervision-mode?hsLang=en#supervising-live-sessions)
- [Supervision Session Notes](https://help.hirasmus.com/knowledge/supervision-mode?hsLang=en#supervision-session-notes)
- [Templates](https://help.hirasmus.com/knowledge/templates?hsLang=en#main-content)
- [Session Notes](https://help.hirasmus.com/knowledge/templates?hsLang=en#session-notes)
- [Forms](https://help.hirasmus.com/knowledge/templates?hsLang=en#forms)
- [Treatment Plans and Progress Reports](https://help.hirasmus.com/knowledge/templates?hsLang=en#treatment-plans-and-progress-reports)
- [Activity Types](https://help.hirasmus.com/knowledge/templates?hsLang=en#activity-types)
- [Integrations](https://help.hirasmus.com/knowledge/integrations?hsLang=en#main-content)
- [Aloha ABA Integration](https://help.hirasmus.com/knowledge/integrations?hsLang=en#aloha-aba-integration)
- [Aloha Integration: FAQ And Troubleshooting](https://help.hirasmus.com/knowledge/integrations?hsLang=en#aloha-integration-faq-and-troubleshooting)
- [Lumary Integration: Overview](https://help.hirasmus.com/knowledge/integrations?hsLang=en#lumary-integration-overview)
- [Lumary Integration: Set Up](https://help.hirasmus.com/knowledge/integrations?hsLang=en#lumary-integration-set-up)
- [Lumary Integration: Running and Reviewing Sessions](https://help.hirasmus.com/knowledge/integrations?hsLang=en#lumary-integration-running-and-reviewing-sessions)
- [Lumary Integration: FAQ and Troubleshooting](https://help.hirasmus.com/knowledge/integrations?hsLang=en#lumary-integration-faq-and-troubleshooting)
- [TherapyPM](https://help.hirasmus.com/knowledge/integrations?hsLang=en#therapypm)
- [Boost Integration: Overview](https://help.hirasmus.com/knowledge/integrations?hsLang=en#boost-integration-overview)
- [Boost Integration: Set Up](https://help.hirasmus.com/knowledge/integrations?hsLang=en#boost-integration-set-up)
- [Boost Integration: Running and Reviewing Sessions](https://help.hirasmus.com/knowledge/integrations?hsLang=en#boost-integration-running-and-reviewing-sessions)
- [Boost Integration: FAQ and Troubleshooting](https://help.hirasmus.com/knowledge/integrations?hsLang=en#boost-integration-faq-and-troubleshooting)
- [Camber Integration: Overview](https://help.hirasmus.com/knowledge/integrations?hsLang=en#camber-integration-overview)
- [Camber Integration: Set up](https://help.hirasmus.com/knowledge/integrations?hsLang=en#camber-integration-set-up)
- [Camber: Running and Reviewing Sessions](https://help.hirasmus.com/knowledge/integrations?hsLang=en#camber-running-and-reviewing-sessions)
- [Camber: FAQ and Troubleshooting](https://help.hirasmus.com/knowledge/integrations?hsLang=en#camber-faq-and-troubleshooting)
- [Offline Mode](https://help.hirasmus.com/knowledge/offline-mode?hsLang=en)
- [Parents](https://help.hirasmus.com/knowledge/parents?hsLang=en)
- [RBT Training](https://help.hirasmus.com/knowledge/rbt-training?hsLang=en)
- [Outcomes](https://help.hirasmus.com/knowledge/outcomes?hsLang=en#main-content)
- [Data Accessibility](https://help.hirasmus.com/knowledge/outcomes?hsLang=en#data-accessibility)
- [AI](https://help.hirasmus.com/knowledge/ai?hsLang=en)
- [Scheduling](https://help.hirasmus.com/knowledge/scheduling?hsLang=en#main-content)
- [🏁 Scheduling: Getting Started](https://help.hirasmus.com/knowledge/scheduling?hsLang=en#scheduling-getting-started)
- [🛠️ Scheduling: Set Up](https://help.hirasmus.com/knowledge/scheduling?hsLang=en#%EF%B8%8F-scheduling-set-up)
- [⚙️ Scheduling: Calendar Views and Settings](https://help.hirasmus.com/knowledge/scheduling?hsLang=en#%EF%B8%8F-scheduling-calendar-views-and-settings)
- [📆 Scheduling: Creating and Updating Appointments and Events](https://help.hirasmus.com/knowledge/scheduling?hsLang=en#scheduling-creating-and-updating-appointments-and-events)
- [✅ Scheduling: Completing Scheduled Appointments](https://help.hirasmus.com/knowledge/scheduling?hsLang=en#scheduling-completing-scheduled-appointments)
- [📈 Scheduling: Appointments Reporting](https://help.hirasmus.com/knowledge/scheduling?hsLang=en#scheduling-appointments-reporting)
- [Frequently Asked Questions](https://help.hirasmus.com/knowledge/frequently-asked-questions?hsLang=en#main-content)
- [Subscription and Invoices](https://help.hirasmus.com/knowledge/frequently-asked-questions?hsLang=en#subscription-and-invoices)
- [Device and App Info](https://help.hirasmus.com/knowledge/frequently-asked-questions?hsLang=en#device-and-app-info)
- [Recovering Deleted Items](https://help.hirasmus.com/knowledge/frequently-asked-questions?hsLang=en#recovering-deleted-items)
- [Settings](https://help.hirasmus.com/knowledge/settings?hsLang=en)
- [New and Coming Soon!](https://help.hirasmus.com/knowledge/new-and-coming-soon?hsLang=en)
[](https://hirasmus.com)
Help Center
Copyright © 2026, Hi Rasmus Inc.