Skip to main content
CallSprout
Your phone system version
Which version am I on?

Most accounts are on version 8. If you're not sure which version your phone system runs, ask your admin or CallSprout support.

Import and export contactsImport and export the company phone book

  • Audience: Admins

Last updated

Use a CSV file to add a whole list of contacts at once instead of typing each one. You can also export contacts to a file. Importing needs an administrator or department administrator role. See company, department and private contacts for who can do what.On version 7, you do this in the company phone book. See how the company phone book works. An upload replaces every contact already in it.

Some labels in your portal or apps may look slightly different from this guide.

Prepare your file

The first row must be the header row, with these columns exactly: name,last_name,company,contact_type,phone,phone_label,email,email_label,fbUserId,notes. Don't rename, remove or add columns. If the import rejects your header row, ask CallSprout support for a sample file.

Contact CSV columns
ColumnNeeded?What goes in it
nameYesThe first name.
last_nameYesThe last name.
companyNoThe company name.
contact_typeYesEither customer or lead.
phoneNoThe number with a plus sign and country code, like +12125550134. A US number without +1 may fail or import wrong.
phone_labelNoA label such as home, work, mobile or other.
emailNoThe email address.
email_labelNoA label such as private, business or other.
fbUserIdNoA Facebook user ID, if you have one.
notesNoAnything you want to keep with the contact.

The portal offers a template with the right header. Start from it, so you don't have to build the file by hand.

Version 7

Start from the template. In the admin portal, open Contacts, then Central Phone Book, and choose Download CSV Template. Each row holds the first name, middle name, last name, email and company, then one or more numbers. Write each number as its type, a colon and the number, for example mobile:5550142. The types are Work, Mobile, Home and Fax, in any letter case. A number with any other type is skipped. Put any value that contains a comma inside quotes.

Import a file

  1. Step 1:
    Open the import tool

    In the admin portal, open Contacts, then CSV Manager.

  2. Step 2:
    Choose who sees the contacts

    Pick Global, Private (and choose the extension that owns them), or Department (and choose the departments). Every contact in the file gets that visibility.

  3. Step 3:
    Pick your file

    Choose Choose File and select your CSV. Use Template if you need a blank copy.

  4. Step 4:
    Upload

    Select Upload and wait for the job to finish.

  5. Step 5:
    Check the results

    Select Details next to the finished job to see any rows that failed.

Version 7
Warning
An upload deletes every contact in the phone book and replaces them with the contents of your file. The portal asks you to confirm first. Export your current contacts before you upload, so you have a copy.
  1. Open Contacts, then Central Phone Book.
  2. Choose CSV Upload and pick your file.
  3. Read the warning, then confirm to replace everything.
  4. Open the list and check that your contacts are there.

There's no list of failed rows on version 7, and no merge, so check your file against the template before you upload.

Fix rows that failed

The details list shows each failed row with its row number, name and a reason. The header counts as row 1, so the first contact is row 2.

Common import errors
Reason shownWhat to fix
First name is requiredFill in the name column for that row.
Last name is requiredFill in the last_name column.
Invalid contact typeUse customer or lead in contact_type.
Invalid CSV formatLook for a missing or extra column, or a quote that never closes.

Correct the file and import it again. Contacts that already exist are updated, not copied, so you can upload the whole file a second time.

Import from the Communicator app

A person whose extension has the right can import from the app too. In Communicator, open Contacts, then the External tab, and select Import File. The button doesn't show for people without that right. The app shows a total, and how many contacts are new, updated or failed. See company, department and personal contacts.

Export contacts

Choose which contacts you want: Global, the Private ones for one extension, or a department. Then select Download to get a CSV file. In the company phone book, select CSV Download. You get one CSV file with everything in the phone book. The file may also hold people's personal phone book entries. Take those rows out before you upload the file again.

Still stuck? Contact support

Our team in West Palm Beach can walk you through it. Tell us your name, your company and what you were trying to do.

Get a live call from our AI agent in about 10 seconds.