Creating & Updating Object Records in Bulk

You can import records such as OneTrust users, processing activities, data elements, assets, legal entities, and consent receipts in bulk. Various import templates are available on the Import Templates screen that allow you to bulk create and bulk update records using a spreadsheet that can be uploaded into the OneTrust application.

To create Object Records in bulk with templates

  1. Click the gear icon in the upper right-hand corner to access Global Settings.
  2. On the Global Settings menu, select Data Import > Import Templates.

    The Import Templates screen appears.

  3. Locate the Create Custom Object template.


  4. Click the Download button.

    The Download Import Template modal appears.

  5. In the Object Type field, select your desired Object Type.


  6. Click the Download button.
  7. Open the downloaded file in Microsoft Excel.
  8. Complete the downloaded template for the records you want to import.
    Note:

    The bulk import process does not support the following characters when creating multiple inventory records: /, |, and ;. A new row is needed for each record.

    In addition, allow the bulk import to complete before uploading more files. Files larger than 64 MB are not supported.

  9. Navigate to the Data Import > Bulk Import menu.
  10. Click the New Import button.

    The New Import modal appears.

  11. In the Import Name field, enter a name for the import.
  12. In the Import Description field, enter a brief description of the contents of the import.
  13. In the Import Type field, select Create Custom Objects.

    The Object Type field appears.

  14. In the Object Type field, select your desired Object Type.
  15. In the File field, click the Upload File button.
  16. Use the file explorer to select the spreadsheet you want to import.
    Note:

    Verify that the spreadsheet is saved as a .xlsx file.

  17. Click the Submit button. 


  18. To view the status and result of your bulk import, select Data Import > Bulk Import on the Global Settings menu.
    Note:

    If there was an error in the upload, click the link in the Result column for the import to download a report indicating the errors.

To update Object Records in bulk with templates

  1. Click the gear icon in the upper right-hand corner to access Global Settings.
  2. On the Global Settings menu, select Data Import > Import Templates.

    The Import Templates screen appears.

  3. Locate the Update Custom Object template.


    The Download Import Template modal appears.

  4. In the Object Type field, select your desired Object Type.


  5. Click the Download button.
  6. Open the downloaded file in Microsoft Excel.
  7. Complete the downloaded template for the records you want to import.
    Note:

    The bulk import process does not support the following characters when creating multiple inventory records: /, |, and ;. A new row is needed for each inventory record.

    In addition, allow the bulk import to complete before uploading more files. Files larger than 64 MB are not supported.

  8. Navigate to the Data Import > Bulk Import menu.
  9. Click the New Import button.

    The New Import modal appears.

  10. In the Import Name field, enter a name for the import.
  11. In the Import Description field, enter a brief description of the contents of the import.
  12. In the Import Type field, select Update Custom Objects.

    The Object Type field appears.

  13. In the Object Type field, select your desired Object Type.
  14. In the File field, click the Upload File button.
  15. Use the file explorer to select the spreadsheet you want to import.
    Note:

    Verify that the spreadsheet is saved as a .xlsx file.

  16. Click the Submit button. 


  17. To view the status and result of your bulk import, select Data Import > Bulk Import on the Global Settings menu.
    Note:

    If there was an error in the upload, click the link in the Result column for the import to download a report indicating the errors.