Results 1 to 8 of 8
  1. #1
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    96
    Thanked 14 Times in 13 Posts
    I've got a spreadsheet with names and email addresses that I want to import into Outlook contacts. I assume I need to save it as a .csv then import into Outlook.

    How do I format the Excel spreadsheet so that the columns will be recognized as fields that I can map when I do the import? I'm assuming it needs to be headings of some type at the top of the columns, if so, how do I create the headings?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Outlook can import .xls files directly, there's no need to use .csv as intermediate format.

    You'll get the opportunity to map columns from the Excel worksheet to Outlook fields just before finishing the import; Excel will try to guess as many as possible. If you want to know the field names used by Outlook, you can export existing contacts to Excel first.

  3. #3
    Lounger
    Join Date
    Jun 2009
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have been having a heck of a time trying to import MS Office 2003 Excel files to MS Office 2003 Outlook. The original files are being compiled on an XP laptop. The destination is MS Office Outlook on a Vista 64 bit laptop. There are only about fifty names and addresses. But when I do the import it adds the data and continues to import blanks forever. I have to go to task manager to halt MS Office Outlook. As a result, nothing is imported.

    Is there some incompatibility issue here? If so, is there a program that will resolve the issue?

    Many thanks in advance for any help.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Welcome to the Lounge!

    Make sure that Excel doesn't think your worksheet extends further than the last filled row. You can check this by pressing Ctrl+End; this will take you to the last cell of the used range on the sheet.

    If you still have problems, you can export the worksheet to a comma-separated values file (.csv) or to a tab-delimited text file (.txt), and import that into Outlook.

  5. #5
    Lounger
    Join Date
    Jun 2009
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the quick response and suggestions.

    When I do a CTRL-END in Excel, it properly takes me to the last entry. Still have the import problem.

    I have tried using CSV with no success. But I just discovered I should have used the Windows version instead of the DOS version. At least it works with CSV now.

  6. #6
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    96
    Thanked 14 Times in 13 Posts
    [quote name='HansV' post='778825' date='08-Jun-2009 18:54']Outlook can import .xls files directly, there's no need to use .csv as intermediate format.

    You'll get the opportunity to map columns from the Excel worksheet to Outlook fields just before finishing the import; Excel will try to guess as many as possible. If you want to know the field names used by Outlook, you can export existing contacts to Excel first.[/quote]

    Thanks, Hans.

    I've not gotten back to this task to try it, but is there a way in Excel to create a heading (or header, not sure of the right terminology) that will be recognized as a field during the import process?

    Thanks

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The import process will look at the first row of the Excel sheet (or the first line in the .csv file) for the field names. It will try to match these to the field names used in Outlook. If you want to know which field names Outlook uses, to maximize the number of successful automatic matches, export a few contacts to Excel or to a .CSV file, and look at the result. You can use this as the starting point for the file to be imported.

    Note: it is not necessary to include ALL fields used by Outlook in your Excel / .csv file. And it's not necessary to have them in the same order either.

  8. #8
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    96
    Thanked 14 Times in 13 Posts
    OK. I was assuming the heading row needed to be formatted in some special way. Thanks for clearing that up.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •