XADM: Using Bulk Import to Remove Data

Article translations Article translations
Article ID: 152854 - View products that this article applies to.
This article was previously published under Q152854
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all


This article explains how to use the Bulk Import functionality of the Microsoft Exchange Administrator program to remove data from specific fields of the user properties.


To remove data from specific fields, use ~DEL as the value of that field in the import file (.CSV file). When the Import is performed, the data in the fields with ~DEL as the value will be removed.

For example, say the Office field for each user needed to be cleared out. The following import file shows how this can be done.
Obj-Class,  Directory Name,  Office
Mailbox,  Admin,  ~DEL
Mailbox,  User1,  ~DEL
Mailbox,  User2,  ~DEL


Article ID: 152854 - Last Review: September 30, 2013 - Revision: 3.3
  • Microsoft Exchange Server 4.0 Standard Edition
  • Microsoft Exchange Server 5.0 Standard Edition
  • Microsoft Exchange Server 5.5 Standard Edition
kbnosurvey kbarchive kbhowto kbusage KB152854

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com