# Importing Device Groups via CSV in Hexnode UEM Bulk importing allows IT administrators to manage endpoints at scale by creating new groups or updating existing ones using a CSV file. This is ideal for department-based categorization and bulk policy targeting. Prerequisites and CSV Preparation ---------------------------------- To ensure a successful import, your CSV file must contain specific attributes. If your column headers match Hexnode’s standard terms, mapping occurs automatically. #### Required CSV Columns - **groupname**: The name of the target group (existing or new). - **members**: The unique identifier for the device. You may use the Serial Number, Device ID, UDID, or IMEI Number. - **description**: A brief explanation of the group’s purpose. [![bulk enrollment with csv for device groups](https://cdn.hexnode.com/mobile-device-management/help/wp-content/uploads/2021/01/Sample-CSV-file-for-bulk-enrollment-e1609770658774.png)](https://cdn.hexnode.com/mobile-device-management/help/wp-content/uploads/2021/01/Sample-CSV-file-for-bulk-enrollment-e1609770658774.png) **Important Formatting Note**: If adding multiple devices to a single group in one row, separate the identifiers in the members column using a semicolon (;). The Import Process ------------------ #### Step 1: Upload CSV 1. Log in to the Hexnode UEM portal. 2. Navigate to **Manage** > **Device Groups**. 3. Select **Add Bulk Devices with CSV**. 4. Upload your prepared file. [![Uploading the CSV file for bulk enrollment.](https://cdn.hexnode.com/mobile-device-management/help/wp-content/uploads/2018/11/Upload-CSV-file-for-bulk-enrollment.png)](https://cdn.hexnode.com/mobile-device-management/help/wp-content/uploads/2018/11/Upload-CSV-file-for-bulk-enrollment.png) Step 2: Verify and Map CSV Attributes -------------------------------------- During this stage, you must align your CSV headers with Hexnode’s data fields: - **Automatic Mapping**: Occurs if your CSV uses standard column names (groupname, members, description). - **Manual Mapping**: If your headers differ, a Map Keys box will open. Use the dropdown menus to map your keys to Hexnode’s attributes. [![Mapping keys of imported CSV file attributes with the device group.](https://cdn.hexnode.com/mobile-device-management/help/wp-content/uploads/2018/11/Map-keys-of-imported-CSV-file-for-bulk-enrollment.png)](https://cdn.hexnode.com/mobile-device-management/help/wp-content/uploads/2018/11/Map-keys-of-imported-CSV-file-for-bulk-enrollment.png) - **Group Creation Logic**: - **New Groups**: Check **Create non-existing groups** to generate a new group based on the CSV. - **Existing Groups**: Uncheck **Create non-existing groups** to only add devices to already established groups. - **Cleanup**: Check **Remove existing devices in the group(s)** if you wish to clear the current members before adding the new list. [![Verify the keys and attributes of the CSV file uploaded for bulk enrollment.](https://cdn.hexnode.com/mobile-device-management/help/wp-content/uploads/2018/11/Verify-the-CSV-file-uploaded-for-bulk-enrollment.png)](https://cdn.hexnode.com/mobile-device-management/help/wp-content/uploads/2018/11/Verify-the-CSV-file-uploaded-for-bulk-enrollment.png) #### Step 3: Summary and Completion After verification, Hexnode provides a final summary of the import. Click Finish to view your updated or newly created device groups. [![Added Bulk devices into device groups by uploading CSV file.](https://cdn.hexnode.com/mobile-device-management/help/wp-content/uploads/2018/11/Adding-Bulk-devices-via-CSV-file.png)](https://cdn.hexnode.com/mobile-device-management/help/wp-content/uploads/2018/11/Adding-Bulk-devices-via-CSV-file.png) Understanding Import Statuses ----------------------------- When the process finishes, the summary indicates the success rate of your import: - **Success**: All devices were identified and added to the specified groups. - **Updated Partially**: This status appears if certain devices failed to join the group. Common reasons include: - The device is disenrolled. - The device has not yet been enrolled in Hexnode. - An incorrect Serial Number, UDID, or IMEI was entered. **Note**: Devices that failed to join will be listed specifically under “Devices Added Except the Ones With…” for your review. [![Add bulk devices to a device group with/without removing existing members.](https://cdn.hexnode.com/mobile-device-management/help/wp-content/uploads/2018/11/Add-Bulk-devices-to-a-device-group-via-CSV-file.png)](https://cdn.hexnode.com/mobile-device-management/help/wp-content/uploads/2018/11/Add-Bulk-devices-to-a-device-group-via-CSV-file.png) Frequently Asked Questions (FAQs) ---------------------------------- 1. **What happens if I enter a group name that already exists?** If you have “Create non-existing groups” checked but the name matches an existing group, Hexnode will not create a duplicate. Instead, it will merge the devices from your CSV into the existing group. 2. **How do I replace all current members of a group with a new list?** During the Verify CSV step, ensure you check the box labeled Remove existing devices in the group(s). This wipes the current membership before importing the new CSV data. 3. **What should I do if my CSV columns have custom names like “Dept_Name” instead of “groupname”?**You can still perform the import. During the Map Keys pop-up, simply select “groupname” from the Hexnode dropdown and pair it with your custom “Dept_Name” column.