How to Transfer an Excel Email Address to Lotus Notes

Written by ken burnside Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Transfer an Excel Email Address to Lotus Notes
Moving a list of e-mail addresses from Excel to Lotus Notes is easy. (e-mail image by Soja Andrzej from

Excel will convert an e-mail address into a click-able link. Sometimes, it's necessary to copy that e-mail address into Lotus Notes (or another e-mail program) to add it to your contacts.

Skill level:

Things you need

  • Excel 1995 or later
  • Lotus Notes 8.0 or later

Show MoreHide


  1. 1

    Open Excel. Select the email address you want to transfer.

  2. 2

    Press "Ctrl-C" to copy the email address.

  3. 3

    Open Lotus Notes. Click on the menu item for "File" and select "New Contact." In the dialogue window that opens up, select the field labelled "email address" and press "Ctrl-V" to paste the email address in.

  1. 1

    Open the Excel workbook with the list of e-mail addresses you want to import.

  2. 2

    Click on the "Office" button in Excel, and select "Save As" from the menu item.

  3. 3

    Choose Comma Separated Values (*.csv) from the file format drop down on the menu that appears. Click the button that says "Save."

  4. 4

    Open Lotus Notes. Click on the "File" menu item, and select "Import."

  5. 5

    Select "Browse" from the menu. In the dialogue box that appears, select the CSV file you created earlier. Select "Open" from the dialogue box.

Tips and warnings

  • Lotus Notes will merge imported contacts with your existing contacts, rather than overwrite them.
  • In earlier versions of Lotus Notes, you may need to save the Excel data as a WKS (Lotus 1-2-3 Worksheet) file.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.