---
title: Uploading Contacts to Peer to Peer Campaigns
description: When uploading phone numbers and their coinciding names to a Peer to Peer campaign, your spreadsheet needs a specific format to work properly.
---

[Skip to content](https://help.textrequest.com/uploading-contacts-peer-to-peer#main-content)

[![favicon-256.png\]](https://help.textrequest.com/hs-fs/hubfs/favicon-256.png?width=30&height=30&name=favicon-256.png)](https://help.textrequest.com/?hsLang=en)

Open main navigation

Close main navigation

- [Back to textrequest.com](https://www.textrequest.com/)

[Back to textrequest.com](https://www.textrequest.com/)

 Hi! How can we help you today?

- There are no suggestions because the search field is empty.

1. [Text Request Help Center](https://help.textrequest.com/?hsLang=en)
2. [Messages](https://help.textrequest.com/messages?hsLang=en)
3. [Peer to Peer](https://help.textrequest.com/messages?hsLang=en#peer-to-peer)

# Uploading Contacts to Peer to Peer Campaigns

## When uploading phone numbers and their coinciding names to a Peer to Peer campaign, your spreadsheet needs a specific format to work properly.

The file should be saved as a .csv (Comma Separated Values).

**Numbers should be in column A** and **names should be in column B**. 

 

![spreadsheet-example](https://help.textrequest.com/hs-fs/hubfs/spreadsheet-example.png?width=621&name=spreadsheet-example.png)

Other formatting requirements include:

- No data in any other columns
- No header row
- No commas in phone numbers or names

**If you are importing contacts for a text merge message:**

 The file should be saved as a .csv or .xlsx file containing merge data.

- Column names in first row
- Phone numbers in first column

If your file is not in the correct format, it will not upload correctly.

### Tips for Troubleshooting a Spreadsheet That Won't Import

Double check the following formatting requirements:

**1.** Copy only the cells with data, and paste them into a new spreadsheet

**2.** Remove all additional characters in phone numbers, including periods, dashes, parentheses

**3.** Check for empty cells

**4.** Check for special or odd characters

### How to Remove Unwanted Characters From a Spreadsheet

Let’s say you have a bunch of commas that are preventing the .csv file from uploading properly. 

To remove those commas:

**1.** Select the cells where you want to delete the commas

**2.** Press Ctrl + H to open the **Find and replace** box

**3.** Type the comma into the **Find** section

**4.** Leave the **Replace with** section empty

**5.** Select **Replace All**

You can repeat these steps as needed for other characters.

 

- [Basics](https://help.textrequest.com/basics?hsLang=en#main-content)

    - [Account Essentials](https://help.textrequest.com/basics?hsLang=en#account-essentials)
    - [Profile Settings & Preferences](https://help.textrequest.com/basics?hsLang=en#profile-settings-preferences)
- [Messages](https://help.textrequest.com/messages?hsLang=en#main-content)

    - [Conversations](https://help.textrequest.com/messages?hsLang=en#conversations)
    - [Messaging Features](https://help.textrequest.com/messages?hsLang=en#messaging-features)
    - [Group Messages](https://help.textrequest.com/messages?hsLang=en#group-messages)
    - [Sequences](https://help.textrequest.com/messages?hsLang=en#sequences)
    - [Peer to Peer](https://help.textrequest.com/messages?hsLang=en#peer-to-peer)
- [Contacts](https://help.textrequest.com/contacts?hsLang=en#main-content)

    - [Individual Contacts](https://help.textrequest.com/contacts?hsLang=en#individual-contacts)
    - [Groups](https://help.textrequest.com/contacts?hsLang=en#groups)
    - [Managing Contacts](https://help.textrequest.com/contacts?hsLang=en#managing-contacts)
- [Payments](https://help.textrequest.com/payments?hsLang=en)
- [Settings](https://help.textrequest.com/settings?hsLang=en)
- [Reports](https://help.textrequest.com/reports?hsLang=en)
- [Integrations](https://help.textrequest.com/integrations?hsLang=en#main-content)

    - [Text Request Extras](https://help.textrequest.com/integrations?hsLang=en#text-request-extras)
    - [Third-Party Integrations](https://help.textrequest.com/integrations?hsLang=en#third-party-integrations)
    - [Mobile App](https://help.textrequest.com/integrations?hsLang=en#mobile-app)
- [Users](https://help.textrequest.com/users?hsLang=en)
- [Dashboards](https://help.textrequest.com/dashboards?hsLang=en)
- [Account](https://help.textrequest.com/account?hsLang=en#main-content)

    - [10DLC Registration](https://help.textrequest.com/account?hsLang=en#10dlc-registration)
- [Reviews](https://help.textrequest.com/reviews?hsLang=en)

[![TR Esendex Footer](https://help.textrequest.com/hs-fs/hubfs/Help%20Center/TR%20Esendex%20Footer.png?width=225&height=45&name=TR%20Esendex%20Footer.png "TR Esendex Footer")](https://www.textrequest.com)

<https://www.facebook.com/textrequest> <https://www.instagram.com/text.request/> <https://www.linkedin.com/company/text-request/> <https://www.youtube.com/channel/UCK9nIj2I6ySehywIzKErmig> <https://twitter.com/text_request>

Copyright © 2026, Text Request