Learn how to import device users into your Miradore site in bulk using a CSV file.
Prepare your CSV file
You can either create the CSV file yourself or download our template.
CSV file requirements
Keep the following in mind when preparing your CSV file:
- The file must contain data in the following format:
email address, first name, last name, middle initial, phone number. - The following values are required: email address, first name, last name, phone number. Including a value for middle initial is optional.
- If the user has no middle initial, use a double delimiter in its place.
Example:jane.doe@example.com, Jane, Doe,, +1-202-123-4567 - The phone number must be in international format.
Example:+1-202-123-4567 - Spaces between the delimiters do not affect the data.
- Values are imported exactly as entered. For example, if you type a first name with a lowercase letter, it will appear that way in Miradore.
- Both .txt and .csv file extensions are accepted.
File content examples
If you downloaded our template file, open it in a text or spreadsheet editor (such as Notepad or Microsoft Excel), and fill it in as follows:
Note: If you keep the header row (A1–E1 in the example), you must select The file includes a header row in the wizard.
Import user data from a CSV file
- Navigate to Company > Users and select Import > Import from CSV at the top of the page.
- Select Users, then select Next.
- Optional: If you don't already have a CSV file, select Download template to get a pre-formatted file.
Note: See CSV file requirements for further considerations and examples. - In the Select a CSV file row, choose Browse and upload your file.
- In the Choose a delimiter row, select the delimiter used in your file from the drop-down list.
- Optional: If your file's first row contains column headers (e.g., Email, First name, Last name…), select The file includes a header row.
- Review the imported data in the Preview section, then select Import.
Tip: Hover over the
icon to the left of the user entry to see errors in your file.
Important: If you make any changes to your file, select Browse and upload it again. See Troubleshooting for possible errors and their solutions. - Select Close to exit the wizard.
icon to the left of the user entry to see errors in your file.
Results: The users from your CSV file are added to Miradore.
Troubleshooting
The following table shows possible errors and their solutions:
| Error | Solution |
|---|---|
| The Email field is required | Enter the user's email address as the first value in the file. |
| The First name field is required | Enter the user's first name as the second value in the file. |
| The Last name field is required | Enter the user's last name as the third value in the file. |
| Invalid email address | Check that the email address follows a valid format, for example, user@example.com. |
| Invalid phone number | Enter the user's phone number in the international format including country code, for example, +1-202-123-4567. |
| Duplicate email address | Multiple user entries in your file contain the same email address. Users' email addresses must be unique. |
| User with the same email address already exists | A data row has an email address that already exists in your Miradore environment. Users' email addresses must be unique. |
Previous Article:
« Import from CSV
Next Article:
Adding a user »