import excel data into contacts

Posted on 2004-11-09
Last Modified: 2013-12-18
I am using Windos XP PRO and I have MS Office XP 2003. I also have Lotus Notes 6.0.  

My Question is:

I have an Excel sheet with contact info such as, Name, Address, Phone, City,State, email, etc.

I want to create a file format that I can import into Lotus Notes.  Lotus notes will only take .VCF format. Is there another way?  Is there a way to save to outlook from excel and then export as vcf from excel to Lotus Notes?

Question by:erodcpu
    LVL 14

    Accepted Solution

    LVL 24

    Expert Comment

    here is a script which can do export.. reverse it and you have import feature,

    LVL 46

    Expert Comment

    by:Sjef Bosman
    Best approach (ahem):
    - inspect a contact document, figure out what fieldnames are used
    - add a column Form with content "Person" on every row
    - the first row should contain the names of the fields where the contact information should be stored
    - most important part: save the Excel-file as a .wk4 file
    - open your address book
    - File/Import, select Lotus 1-2-3, select the file and click Import

    No tools or programming required...
    LVL 14

    Expert Comment

    thanks for the points

    LVL 46

    Expert Comment

    by:Sjef Bosman
    Hey bro, your's seems to be better still... ;)

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
    This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now