No one has responded to this discussion for at least a year, so this information may be out of date. If you're looking for information about this topic, please search for a more recent discussion or post a new question.

.CSV Doesn't Import Properly

This question is answered This question is answered
I have been using a CardScan machine to create new contacts. In the past, I export the information to a .csv file and import it into Outlook just fine. However, with Microsoft Online, only the name and company import-- none of the contact's other information. How can I fix this?
Verified Answer
All Replies
  • Are you importing them directly to Outlook or into Exchange as external contacts?

  • Hi E.CFO.Systems,

    Jorge's reply can greatly help us narrow down the issue. Please answer the above question in your next reply. Moreover, I would like to confirm some thing others with you:

    1. Are you importing contacts to a common mailbox in Office 365, or a shared mailbox?

    2. Is your Office 365 mailbox using a separate Outlook profile or share profile with other mailboxes?

    If the Office 365 mailbox is not using a separate profile, I suggest you create a new profile for Office 365 mailbox, export the contact information to a new .CSV file to see if the format is different from the previous one.

    Here are some general steps about exporting and importing contacts in Outlook 2010:

    If the issue persists, please answer the above questions and I will continue to do more troubleshooting with you.

    Thanks,
    Reken Liu

  • I am importing the .CSV file to the Outlook Web App on Office 365, and it is a separate, personal mailbox. When exporting contacts from my Desktop Outlook, the file looked the same as the CardScan .CSV file.

  • I'd take a look here:

    help.outlook.com/.../ms.exch.ecp.CSVImportContactsWizardLearnMore.aspx

    It sounds like you have a field mapping issue. Do you have access to Outlook? If so I'd recommend setting up your profile in outlook and importing there, it will work much better than doing it through OWA I think.

    Thanks,

  • Hi E.CFO.Systems,

    Have you tried to import the CSV file with desktop Outlook as Jorge suggested? Please let us know if you need further help.

    Thanks,
    Reken Liu