Skype for Business – Import Common Area Phones from CSV

I recently had a customer that required 90 Common Area Phones creating in Skype for Business.  This is quite a tedious task so the easiest way is to populate a CSV and use a PowerShell script to do the import.

When creating a Common Area Phone in Lync/SfB it can take a few seconds before you’re able to assign Policies and Pin numbers to the objects.  This slows the script down significantly if waiting 20 seconds between creating the object, then assigning Policies.  So, I’ve actually made three ForEach loops, the first one creates the Common Area Phone objects, then it waits 20 seconds before assigning policies to every object, then it waits another 20 seconds before assigning the pins (I found that assigning Pins would fail if I didn’t wait longer).

Tip – To generate 90 pin numbers I used  Set Characters to “Digits” and Output Result to “Txt File”.  You can then copy and paste into your CSV in Excel.

Here is an example CSV file (CommonAreaPhones.csv):

Here is the PowerShell script:

Note – If the script fails assigning policies / pins due to not pausing long enough, you can hash out the “New-CsCommonAreaPhone” line and re-run the script to re-assign the policies and pins.  You can also use this method if you need to change any policies.


Author: Chris Hayward

Share This Post On


  1. Skype for Business – Import Common Area Phones from CSV | – JC's Blog-O-Gibberish - […] […]
  2. Monthly IT Newsletter – January 2017 – Guy UC World - […] Skype for Business – Import Common Area Phones from CSV […]
  3. Cheat sheet - Skype for Business | - […] Import Common Area Phones with a CSV file […]

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.