Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

A colleague sent me an Outlook .pst file. There is only one Contacts entry, which is a Contact Group containing multiple contacts.

I need to extract the contacts from inside the contact group, for transfer to my gmail account.

The File Import/Export wizard only exports a single line representing the Contact Group, not the individual contacts in the group.

share|improve this question
add comment

3 Answers

Took me a while to figure this out myself. You can only export files that are "address books" not contacts or contact groups.

So this is what you have to do:

  1. You open the contact group.
  2. You save as .txt (text only file).
  3. Close that file. Open Excel.
  4. Go to File - Open - go to the file folder where your .txt file is.
  5. Make sure you have chosen to show all files and choose your .txt file.
  6. Hit Open.
  7. Choose "Delimited" at the top then Next.
  8. Choose Tab at the top then Next.
  9. Choose General at the top then Finish.
  10. Open your columns to display your information.
share|improve this answer
add comment

Open the Contact Group, File -> Save As -> Text Only.

share|improve this answer
add comment

For Outlook 2013 there is no longer a "Save-As" option. Now in the contact list, right click on the group you want, choose the option "Copy Contact Details" and paste it in a blank excel spreadsheet. It will only have the name and the email address and perhaps notes (I didn't have any in the group I exported and don't have time to experiment with it right now). ~~Good Luck!

share|improve this answer
    
The question pertains to Outlook 2010, not 2013. How does your post answer the question posed by OP? –  DanteTheEgregore Nov 25 '13 at 18:39
add comment

protected by Community Dec 15 '13 at 18:18

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.