Preparing Your Book of Business into a .CSV File for Uploading

Table of Contents

  1. Import an existing CSV file of contacts into Hearsay Relate
  2. Save your Excel file as a CSV file
  3. Lotus Notes
  4. Salesforce
  5. Microsoft Dynamics
  6. Redtail
  7. LinkedIn
  8. Outlook (Newer Versions)
  9. New Outlook for the Web
  10. Classic Outlook for the Web
  11. Yahoo!
  12. Gmail

If you already have a list of contacts stored in any of the programs in this article, it should take you approximately 5 minutes to export it, convert it into a CSV (Comma Separated Values) file, then import the CSV file into Hearsay Relate.

If the program, website, or app you use is not on list, please refer to their documentation and help materials to find out how to export your contacts then follow the instructions under the Import an existing CSV file of contacts into Hearsay Relate and Save your Excel file as a CSV file section below.

If you have been redirected here from the Upload Your Contacts Page for Hearsay Relate, then make sure to return to that page and upload your CSV file there.

Import an existing CSV file of contacts into Hearsay Relate

  1. Log into your Hearsay account.
  2. Click on the Contacts tab.
  3. Click the Add Contacts dropdown on the upper right of the screen and select Upload your Contacts; this will take you to the Import Your Contacts page.
  4. Click the Select File button and choose to either upload your completed CSV file or drag and drop your file into the square, as indicated. Please include the columns: first name, last name, phone number, and email.
  5. The system will automatically recognize the CSV file type and import the first name, last name, phone number and email address for each contact.

Save your Excel file as a CSV file

  1. Open up your exported contacts file.
  2. Go to File > Save As.
    Screen_Shot_2019-02-14_at_11.39.23_AM.png
  1. Under File Format, choose “CSV UTF-8 (comma delimited) (.csv)”.
    Screen_Shot_2019-02-14_at_11.39.44_AM.png
  1. Click Save. Your file should now be saved as a CSV file and is ready to upload to Hearsay.

Lotus Notes

  1. Open up Lotus Notes and select Contacts.
    Screen_Shot_2019-02-14_at_11.50.03_AM.png
  1. From there, select All.
  2. Click File > Export Contacts.
  3. Select how much information to export. We recommend All fields.
  4. Specify where you want to save the file and provide a file name.
  5. For Save as type, specify CSV. For additional help, hover over the question mark icon.
    Screen_Shot_2019-02-14_at_11.47.28_AM.png
  1. Click Export. Your file is now ready to be uploaded to Hearsay.

If you have been redirected here from the Upload Your Contacts Page for Hearsay Relate, then make sure to return to that page and upload your CSV file there.

Salesforce

  1. From the Reports tab, click New Report.
    New_Report.png
  2. Select the ‘Leads’ Report Type, select your desired Lead contact information fields. We recommend the following fields:
    First Name
    Last Name
    Phone Number
    Email Address
  3. Change the filter criteria from My Leads to All Leads and change Create Date to All Time
  4. Click Run Report.
  5. Click Edit and then Export.
    Export_Leads.png

  6. Export the Report, making sure to export it as a CSV file.
    Export_View_.png

If you have been redirected here from the Upload Your Contacts Page for Hearsay Relate, then make sure to return to that page and upload your CSV file there.

Microsoft Dynamics

  1. Go to the Contacts section of your Dynamics dashboard.
    Screen_Shot_2019-02-14_at_11.09.53_AM.png
  1. Click the dropdown next to Active Contacts and select All Contacts.
    Screen_Shot_2019-02-14_at_11.10.30_AM.png
  1. In the toolbar at the top, click on Export to Excel.
    Screen_Shot_2019-02-14_at_11.11.08_AM.png
  1. Open up the downloaded file. Click on Save As and save it as a CSV file. A warning message that says “This workbook cannot be saved in the selected format because it contacts multiple sheets” might pop up. Click OK. This will continue to save the file in a CSV format with no lost data.
    Screen_Shot_2019-02-14_at_11.12.29_AM.png
  1. Follow instructions provided above to Import an existing CSV file into Hearsay.

 

If you have been redirected here from the Upload Your Contacts Page for Hearsay Relate, then make sure to return to that page and upload your CSV file there.

Redtail

  1. Head to the Contacts A-Z section of Redtail.
  2. Select all of your contacts by clicking this box.
    get_all.png
  3. Doing this will only select the contacts on that page. To select all of your contacts, click the link in the display box that reads “Select all # contacts.” with the # switched out with however many number of contacts you have.
  4. You should receive a different message now that says you’ve successfully selected all contacts.
    363.png
  5. Click on the Contacts Options button in the top right, next to New Contact, and select Exports.
    cont1.png
  6. Then, after selecting your contact option, you'll be presented with a popup alert notifying you that you'll receive an email notification once the action is complete. This email notification will be sent to the email address associated with the username with which you are currently logged in. Once you have been notified, the file will be available to admin users of the database only in the Dropbox Files area of your database.
  7. Follow instructions provided above to Import an existing CSV file into Hearsay.

If you have been redirected here from the Upload Your Contacts Page for Hearsay Relate, then make sure to return to that page and upload your CSV file there.

LinkedIn

  1. Click the Me icon at the top of your LinkedIn homepage.

  2. Select Settings & Privacy from the dropdown menu.

  3. Click the Data privacy tab from the left menu and then click Get a copy of your data.


  4. You’ll be redirected to the Export your data page. Select Connections.

  5. An email will be sent to the email address tied to your LinkedIn login. It will include the link you will use to download your list of connections.
  6. Follow instructions provided above to Import an existing CSV file into Hearsay.

If you have been redirected here from the Upload Your Contacts Page for Hearsay Relate, then make sure to return to that page and upload your CSV file there.

Outlook (Newer Versions)

NOTE: If you do not know which version of Microsoft Outlook you are using, consulting the official Microsoft support website is the best way to identify it, and ensure you have the most current instructions to guide you through exporting your contacts.

  1. In Outlook on a PC, choose File. If your ribbon doesn't have a File option in the top left corner, you're not using Outlook on a PC.
  2. Choose Open & Export > Import/Export.
  3. Choose Export to a file.
  4. Choose Comma Separated Values.
  5. In the Select folder to export from box, scroll to the top if needed and select the Contacts folder that's under your account. Choose Next.
    dece2b41-08cb-4edc-a140-a8abca01d274.png
  6. Choose Browse, name your file, and choose OK.
  7. Confirm where your new contacts file will be saved on your computer, and choose Next.
  8. Choose Finish to start exporting your contacts immediately. Outlook doesn't display any message when the export process is complete but the Import and Export Progress box goes away.
    8db72d70-125a-488e-984c-1408227b43fa.png
  9. Locate the new .csv file on your computer and open it with Excel to verify your contacts are there. You'll likely have a lot of empty cells. That's normal.
    08209a81-69cb-4052-a90d-457b837a7a42.png
  10. Generally we recommend closing the file without saving any changes; otherwise the file might get messed up and you won't be able to use it for importing. If that happens you can always run the export process again and create a new file.

If you have been redirected here from the Upload Your Contacts Page for Hearsay Relate, then make sure to return to that page and upload your CSV file there.

New Outlook for the Web

Use these instructions if your mailbox looks like this.

0eb9ec4b-53d8-419e-93da-c48fd6ef45c8.png

  1. At the bottom of the page, select the People icon to go to the People page.
  2. On the toolbar, select Manage > Export contacts.
    8627394e-5278-4058-adce-19472ee5784d.png

  3. Choose to export all contacts or only contacts from a specific folder, and then select Export.
  4. At the bottom of the page, select Save to save "contacts.csv" in your default Downloads folder. Or, select the arrow next to Save and select Save as.

If you have been redirected here from the Upload Your Contacts Page for Hearsay Relate, then make sure to return to that page and upload your CSV file there.

Classic Outlook for the Web

Use these instructions if your mailbox looks like this.

90ed659b-84a9-4d61-8fbc-6657bb212ef2.png

  1. At the bottom of the page, select the People icon to go the People page.
  2. On the toolbar, select Manage > Export contacts.
    620e8b9f-ec23-4132-8e1c-32765e29b89e.png

  3. Choose to export all contacts or only contacts from a specific folder, and then select Export.
  4. At the bottom of the page, select Save to save "contacts.csv" in your default Downloads folder. Or, select the arrow next to Save and select Save as.

If you have been redirected here from the Upload Your Contacts Page for Hearsay Relate, then make sure to return to that page and upload your CSV file there.Yahoo!

Yahoo

  1. Sign in to your Yahoo! Account and head to Yahoo! Mail.
  2. Select the Contacts icon from the right hand side of the screen. It should be the second one from the top.
    Screen_Shot_2019-02-14_at_2.27.37_PM.png

  3. Click on All Contacts in the left margin.
  4. Click on the word Actions that is above and to the right of your list of contact names. Click on the 🔽 (down arrow) to open the menu.  
  5. Select Export.
    Screen_Shot_2019-02-14_at_2.25.35_PM.png

  6. When the Export contacts page opens. Select Yahoo CSV.
    Screen_Shot_2019-02-14_at_2.26.02_PM.png

  7. Click Export Now. Your have successfully exported your Yahoo! contacts in to a CSV.
  8. Follow instructions provided above to Import an existing CSV file into Hearsay.

If you have been redirected here from the Upload Your Contacts Page for Hearsay Relate, then make sure to return to that page and upload your CSV file there.

Gmail

  1. Sign in to your Gmail account.
  2. Note: If the remaining steps are different from what you see on your screen, search Gmail help for the latest address book export instructions.
  3. Click the grey “Google squares” at the top right. You will see Gmail, Drive, Calendar, etc.
  4. Click Contacts.
    Screen_Shot_2019-02-14_at_2.31.35_PM.png

  5. When the Google Contacts page opens, click More on the left side, then click Export.
    Screen_Shot_2019-02-14_at_2.30.19_PM.png

  6. Select all contacts and choose to export as a Google CSV. Your Gmail contacts have successfully being exported.
  7. Follow instructions provided above to Import an existing CSV file into Hearsay.

If you have been redirected here from the Upload Your Contacts Page for Hearsay Relate, then make sure to return to that page and upload your CSV file there.

 

Was this article helpful?
1 out of 5 found this helpful

We're sorry to hear that.

Articles in this section