3CX PBX in the Cloud
1 year FREE - no ties!
google cloud platform
Zero Admin
With the new Dashboard
Bulletproof Security
With SSL certs and NGINX
Install on $200 Appliance
Intel MiniPC architecture
New, Intuitive Windows Client
More themes, more UC
More CRM Integrations
Scripting Interface to add your own
Improved Integrated Web Conferencing
iOS and Android apps included
Run On-Premise or in the Cloud
Google, OVH, Windows & Linux
Fast & easy call management
With the 3CX Web Client

How to Create Extensions in Bulk using a .csv file

How to Create Extensions in Bulk using a .csv file

On this topic

How to Create Extensions in Bulk using a .csv file


Method 1


Method 2


3CX administrators need to plan ahead on how to construct their 3CX Phone System. It can be very time consuming to create extensions one-by-one, along with their settings and provisioning.

There are two very simple ways to speed up this process – creating a .csv file and importing it or creating one extension and then export extensions to a .csv. You can create any number of extensions in seconds.

Method 1

Here are sample import files for each version of 3CX Phone System:

Download the sample file for your version and create your PBX configuration to your specifications. Each column is hard-coded in the 3CX Import function and the position of the column must remain as is. The comma delimited file provides the structure of the columns and how they should be named in Row 1. Row 2 contains an example which will create an extension with provisioning.

The table below explains the field requirements and options for 3CX Phone System Version 15.5. For Version 15, download the example csv file above.

Field Name


Possible Values


Extension Number

Numeric values only


First Name



Last Name



Email Address



Mobile Number

Numeric values only


SIP Authentication ID



SIP Authentication Password



Webmeeting Friendly Name

Extension MUST have an email address and Name. This will be the alphanumeric ID for the webmeeting URL for this extension.


Create new room for each participant

0 – Generate new room for each new anonymous participant

1 – Shared room for all anonymous participants





Moderate participants

0 – Disable Moderate participants

1 – Enable Moderate participants


Enable Voice Mail Box for this extension

0 – VoiceMail is disabled

1 – VoiceMail is enabled


Disable Voicemail PIN authentication

0 – Pin Authentication for VoiceMail is disabled

1 – Pin Authentication for VoiceMail is enabled


Play Caller ID

0 – Do not play Caller ID

1 – Play Caller ID


PIN number used to access Voicemail box



Read out date/time of message

0 – Do not read Date/Time of message

1 – Read in AM/PM Format

2 – Read in 24hr format


Email options

0 – No email notification is generated when the extension receives VoiceMail

1 – Email notification is sent

2 – Email Notification with voicemail attached will be sent.

3 – Email notification with vmail attached will be sent and vmail file will be deleted from the server.


Queue status

0 – Logged out of Queues

1 – Logged in Queues


Outbound Caller ID

Alphanumeric – Configures the Outbound Caller ID for the extension



Alphanumeric – Configures the SIP ID for the extension


PBX delivers Audio

0 – PBX does not deliver audio

1 – PBX delivers audio


Supports Re-invite

0 – Reinvites not supported

1 – Reinvites supported


Support Replaces header

0 – Does not support Replaces Header

1 – Supports Replaces Header


Switch on Secure RTP (SRTP)

0 – Disabled

1 – Secure SRTP on


Allow 3CX Management Console Access

0 – 3CX Management Console access not allowed

1 – 3CX Management Console access enabled + user can manage his own Extension

2 – 3CX Management Console access enabled + User is set as Group / Department manager (can manage the extensions of the groups he is a member of)

3 – 3CX Management Console access enabled + user is set as a Global Extension Manager (can manage all user extensions on the System)


Allow 3CX Web Reports Access

0 – 3CX Reports access not allowed

1 – 3CX Reports access enabled


Allow 3CX Wallboard Access

0 – 3CX Wallboard access not allowed

1- 3CX Wallboard access enabled


Disallow use of 3CXPhone

0 – 3CX Client use is enabled

1 – 3CX Client use is disabled


Hide Forwarding Rules

0 – Forwarding Rules tab enabled in 3CX Client

1 – Forwarding Rules tab disabled in 3CX Client


Show Call Recordings

0 – Call recordings not shown to the user

1 – Call recordings shown to the user


Allow deletion of recordings

0 – Does not allow the deletion of recordings by the user

1 – Allows deletion of recordings by the user


Record all calls

0 – Do not record all calls

1 – Record all calls for this extension


Call screening ON

0 – No Call Screening

1 – Enable Call Screening


Send email notification on missed call

0 – Do not send email notification on missed call

1 – Send email notification on missed call


Disable Extension

0 – Extension is enabled

1 – Extension is disabled


Disable External Calls

0 – External calls enabled

1 – External calls disabled


Disallow the use of extension outside the LAN

0 – Use of extension outside LAN is enabled

1 – Use of extension outside LAN is disabled


Block Remote Tunnel Connections

0 – Remote tunnel connections enabled

1 – Remote tunnel connections disabled


Pin Protect

Numeric value in seconds – user has to type a pin to allow external calls in the time allocated


MAC Address

MAC Address of the first provisioned phone


Select Interface

3CX Phone System IP address


Use 3CX Tunnel for Remote Connections (3CX Client only)

0 – Do not use tunnel for Remote Connections

1 – Use tunnel for Remote Connections



0 – Do Not Disturb off

1 – Do Not Disturb on


Configure default phone to use in 3CX Phone for windows

empty – default phone to use in 3CX Client for windows not specified

0 – Use Inbuilt Softphone

1 – use IP Phone via CTI


Default Startup Screen

0 – Dialpad as Start up screen

1 – Presence screen as Start up screen


Allow 3CX Hotel Module Access

0 – Extension cannot access 3CX Hotel module

1 – Extension can access 3CX Hotel module


Do not show Extension in 3CX Company phonebook

0 – Extension is shown in 3CX Company Phonebook

1 – Extension is not shown in 3CX Company Phonebook


Phone Web Page Password

Alphanumeric – this is the password used to access the IP Phone’s web configuration pages.


Access password for 3CX Web Services

Alphanumeric – this is the password used to access the 3CX Web services (3CX Management Console)


Voip Trunk Administrator

0 – User is not allowed to manage VoIP Gateways, VoIP Providers and 3CX Phone System Bridges

1 – User is allowed to manage VoIP Gateways, VoIP Providers and 3CX Phone System Bridges


System Administrator

0 – User is allowed to modify System Extensions (Queues, Ring groups, Digital Receptionists), change System Settings and perform 3CX Phone System Updates

1 – User is not allowed to modify System Extensions (Queues, Ring groups, Digital Receptionists), change System Settings and perform 3CX Phone System Updates


Enable Secure SIP (TLS)

0 – Secure SIP is not enabled for this user

1 – Secure SIP is enabled for this user


Phone Model name

Model of the first provisioned phone


Template used by the  IP phone for provisioning

Template file name


Custom template used for Hardpphone provisioning

Custom template file name


Custom Settings of Phone from extension

Custom settings of the first provisioned phone will be shown in the following format:

<PhoneDevice ProvType="0" PhoneLanguage="English" XferType="BXfer" RingTone="Ring 1" DateFormat="WWW MMM DD (Mon Jan 15)" TimeFormat="24-hour clock"


Ability to download All Recordings

0 – Not allowed to download all recordings

1 – Allowed to download all recordings


Enable Push for Smartphones

0 – Push notifications disabled

1 – Push notifications enabled


Enable Integration for the Extension with 3CX Plugins

Empty – Disable Integration. To enable Integration you need to set specific plugin . For example salesforce.zip. In order to find out the correct name for your plugin download the plugin that you need and then go to Management console → Settings → CRM Integration to see the file name of the plugin


If using Microsoft Office to open CSV files, take care that the MAC Address column is NOT presented as a number. If the MAC Address starts with zeros, Excel might remove any leading zeros. This will break file formatting. To fix, right-click on the MAC address column, select Format Cells… and choose text.

Method 2

Instead of following the method outlined above, you can create at least one extension, then export your extensions to a .csv. When you export an extension, the columns required will be created in the exported .csv file. You can then populate this .csv file, with your users, and import it back in, using the method below.

To import Extensions from the .csv file:

  1. Log in to the 3CX Management Console and click on the Extensions node.
  2. Click on the Import button, and select Import CSV.
  3. Browse for your extension CSV file, select it and click Open to import your extension to the 3CX Phone System.

If you need to export your extensions to a CSV file format to either save them as backup or to make a lot of changes to the users follow the next steps:

  1. Log in to the 3CX Management Console and click on the Extensions node.
  2. Select the extensions that you want to export and click on the “Export” button.(You can use the Shift or Ctrl keys to choose multiple extensions)
  3. Type in a filename and save the CSV file.


  • If a row is configured to an extension that already exists in 3CX Phone System, the whole row will be skipped.
  • Provisioning information will be generated if the filename is exactly identical to the names of the models in the template.
  • Provisioning information will not be generated if the IP Address Interface in field 25 does not match a valid IP on which the phone will request the provisioning file. This entry must match one of the entries shown in the Edit Extensions section → Phone Provisioning tab → Select Interface drop down.
Get 3CX Free for 1 Year Today
Download On-Premise Try in the Cloud