What's a CSV file?

Paul Robichaux

February 28, 2001

1 Min Read
ITPro Today logo in a gray background | ITPro Today

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 
Name, Primary Windows NT Account,Home-Server,E-mail address,E-mail
 Addresses,Members, Obj-Container,Hide from AB
Mailbox,create,Jim,Hood,Jim
Hood,JimH,JimH,RAJimH,HSV1,,MS:RA/HSV/hood%
SMTP:[email protected]%X400:c=US;a= ;p=Robichaux ?
Asso;o=US;s=Hood;g=Jim;,, /ou=US/cn=Recipients, 
Mailbox,delete,Chuck,Farnsworth,Chuck
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.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like