Name: How to Set Up the 3CX Phone System Spreadsheet (MTV Phone Distribution Tab)
Uploaded: 2026-06-15T19:32:51.000Z
Duration: 597 s
Description: Follow these steps to manage phone assignments, update hardware details, and prepare your 3CX phone system spreadsheet for programming.

Michael Falgares

How to Set Up the 3CX Phone System Spreadsheet (MTV Phone Distribution Tab)

This is the main file you'll be working in.

This is the only tab you need to edit for phone assignments.

These columns are the ones you need to update.

Identify columns C, D, F, G, and H highlighted in yellow.

Column E lists all the rooms or locations in your building.

Review the list of locations in column E.

Remove rooms that do not exist in your building.

Delete any unnecessary room rows by right-clicking the row and selecting delete row.

Add a new row if you need to include an additional room by right-clicking and selecting add row below.

These columns show the phone models for each location.

Check columns A and B to see the hardware assigned to each room.

T33G is for most classrooms, T57W is a nicer phone for offices, AX A3H is wireless.

Identify the phone type for each room (e.g., T33G, T57W, AX A3H).

All hardware should be stored here before installation.

Locate all phone hardware in your building's boiler room.

This helps organize the installation process.

Take a cart and gather the required phones for each room.

Unbox the phone and assemble any necessary pieces.

This provides network connectivity and power (if PoE).

Plug the included Ethernet wire into the back of the phone.

Ensure the phone is connected to the network.

Plug the other end of the Ethernet wire into the wall Ethernet port.

Indicates the phone is correctly installed and powered.

If the phone powers on and lights up, change the status of that room to 'ready' in the spreadsheet.

This means the phone is installed but not receiving power.

If the phone does not light up, update the status to 'installed, no power.'

Indicates the room cannot be connected at this time.

If there is no Ethernet in the room, set the status to 'no Ethernet.'

Use this for locations like boiler rooms if applicable.

If a room does not need a phone, set the status to 'no phone needed.'

Enter the staff member assigned to each room in column G using the dropdown list.

Select the room's primary function (e.g., technology, computer lab) in the appropriate column.

Wi-Fi phones do not use Ethernet and must be set up wirelessly.

For Wi-Fi phones (AX A3H), use a cell phone to connect to the phone's Wi-Fi SSID and enter the password.

The system is now ready for final programming.

Once all rooms are updated and statuses are green for ready, notify the system administrator for programming.

Follow these steps to manage phone assignments, update hardware details, and prepare your 3CX phone system spreadsheet for programming.

3CX Phone System Setup and Spreadsheet Guide

Introduction and Overview of Spreadsheet

Phone Types and Hardware Location

Phone Installation and Status Updates

Assigning Staff and Room Functions

Wi-Fi Phone Setup and Final Instructions

This video provides a detailed walkthrough for setting up a 3CX phone system spreadsheet, focusing on the MTV phone distribution tab. It explains how to manage phone assignments by room, including adding or deleting rows, identifying phone types, and connecting phones via Ethernet or Wi-Fi. The video also covers how to update the spreadsheet with phone serial numbers, MAC addresses, and staff assignments, ensuring the system is ready for programming.

How to Set Up the 3CX Phone System Spreadsheet (MTV Phone Distribution Tab)

You made it to the end!