> ## Documentation Index
> Fetch the complete documentation index at: https://help.broadstripes.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Changing phone contact info in bulk

> Recipe for switching many phone numbers to a different phone type (and setting texting permissions) by downloading contacts and re-importing updated contact info.

On occasion, you will need to change phone numbers from one phone type to a different phone type (e.g., Home phone to cell phone). When you need to switch many phone numbers, changing the phone types (or other phone metadata) one by one could become tedious. There is a more efficient way to change phone types in bulk by downloading contacts and importing updated contact info back into Broadstripes. This can be useful when changing phone types and messaging permissions for texting.

This recipe uses the [round-trip update pattern](/docs/data-import-admin/update-contacts-with-an-import): download, edit, delete the old info, and re-import matching on Broadstripes ID.

Here is an example of how to change phone types (and other metadata) in bulk:

1. Add a Flexible Contact Info column to your layout that includes only "Phones" (not "Cell phones"). This should be the only column in your search layout besides **Contact**.

<img src="https://mintcdn.com/broadstripes/j5swCIBkxE0SPEuR/images/data-import-admin/PhoneTypeBulkChangeFlexContactInfo.png?fit=max&auto=format&n=j5swCIBkxE0SPEuR&q=85&s=fcdf16f3d928f4152df64de09b39f6c0" alt="Flexible Contact Info column setup" width="523" height="257" data-path="images/data-import-admin/PhoneTypeBulkChangeFlexContactInfo.png" />

2. Select the contacts that you want to update.

3. Download the data to a spreadsheet. You can download a CSV or an XLSX. Be sure to use your current working layout and select the **One row per contact** checkbox.

<img src="https://mintcdn.com/broadstripes/j5swCIBkxE0SPEuR/images/data-import-admin/PhoneTypeBulkChangeSpreadsheetDL.png?fit=max&auto=format&n=j5swCIBkxE0SPEuR&q=85&s=36857100d4eece79c2721ed8b36cfafb" alt="Download spreadsheet options" width="766" height="293" data-path="images/data-import-admin/PhoneTypeBulkChangeSpreadsheetDL.png" />

4. Delete the old phone numbers using the **Actions** menu and select **Delete contact info** from the dropdown list. When the **Bulk Delete Contact Info** panel appears, select **Phones**. You can also choose specific phone groups to delete if applicable. Click **Delete**.

<img src="https://mintcdn.com/broadstripes/j5swCIBkxE0SPEuR/images/data-import-admin/PhoneTypeBulkChangeDeleteOld.png?fit=max&auto=format&n=j5swCIBkxE0SPEuR&q=85&s=ba573356ed44cbfc7489735b2a7e423c" alt="Delete old phone numbers" width="400" height="439" data-path="images/data-import-admin/PhoneTypeBulkChangeDeleteOld.png" />

5. Edit the downloaded spreadsheet and make the following changes:
   * Change the column header from "Personal Phone" to "Personal Cell Phone" (If you are using other types of phone groups like Business Phone, also insert Cell into the column header.)
   * Add a column named "Personal cell phone permission" with the text "Opted in" in each row
   * Add a column named "Personal cell phone permission reason" with one of the following reasons in each row:
     * Signed paper form
     * Submitted online form
     * Clicked emailed link (or sent an email)
     * Sent a text message
     * Gave verbal instructions
     * Is a bargaining unit member
     * Set in external system
   * You can delete all other columns except the **Broadstripes ID** column.

<img src="https://mintcdn.com/broadstripes/j5swCIBkxE0SPEuR/images/data-import-admin/PhoneTypeBulkChangeSpreadsheetDataImport3.png?fit=max&auto=format&n=j5swCIBkxE0SPEuR&q=85&s=e7c6a26f865499a8808ca454ef2af04f" alt="Edited spreadsheet for import" width="556" height="267" data-path="images/data-import-admin/PhoneTypeBulkChangeSpreadsheetDataImport3.png" />

6. [Import the new spreadsheet](/docs/data-import-admin/import-a-spreadsheet) into Broadstripes. Check **Match?** on the **Broadstripes ID** column, and be sure that the columns match in the **Define data mappings** section.

<img src="https://mintcdn.com/broadstripes/j5swCIBkxE0SPEuR/images/data-import-admin/PhoneTypeBulkChangeDataMapping.png?fit=max&auto=format&n=j5swCIBkxE0SPEuR&q=85&s=5fe043419fe5f9dd3a5de272f444bdb5" alt="Data mapping for phone import" width="753" height="216" data-path="images/data-import-admin/PhoneTypeBulkChangeDataMapping.png" />

Once the data import is complete, your contacts will be updated with a new phone type and messaging permissions.
