Skip to main content

How to export contacts from Outlook to Excel spreadsheet?

Exporting Outlook contacts to a file is an easy way for you to import the contact file into other applications. You can get rid of typing the same contact information over and over again by using the following method.

Export contacts from outlook to excel spreasheet in Outlook 2010

Export contacts from outlook to excel spreasheet in Outlook 2013/2016


arrow blue right bubble Export contacts from outlook to excel spreasheet

1. After launch your outlook, click File > Options. See screenshot:

2. When the Outlook Options window popup, click Advanced. In the right pane, click Export button.

3. In the Import and Export Wizard dialog, select Export to a file option, and then click Next button.

4. Select Microsoft Excel 97-2003, then click Next button. See screenshot:

5. Under the Select folder to export from, select Contacts option, then click Next to continue.

6. Under Save exported file as, click Browse button to select a destination folder.

7. In the File name column, type a name for the file. And then click OK button. After clicking OK button, it returns to the previous window, click Next, See screenshot:

doc-export-contact

8. If you want to manually customize the map by yourself, click Map Custom Fileds button. See screenshot:

9. If you don’t like the default setting, click on the Clear Map button to remove all the values on the right pane. And then you should choose your own value from the left pane. Just like the instructions giving in the dialog box: you need to drag the values from the source file on the left, and drop them on the appropriate destination field on the right. When finish setting, click on OK button.

10. Then it turns to the previous window, click on Finish button. Now, an Excel file with outlook contacts information is created.


Export contacts from outlook to excel spreadsheet in Outlook 2013/2016

If you are working in Outlook 2013/2016, the steps will be much easier.

1. Click File > Open&Export > Import/Export.
doc export contact 12

2. In the Import and Export Wizard, select Export to a file, click Next.
doc export contact 13

3. Select Comma Separated Values from the list box, click Next.
doc export contact 14

4. Select the contacts folder you want to export to a sheet in the Export to a file dialog. Click Next.
doc export contact 15

5. Click Browse to select a folder to place the new sheet which will contains contacts, and give it a name. Click OK > Next > Finish.
doc export contact 16

Then the contacts have been exported as csv file.

6. Open the csv file which you have create just now, click File > Save As and select Excel Workbook from Save as type drop down list in the Save As dialog. Click Save.
doc export contact 17

Now the contacts have been exported to a sheet.
doc export contact 18


Save or Export Multiple emails to other fomat files(PDF/HTML/WORD/EXCEL) in Outlook

Sometimes, you may want to save or export the emails to a folder as other format files, such as PDF, Word or Excel files in Outlook. In Outlook, neither of the Save as and Export function can handle this job. However, Kutools for Outlook's Save as file utility can export multiple emails to a folder as files with multiple formats at once time .    Click for 60 days free trial!
doc export email to msg 8
 
Kutools for Outlook: with dozens of handy Outlook add-ins, free to try with no limitation in 60 days.

Best Office Productivity Tools

Kutools for Outlook - Over 100 Powerful Features to Supercharge Your Outlook

🤖 AI Mail Assistant: Instant pro emails with AI magic--one-click to genius replies, perfect tone, multilingual mastery. Transform emailing effortlessly! ...

📧 Email Automation: Out of Office (Available for POP and IMAP)  /  Schedule Send Emails  /  Auto CC/BCC by Rules When Sending Email  /  Auto Forward (Advanced Rules)   /  Auto Add Greeting   /  Automatically Split Multi-Recipient Emails into Individual Messages ...

📨 Email Management: Easily Recall Emails  /  Block Scam Emails by Subjects and Others  /  Delete Duplicate Emails  /  Advanced Search  /  Consolidate Folders ...

📁 Attachments ProBatch Save  /  Batch Detach  /  Batch Compress  /  Auto Save   /  Auto Detach  /  Auto Compress ...

🌟 Interface Magic: 😊More Pretty and Cool Emojis   /  Boost Your Outlook Productivity with Tabbed Views  /  Minimize Outlook Instead of Closing ...

👍 One-click Wonders: Reply All with Incoming Attachments  /   Anti-Phishing Emails  /  🕘Show Sender's Time Zone ...

👩🏼‍🤝‍👩🏻 Contacts & Calendar: Batch Add Contacts From Selected Emails  /  Split a Contact Group to Individual Groups  /  Remove Birthday Reminders ...

Over 100 Features Await Your Exploration! Click Here to Discover More.

Read More       Free Download      Purchase
 

 

Comments (12)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
i DON'T SEE ANSWERS TO ANY OF THE QUESTIONS ABOVE...
This comment was minimized by the moderator on the site
All I am getting when I export, is just names. Help, What am I going wrong.
This comment was minimized by the moderator on the site
i did not find any e-mail address at excell sheet through above method ...
This comment was minimized by the moderator on the site
I was able to export the file to an Excel spreadsheet, except that it didn't export my user-defined columns, which made the spreadsheet useless! I could not see any way to do that. Do you?
This comment was minimized by the moderator on the site
I also could export but all went into one coloumn and I couldn't separate name from email so is useless. who has figured it out?
This comment was minimized by the moderator on the site
I had created an distribution list that I now want to export to excel. I need to be able to see each of the names in the list but using this export function does not allow me to do that. Please help :) Thanks
This comment was minimized by the moderator on the site
I managed to export the 'contacts' folder to Excel file, but No data! What am I doing wrong?
This comment was minimized by the moderator on the site
very helpful, i love it
This comment was minimized by the moderator on the site
Here is the instructions on how to export contacts into excel. If you have any questions please let me know. Thank you, Maria
This comment was minimized by the moderator on the site
If I export contacts into excel will I loose them in Outlook? I want to copy contacts to excel, not permanently move them to excel.
This comment was minimized by the moderator on the site
Instructions on how to export contacts into excel
This comment was minimized by the moderator on the site
Here's the instructions on how to export contacts
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations