How to…Complete a Mass Upload of Leads or Accounts

Select the Admin icon in the Buddy Bar, followed by Data Management and ImportCSV in BuddyCRM.

admin menu item in BuddyCRM

 

import csv in admin section of BuddyCRM

From here, you should select either Upload Account CSV or Upload Lead CSV.

Screen Shot 2013-11-05 at 16.10.46

You should prepare your data in an Excel Spreadsheet and save it as a CSV file. There are certain mandatory fields that will need to be completed:

  • Company Name
  • Owner email (i.e.sales person)
  • Title
  • First Name
  • Surname
  • Account profile
  • Rating type (for accounts)
  • Lead Source
  • Lead Status (for leads)
  • Contact Frequency

Ensure that there are no commas within the data.

Once your data is prepared, select Choose File and select the spreadsheet you wish to upload.

 

Screen Shot 2013-11-05 at 16.39.06

In this example, I have shown a record I wish to upload to BuddyCRM that is a lead.

 

Screen Shot 2013-11-05 at 16.38.03

 

Once I have selected this file, the data will appear in BuddyCRM.

 

The next step is to match all of the BuddyCRM fields with the fields I have uploaded.

 

Screen Shot 2013-11-05 at 16.41.54

 

In this example, I have already matched Owner Email ID and Company Name, I now need to match all the other fields. Once this is done, click Validate. BuddyCRM will tell you if all the records are valid or if there were any issues with the data. If there are no problems with the data, then click Validate and Save and your records will now be saved in your BuddyCRM.