convert excel spreadheet to Outlook Contacts (address book)

  • Thread starter Thread starter Ira D.Levy
  • Start date Start date
have excel spreadsheet in formatted cloumns I need to load into Contacts
Click to expand...

As long as you map the columns properly and choose the correct named range,
Outlook will gladly import from an Excel spreadsheet into Contacts.
 
have excel spreadsheet in formatted cloumns I need to load into Contacts
Click to expand...
One quick way to this:

1. Click File -> Import/Export to export current contacts into a
CSV.(Comma Separated Values (Windows))
2. Load the CSV into Excel
3. Delete all data from that file except for top headers. You can do
this by placing the cursor into the A2 field, and then pressing
Ctrl-shift-end to select everything to the end of file, and then just
press Delete.
4. Paste your existing data into matching columns
5. Close the CSV file (avoids file sharing conflict)
6. Use File -> Import feature of Outlook to import this data

By following these steps, you'll eliminate the need to map fields. :)

Outlook 2007 does not like to import from Excel 2007 xlsx files.
--
Leonid S. Knyshov
Crashproof Solutions
510-282-1008
Twitter: @wiseleo
http://crashproofsolutions.com
Microsoft Small Business Specialist
Please vote "helpful" if I helped you :)
 
Can I import my contact list from a Yahoo account? If so, what are the steps?

Thank you.

TRich
 
Can I import my contact list from a Yahoo account? If so, what are the steps?

Thank you.
Click to expand...
Go to your Yahoo mail account
Click on Contacts
Click on Tools and select Export
The rest is self-explanatory
--
Leonid S. Knyshov
Crashproof Solutions
510-282-1008
Twitter: @wiseleo
http://crashproofsolutions.com
Microsoft Small Business Specialist
Please vote "helpful" if I helped you :)
 
Back
Top