Share via

Cannot Export Contacts as .CSV in Outlook 2016 for Mac (.olm) only

Anonymous
2016-02-27T20:53:27+00:00

Hi,

So I'm a little bewildered here that I've been an Outlook user (both on Mac and PC) for over 10 years and have never seen something like this.  

When I go to File - Export - Contacts -> i get the option to export ONLY as an .olm file.  I cannot for the life of me export them as a .txt or .csv file to actually use them in another program.  

Anyone have some insight on this or is this another one to chalk up for the Microsoft/Apple battle?

Matt

Version 15.18

El Capitain

Outlook | MacOS | Legacy Outlook for Mac | For business

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
  1. Anonymous
    2016-04-16T18:33:46+00:00

    Since this is probably because you want to move contacts to another app like Mac Contacts, 

    It'e really easy to do this.  Select them all, then drag and drop to a folder.  Sort by kind because in addition to .vcf files, you will have .txt files for your groups.  At that point, select all the .vcf files, drag and drop them onto the left side of the Mac Contacts page, and let it rip.

    I copied over 2600 contacts this way.  It is correct you can't export to .csv, but that is because Microsoft has actually made it easier.

    100+ people found this answer helpful.
    0 comments No comments
Answer accepted by question author
  1. Anonymous
    2016-09-27T19:56:37+00:00
    1. Select the contacts in Outlook and drag them all to a folder in the Finder.
    2. Select the corresponding ,vcf you just created in the Finder and drag them to the Contacts app to import them.

    For Contact, you have multiple options. Some of them are listed here:

    https://discussions.apple.com/thread/6007355?tstart=0

    There are also a number of third party apps that will use the Contacts entries to generate a csv file (like AB2CSV).

    You have no native solution straight from Contacts, but at least it's far more flexible than Outlook.

    Corentin

    50+ people found this answer helpful.
    0 comments No comments
Answer accepted by question author
  1. Anonymous
    2018-08-30T17:47:10+00:00

    That's precisely what was discussed in the thread…

    In summary, Contacts can import as .csv, but natively it doesn't offer .csv export. You'll need a third party tool to do that from Contacts.

    (and there are many out there).

    As I mentioned in another post though, it might be easier to import the contacts into Gmail and export from the the Google Contacts page directly as .csv though.

    Corentin

    0 comments No comments
Answer accepted by question author
  1. Anonymous
    2018-08-29T13:59:59+00:00

    Dragging .vcf files to contacts or to Outlook should not delete (or wipe our) anything at all. It simply adds the new contacts to the old ones.

    If anything, the only risk is to end up with duplicates if you drag more than once.

    If contacts disappeared, I would suspect that it's an issue with what address book is selected in the present view.

    In the Contacts app in addition, you have built-in support for Time Machine. If Time Machine is enabled, you can trigger it, and go back in time to view the state of the app from before you performed any "operation" on them (and you can obviously restore that state if need be).

    Corentin

    0 comments No comments
Answer accepted by question author
  1. Anonymous
    2018-01-22T16:01:51+00:00

    Outlook is extremely limited as to what formats it can export too.

    I was mentioning the possibility of syncing to Outlook.com since it sounded like that's where you wanted to have all the contacts.

    Once you have the contacts in the Contacts app on your Mac though, you can re-select them all and drag them together to the Desktop to export them as one large .vcf. Can't you import that directly in the account of whoever you are trying to send it to? Does it have to be .csv and .csv only?

    Corentin

    0 comments No comments
Answer accepted by question author
  1. Anonymous
    2017-03-15T17:23:53+00:00

    There is no option whatsoever to do that in Outlook itself, but as part of the migration process, can't you do that straight off the server itself? I'd ask that in an Exchange forum.

    Corentin

    0 comments No comments

100 additional answers

Sort by: Most helpful
  1. Anonymous
    2016-12-09T17:38:02+00:00

    Try Exporting from Outlook web access! For me, I logged in on a PC and went to a browser, logged in on office 365 and was able to export to excel by clicking people>contacts>manage>export.

    Hope that helps, I haven't tried it on a Mac yet, but since the web access is the same it should work.

    7 people found this answer helpful.
    0 comments No comments