How to add Bulk Exchange Mailboxes through HC?

Question: How to add Bulk Exchange Mailboxes through HC?
Answer:
 
HC10
 
In HC10 Exchange mailboxes can be added in bulk by navigating to the path Provisioning :: Exchange Organizations :: Mailboxes :: Create Mailbox :: Add Bulk Mailboxes
 
Below is the CSV format and sample file can be downloaded from this link: Bulk-Mbx-HC10.csv
FirstName,LastName,EmailID,Password,Size,OfficeLocation,City,Country,State,ZipCode,DisplayName,Address,Phone,Mobile,
Type,JobTitle,Department,Company,Pager
 
Tony,Mark,Tony@contoso.com,P@ssw0rd,5120,,,,,,,,,,User,,,,
Mike,Alan,mike@contoso.com,P@ssw0rd,5120,,,,,,,,,,User,,,,
 
            Important: Don't insert space after comma ','
 
P.S.
  • FirstName and LastName are optional and can be set empty. In such a case, firstname will be parsed from Email ID as the first portion of email.
  • EmailID, Password, Size, and Type fields are mandatory.
  • Both user and shared mailboxes can be added in bulk.
  • You can create only 50 mailboxes at a time with the bulk option. To create more mailboxes, create multiple CSV files with up to 50 mailboxes each. 
  
HC9
 
You can add bulk exchange mailboxes in HC9 at reseller / webadmin level path Hosting Services :: Manage Exchange :: Manage Mail Domains :: Mail Domains :: Mailboxes :: Add Bulk Mailboxes

Below is the CSV format Bulk-Mbx.zip
FirstName, LastName, EmailID, Password, Size  (This line must be on top in the csv file )
  1. John, Peter, john@domain.com, W3lcome ,150  
  2. , , john@domain.com,W3lcome,250

    Note: Don't insert space after comma ',' 
Note: 
  • FirstName and LastName are optional and can be set empty. In such a case, firstname will be parsed from Email ID as first portion of email.
  • EmailID and Password fields are necessary.