Contacts

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. Outlook 2010
  12. Yahoo!
  13. 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.

image2019-2-11_13-23-35.png

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 Contact  button on the upper right of the screen; this will take you to the Upload 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.
  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

    Choose_Leads.png

  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.
    Screen_Shot_2019-02-14_at_11.15.44_AM.png

  2. Select Settings & Privacy from the dropdown menu.
    Screen_Shot_2019-02-14_at_11.16.17_AM.png

  3. Click the Privacy tab at the top of the page.
    Screen_Shot_2019-02-14_at_11.17.18_AM.png

  4. Under the How LinkedIn uses your data section, click Change next to Download your data. Note: You may be prompted to sign in.
    Screen_Shot_2019-02-14_at_11.17.56_AM.png

  5. You’ll be redirected to the Download your data page. Select Connections.
    Screen_Shot_2019-02-14_at_11.18.59_AM.png

  6. 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.
  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.

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.

Outlook 2010

  1. At the top of your Outlook 2010 ribbon, choose the File tab.
  2. Choose Options.
    d3935524-0652-4d40-ac96-1493e1f67c6c.png

  3. In the Outlook Options box, choose Advanced.
    f2ed5d6c-f6a2-4eea-9800-09d090cc21af.png

  4. Under the Export section, choose Export.
  5. In the Import and Export Wizard, select Export to a file, and then choose Next.
  6. Under Create a file of type, select Comma Separated Values, otherwise known as CSV. Then click Next.
    31c17a99-2cd4-4feb-b249-863f9d889823.png

  7. Under Select folder to export from, you may need to scroll up, and then select the contact folder that you want to export. Choose Next when you're done.
    580c9efc-0817-4bc8-b873-b053c9f36905.png

  8. Under Save exported file as, click Browse, select a destination folder, and in the File name box, type a name for the file.
  9. Click OK.
  10. In the Export to a File dialog box, click Next.
  11. 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.
  12. When the export is finished, choose OK to exit the Outlook Options box.
  13. Go to the location on your computer where you saved your contacts, for example, in the Documents folder.
  14. If you exported your contacts as a .csv file, you can use Excel to see what was exported from Outlook. You'll likely have a lot of empty cells. That's normal.
    08209a81-69cb-4052-a90d-457b837a7a42.png

  15. 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.

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.