---
title: Bulk Remove Users’ Phone Numbers from Google Workspace with GAT+
description: "GAT+ is a tool for [Google Workspace Admin](https://workspace.google.com/) to comprehensively analyze and manage the domain, drives, users, etc. easily. The administrator can update the details of many users in the domain at once by using the \"export/import\" feature in [GAT+](https://gatlabs.com/knowledge/tech-tips/gat-overview/).…"
url: "https://gatlabs.com/knowledge/tech-tips/bulk-remove-users-phone-numbers-from-google-workspace-with-gat/"
updated: "2023-02-23"
category: "Users Audit & Management"
tags:
  - GAT+
---

# Bulk Remove Users’ Phone Numbers from Google Workspace with GAT+

GAT+ is a tool for [Google Workspace Admin](https://workspace.google.com/) to comprehensively analyze and manage the domain, drives, users, etc. easily. The administrator can update the details of many users in the domain at once by using the "export/import" feature in [GAT+](https://gatlabs.com/knowledge/tech-tips/gat-overview/). They can also update or remove users' phone numbers in bulk from the Google workspace.

## Step 1. Export User Information

Navigate to ***GAT+** > **Users***(1)*> **Basic*** (2) tab.

Click on the button ***Export data*** (3) above the table.

Then, select ***Export to Google Sheet (max 150 000 records)***, from the drop-down menu.

*Note: Do not select Export to Google Sheet (max 150 000 records) (visible columns), as it is not editable.*![](https://gatlabs.com/knowledge/wp-content/uploads/2023/02/Remove-mobile-number-1024x310.png)

## Step 2. Update Phone Numbers

When the sheet is exported, a small message appears in the top right corner of the dashboard. Click '**Click to view'**to open the Google Sheet.

![](https://gatlabs.com/knowledge/wp-content/uploads/2023/02/Click-to-view-1024x120.png)

In the spreadsheet that is opened, navigate to the **Phones** column and delete the details that is not required.

![](https://gatlabs.com/knowledge/wp-content/uploads/2023/02/Delete-phones.png)

Once done, close down the spreadsheet and go back to the GAT+ console.

## Step 3. Import the Edited Spreadsheet

To implement the changes, import the spreadsheet by navigating to **GAT+ > Users > Basic** and clicking the button **Import data**.

![](https://gatlabs.com/knowledge/wp-content/uploads/2023/02/Import-changes-1024x118.png)

A notification window, **Import data via spreadsheet** pops up. In the **Google Drive** tab of the same popup, the just edited file will be shown.  Select the **Choose** button beside the file name and next to the eye icon to proceed to the next step.\`

![](https://gatlabs.com/knowledge/wp-content/uploads/2023/02/Choose-to-proceed-1024x337.png)

In the next stage, the expanded information would appear.

![](https://gatlabs.com/knowledge/wp-content/uploads/2023/02/Accept-1024x573.png)

To preview the changes made, navigate to the "Phone list" column by moving the slider bar to the right. You will notice the changes made highlighted by '**Before**' and '**After**' in each row under the same column, where Before denotes the previous information and After denotes the new changes.

Once ready, click on **Accept** button.

![](https://gatlabs.com/knowledge/wp-content/uploads/2023/02/Before-and-after-1024x490.png)

## Results

The above action will remove the phone numbers of all or selected users in the domain.

## Related Posts

- [Create and Manage Domain Shared Contacts with GAT+](https://gatlabs.com/knowledge/tech-tips/create-and-manage-domain-shared-contacts-with-gat/)
- [Find and Take Actions on Externally Shared Files with GAT+](https://gatlabs.com/knowledge/tech-tips/find-and-take-action-on-all-shared-out-files-and-folders-in-a-domain/)
- [Identify Externally Owned Files Shared into the Domain with GAT+](https://gatlabs.com/knowledge/tech-tips/identify-externally-owned-files-shared-into-the-domain-with-gat/)