Sourcetable Integration

Export Microsoft Teams phone numbers to CSV

Jump to


    Welcome to our comprehensive guide on how to export Microsoft Teams phone numbers to a CSV file. As businesses continue to integrate Microsoft Teams into their communication strategies, maintaining an organized directory of phone numbers becomes crucial. Exporting these numbers to a CSV file allows for better management and integration into various applications, like spreadsheets, where they can be sorted, filtered, and analyzed with ease. On this page, we will delve into the specifics of Microsoft Teams phone numbers, provide a step-by-step guide on exporting them to a CSV file, explore use cases for this data, introduce an alternative method for CSV exports using Sourcetable, and answer some frequently asked questions. Stay tuned to streamline your communication management efforts with these effective techniques.

    Microsoft Teams Phone Numbers

    Microsoft Teams phone numbers is a service feature within the Microsoft Teams platform that allows organizations to manage telephone functionality for their users. This service integrates traditional telephony features with the collaborative environment of Teams, providing a comprehensive communication solution. It supports both user numbers for individuals and service numbers for services like Audio Conferencing and Call Queues, with varying concurrent call capacities and geographic or non-geographic attributes.

    The Microsoft Teams phone numbers service is managed through the Microsoft Teams admin center, where administrators can acquire new phone numbers for users, port existing numbers, assign numbers to users or services, and view all phone numbers associated with their organization. The service extends its features to include cloud auto attendants, call queues, and a variety of call management options such as call forwarding, sharing, parking, and blocking to enrich the user experience within the Microsoft Teams environment.

    Exporting Microsoft Teams Phone Numbers to a CSV File

    Using Teams Admin Center

    To view and export telephone numbers in your organization, start by accessing the Microsoft Teams admin center. Once there, click on 'Voice' followed by 'Phone numbers'. To refine your search, you can use the filter icon to view phone numbers by number range, activation state, number type, or status. This method allows you to see users with phone numbers directly in the admin center.

    Using PowerShell

    For a more comprehensive export, including call queues and auto attendants, use the Teams PowerShell module. Employ the 'Get-CsPhoneNumberAssignment' cmdlet to retrieve a list of all telephone numbers within your organization. Additionally, the 'Get-CsOnlineUser' cmdlet can be utilized to ascertain which telephone numbers are specifically assigned to users.

    Using Get-TeamsAssignedNumbers Script

    The 'Get-TeamsAssignedNumbers' script, authored by Andrew Morpheth and available on GitHub, exports all phone numbers to a CSV file. This script is particularly useful as it includes numbers for users, call queues, and auto attendants. Note that the script lists call queues and auto attendants twice. Please ensure that you have the necessary Azure AD roles, namely Skype for Business Administrator and Teams Administrator, before running this script.

    Sourcetable Integration

    Effortlessly Import Microsoft Teams Phone Numbers with Sourcetable

    With Sourcetable, you can streamline your workflow by directly importing Microsoft Teams phone numbers into a dynamic and user-friendly spreadsheet environment. Unlike the traditional method of exporting to CSV and then importing to another spreadsheet program, Sourcetable simplifies the process, saving you time and reducing errors. It syncs your live data from various apps or databases, including Microsoft Teams, ensuring that your phone number lists are always up-to-date.

    By utilizing Sourcetable, you leverage the power of automation for your business intelligence tasks. Rather than dealing with static CSV files, Sourcetable's automatic data pulling feature means that your spreadsheets reflect real-time information. This is ideal for maintaining accurate records in fast-paced business settings where timely decisions are crucial. Say goodbye to the manual import-export hassle and embrace the efficiency of Sourcetable for your data integration needs.

    Common Use Cases

    • M
      Sourcetable Integration
      Sync contacts across different Microsoft 365 accounts
    • M
      Sourcetable Integration
      Manually sync contacts across different Microsoft 365 accounts
    • M
      Sourcetable Integration
      Export and import team members from Teams
    • M
      Sourcetable Integration
      Import contacts from iCloud into Teams

    Frequently Asked Questions

    Who is the author of the script to export Microsoft Teams phone numbers to CSV?

    The script is written by Andrew Morpheth.

    What roles are required to run the script for exporting Microsoft Teams phone numbers to CSV?

    The script requires the Skype for Business Administrator and Teams Administrator roles in Azure AD.

    Where can I find the script to export Microsoft Teams phone numbers?

    The script is available on Github.

    What information will be exported using the script for Microsoft Teams phone numbers?

    The script exports phone numbers for users, call queues, and auto attendants.

    Does the new feature in Microsoft Teams admin center allow for exporting of phone numbers?

    Yes, the feature being added to Microsoft Teams admin center allows for data to be downloaded from list pages as a CSV file, including applying filters to export filtered lists of items.


    Our comprehensive guide has detailed the use of the Get-TeamsAssignedNumbers script, developed by Andrew Morpheth, to efficiently export all Microsoft Teams phone numbers to a CSV file. This script, which is readily available on GitHub, is essential for administrators with the necessary Azure AD roles‚ÄĒSkype for Business Administrator and Teams Administrator. While it is noted that the script may list call queues and auto attendants twice, it remains a robust solution for exporting assigned numbers from Teams. However, if you are looking for a more streamlined approach that eliminates the need for manual exports to CSV, consider using Sourcetable. Sourcetable allows you to directly import your data into a spreadsheet, providing a more integrated experience. Sign up for Sourcetable today to get started and simplify your data management tasks.

    Start working with Live Data

    Analyze data, automate reports and create live dashboards
    for all your business applications, without code. Get unlimited access free for 14 days.