--- title: How to Use the Import API to Import Data into EnrollNow description: Site Admins and Site Managers can use Ripple’s Import cURL API to import data in bulk from a third-party system—such as a CTMS, EDC, or CRM—into the Registry or a specific study. This eliminates the need to log into Ripple to manually use the Import Tool and helps keep your data harmonized across platforms. --- [Skip to content](https://support.enrollnow.io/en/knowledge-base/how-to-use-the-import-curl-api-to-import-data-into-ripple#main-content) [EnrollNow Support Center](https://support.enrollnow.io/helpdesk?hsLang=en) ![Logo + Tagline](https://support.enrollnow.io/hs-fs/hubfs/EnrollNow/Brand%20Assets/Logo%20+%20Tagline.png?width=300&height=75&name=Logo%20+%20Tagline.png) - [Support Center](https://support.enrollnow.io/helpdesk) - [User Community](https://academy.enrollnow.io/) - [Learning Academy](https://academy.enrollnow.io/) - [Knowledge Base](https://support.enrollnow.io/en/knowledge-base) Open main navigation Close main navigation - [Support Center](https://support.enrollnow.io/helpdesk) - [User Community](https://academy.enrollnow.io/) - [Learning Academy](https://academy.enrollnow.io/) - [Knowledge Base](https://support.enrollnow.io/en/knowledge-base) - [EnrollNow Support Center](https://support.enrollnow.io/helpdesk) How can we help you? - There are no suggestions because the search field is empty. 1. [EnrollNow Knowledge Base](https://support.enrollnow.io/en/knowledge-base?hsLang=en) 2. [API](https://support.enrollnow.io/en/knowledge-base/api?hsLang=en) June 18, 2026 # How to Use the Import API to Import Data into EnrollNow Site Admins and Site Managers can use EnrollNow’s **Import API** to import data in bulk from a third-party system—such as a CTMS, EDC, or CRM—into the **Registry** or a specific **study**. This eliminates the need to log into EnrollNow to manually use the Import Tool and helps keep your data harmonized across platforms. #### **What You Need Before You Start** Successful use of the import API the following: - **EnrollNow Site URL** - **Study ID** (or `"global"` for the Registry) - **Update Option** for handling existing participants - [**Authorization Key**](https://support.enrollnow.io/en/knowledge-base/creating-a-base64-authorization-key-for-api-use?hsLang=en) - **Name and location** of the Excel file on your device - The appropriate **Import cURL Command** based on your operating system ### Format Your Data First Before using the Import API, your Excel file must: - Use the **.xlsx format** - Follow the correct **column names** and **formats** listed in the EnrollNow **[Data Dictionary](https://support.enrollnow.io/en/knowledge-base/data-dictionary-overview?hsLang=en)** article. - Contain **only existing fields** in EnrollNow (new variables cannot be created via import) ### Import curl Command ### For **Mac Users:** `curl --location --request POST'EnrollNowSiteURL/v1/import?importtype=StudyId&updateoption=UpdateOption' \ --header'Authorization:Basic AuthorizationKey'\ --header'Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'\ --header'Connection:keep-alive'\ --header'Keep-Alive:timeout=360,max=1000'\ --data-binary'@LocationAndNameOfExcel.xlsx'` ### For **Windows Users:** `curl --location --request POST"EnrollNowSiteURL/v1/import?importtype=StudyId&updateoption=UpdateOption"  --header"Authorization:Basic AuthorizationKey"  --header"Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"  --header"Connection:keep-alive"  --header"Keep-Alive:timeout=360,max=1000"  --data-binary"@LocationAndNameOfExcel.xlsx"`     NOTE:  **Windows Users:** Replace all **single quotes (`'`)** with **double quotes (`"`)** and remove **backslashes (`\`)** used for line breaks. ### Step-by-Step Instructions 1. **Open your command line tool:** - Mac: Open **Terminal or iTerm** - Windows: Open **Command Prompt** 2. **Paste in the Import curl command.** 3. **Replace the placeholders:** | Placeholder | Replace with | | --- | --- | | `EnrollNowSiteURL` | Your site’s EnrollNow URL (e.g., `https://yourlab.ripplescience.com`) | | `StudyId` | Study ID string (from study URL) or `global` for Registry ![](https://support.enrollnow.io/hs-fs/hubfs/Rich%20Text%20Pasting/google-1747194334080.png?width=533&height=40&name=google-1747194334080.png) | | `UpdateOption` | One of the options below | | `AuthorizationKey` | Your Base64-encoded EnrollNow authorization key | | `LocationAndNameOfExcel` | Full file path and name of your `.xlsx` file (e.g., `/Users/janedoe/file.xlsx`) |   ### Update Options Specify how EnrollNow should treat **existing participants**: | Action | What to Use in Command | | --- | --- | | Update All Information | `all` | | Do Not Update Contact Information | `nocontact` | | Do Not Update Any Existing Participants | `noexisting` |  ![](https://support.enrollnow.io/hs-fs/hubfs/Rich%20Text%20Pasting/google-1747194362088.png?width=349&height=391&name=google-1747194362088.png) ### Example Import curl Command You are importing custom variable data and event completion records into the **Ancillary A study**. All participants already exist, and you want to **update all participant data**. `curl --location --request POST 'https://successplayground.ripplescience.com/v1/import?importtype=9oS3TfDyFN5npePSA&updateoption=all'\ --header'Authorization:Basic ZXhhbXBsZXVzZXJAcmlwcGxlc2NpZW5jZS5jb206c3VwZXJzZWNyZXRwYXNzd29yZDEyMyEKCg=='\ --header'Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'\ --header'Connection:keep-alive'\ --header'Keep-Alive:timeout=360, max=1000'\ --data-binary'@/Users/janedoe/Desktop/AncillaryA.xlsx'`   REMINDERS:  **Make sure to:** - Choose the correct curl format for your **device** - Use the correct **Site URL**, **Authorization Key**, and **Study ID** - Confirm that your Excel file matches **Data Dictionary** formatting - [My Account](https://support.enrollnow.io/en/knowledge-base/my-account?hsLang=en#main-content) - [Customer Corner](https://support.enrollnow.io/en/knowledge-base/my-account?hsLang=en#customer-corner) - [Support](https://support.enrollnow.io/en/knowledge-base/my-account?hsLang=en#support) - [Users & Permissions](https://support.enrollnow.io/en/knowledge-base/users-permissions?hsLang=en) - [Registry](https://support.enrollnow.io/en/knowledge-base/registry?hsLang=en) - [Studies](https://support.enrollnow.io/en/knowledge-base/studies?hsLang=en) - [Dashboard](https://support.enrollnow.io/en/knowledge-base/dashboard?hsLang=en) - [Participants](https://support.enrollnow.io/en/knowledge-base/participants?hsLang=en#main-content) - [Potential/Enrolled](https://support.enrollnow.io/en/knowledge-base/participants?hsLang=en#potential-enrolled) - [Sex/Gender](https://support.enrollnow.io/en/knowledge-base/participants?hsLang=en#sex-gender) - [Tasks](https://support.enrollnow.io/en/knowledge-base/tasks?hsLang=en#main-content) - [Tasks](https://support.enrollnow.io/en/knowledge-base/tasks?hsLang=en#tasks) - [Recruitment](https://support.enrollnow.io/en/knowledge-base/recruitment?hsLang=en#main-content) - [Sources](https://support.enrollnow.io/en/knowledge-base/recruitment?hsLang=en#sources) - [Strategies](https://support.enrollnow.io/en/knowledge-base/recruitment?hsLang=en#strategies) - [Calendar](https://support.enrollnow.io/en/knowledge-base/calendar?hsLang=en) - [Survey Creator](https://support.enrollnow.io/en/knowledge-base/survey-creator?hsLang=en#main-content) - [Tips and Tricks](https://support.enrollnow.io/en/knowledge-base/survey-creator?hsLang=en#tips-and-tricks) - [Thank you page](https://support.enrollnow.io/en/knowledge-base/survey-creator?hsLang=en#thank-you-page) - [Question Types](https://support.enrollnow.io/en/knowledge-base/survey-creator?hsLang=en#question-types) - [Report Builder & Reports](https://support.enrollnow.io/en/knowledge-base/report-builder-reports?hsLang=en#main-content) - [Reports](https://support.enrollnow.io/en/knowledge-base/report-builder-reports?hsLang=en#reports) - [Report Builder Basics](https://support.enrollnow.io/en/knowledge-base/report-builder-reports?hsLang=en#report-builder-basics) - [Study Settings](https://support.enrollnow.io/en/knowledge-base/study-settings?hsLang=en#main-content) - [Requirements](https://support.enrollnow.io/en/knowledge-base/study-settings?hsLang=en#requirements) - [Email and Texts](https://support.enrollnow.io/en/knowledge-base/study-settings?hsLang=en#email-and-texts) - [Display](https://support.enrollnow.io/en/knowledge-base/study-settings?hsLang=en#display) - [Details](https://support.enrollnow.io/en/knowledge-base/study-settings?hsLang=en#details) - [Statuses](https://support.enrollnow.io/en/knowledge-base/study-settings?hsLang=en#statuses) - [Bulk Tasks](https://support.enrollnow.io/en/knowledge-base/study-settings?hsLang=en#bulk-tasks) - [Events](https://support.enrollnow.io/en/knowledge-base/study-settings?hsLang=en#events) - [Import/Export](https://support.enrollnow.io/en/knowledge-base/import-export?hsLang=en#main-content) - [Tips and Tricks](https://support.enrollnow.io/en/knowledge-base/import-export?hsLang=en#tips-and-tricks) - [study definitions](https://support.enrollnow.io/en/knowledge-base/import-export?hsLang=en#study-definitions) - [Export](https://support.enrollnow.io/en/knowledge-base/import-export?hsLang=en#export) - [API](https://support.enrollnow.io/en/knowledge-base/api?hsLang=en) - [FAQs & Troubleshooting](https://support.enrollnow.io/en/knowledge-base/faqs-troubleshooting?hsLang=en#main-content) - [Ripple Performance](https://support.enrollnow.io/en/knowledge-base/faqs-troubleshooting?hsLang=en#ripple-performance) - [Security Settings](https://support.enrollnow.io/en/knowledge-base/faqs-troubleshooting?hsLang=en#security-settings) - [Reuse Custom ID](https://support.enrollnow.io/en/knowledge-base/faqs-troubleshooting?hsLang=en#reuse-custom-id) - [Internal Server Error - Importing](https://support.enrollnow.io/en/knowledge-base/faqs-troubleshooting?hsLang=en#internal-server-error-importing) - [Account Lock out](https://support.enrollnow.io/en/knowledge-base/faqs-troubleshooting?hsLang=en#account-lock-out) - [FAQ](https://support.enrollnow.io/en/knowledge-base/faqs-troubleshooting?hsLang=en#faq) - [Calendar Integration Issues](https://support.enrollnow.io/en/knowledge-base/faqs-troubleshooting?hsLang=en#calendar-integration-issues) - [e-consent downloads](https://support.enrollnow.io/en/knowledge-base/faqs-troubleshooting?hsLang=en#e-consent-downloads) - [Support Web Pages](https://support.enrollnow.io/en/knowledge-base/faqs-troubleshooting?hsLang=en#support-web-pages) - [EnrollNow Glossary](https://support.enrollnow.io/en/knowledge-base/faqs-troubleshooting?hsLang=en#enrollnow-glossary) - [EnrollNow Performance](https://support.enrollnow.io/en/knowledge-base/faqs-troubleshooting?hsLang=en#enrollnow-performance) - [Security](https://support.enrollnow.io/en/knowledge-base/security?hsLang=en#main-content) - [Security](https://support.enrollnow.io/en/knowledge-base/security?hsLang=en#security) - [Ripple Service Status Report](https://support.enrollnow.io/en/knowledge-base/security?hsLang=en#ripple-service-status-report) - [Workflows and How To's](https://support.enrollnow.io/en/knowledge-base/workflows-and-how-tos?hsLang=en) - [Site Admin](https://support.enrollnow.io/en/knowledge-base/site-admin?hsLang=en#main-content) - [Users](https://support.enrollnow.io/en/knowledge-base/site-admin?hsLang=en#users) - [Export](https://support.enrollnow.io/en/knowledge-base/site-admin?hsLang=en#export) - [Security](https://support.enrollnow.io/en/knowledge-base/site-admin?hsLang=en#security) - [Audit Logs](https://support.enrollnow.io/en/knowledge-base/audit-logs?hsLang=en) - [Product Release Notes](https://support.enrollnow.io/en/knowledge-base/product-release-notes?hsLang=en#main-content) - [2026](https://support.enrollnow.io/en/knowledge-base/product-release-notes?hsLang=en#2026) - [2025](https://support.enrollnow.io/en/knowledge-base/product-release-notes?hsLang=en#2025) - [2024](https://support.enrollnow.io/en/knowledge-base/product-release-notes?hsLang=en#2024) - [2023](https://support.enrollnow.io/en/knowledge-base/product-release-notes?hsLang=en#2023) - [2022](https://support.enrollnow.io/en/knowledge-base/product-release-notes?hsLang=en#2022) - [2019-2021](https://support.enrollnow.io/en/knowledge-base/product-release-notes?hsLang=en#2019-2021) [![](https://support.enrollnow.io/hubfs/EnrollNow-Logo-Color-BlueYellow.svg)](http://enrollnow.io)                                                                                 [Privacy Policy](https://enrollnow.io/legal/privacy-policy)[Terms of Service](https://enrollnow.io/legal/terms-of-service) Copyright © 2025, EnrollNow