What's a CSV file?

A. A Comma Separated Values (CSV) file is an ASCII file in which commas delimit the individual data fields. Microsoft Exchange Administrator can import or export directory data (including mailbox objects, custom recipients, and distribution lists) as CSV files. Here’s the beginning of a sample CSV file (we see the header, the first record, and part of the second record):

Obj-Class,Mode,First Name,Last name,Display Name,Alias Name,Directory <br>
Name, Primary Windows NT Account,Home-Server,E-mail address,E-mail<br> Addresses,Members, Obj-Container,Hide from AB<br>
Mailbox,create,Jim,Hood,Jim<br>
Hood,JimH,JimH,RA\JimH,HSV1,,MS:RA/HSV/hood%<br>
SMTP:[email protected]%X400:c=US;a= ;p=Robichaux ?<br>
Asso;o=US;s=Hood;g=Jim;,, /ou=US/cn=Recipients, <br>
Mailbox,delete,Chuck,Farnsworth,Chuck<br>
Farnsworth,ChuckF,ChuckF,,,,,,,

You can export a CSV file from Exchange Server, edit it, and reimport it to create or remove objects or change their attributes. Because CSV files are just ASCII text, you can easily manipulate them with Excel, Perl, VBScript, or other text-editing tools.

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish