Outlook - Export contacts from Outlook Tutorial

In this video, you will learn how to export contacts from Outlook.
The video covers the process of saving your contacts in a CSV file, which can then be imported into a different email account.
To export your contacts, go to the File tab, select Open and Export, and click on Import/Export.
Choose the option to export to a file in comma-separated values format.
Select the contacts folder under your account and choose the location to save the file.
Once the export is complete, open the file in Excel to verify that your contacts are present.
This tutorial will help you efficiently export your Outlook contacts and update their information using Excel.

1:09
3664 views

Available in Microsoft365

Objectifs :

This guide aims to provide a step-by-step process for exporting contacts from Outlook to a CSV file, which can then be used to import contacts into a different email account. It will also cover how to verify and update the exported contacts using Excel.

Chapitres :

Introduction to Exporting Contacts from Outlook
Exporting contacts from Outlook is a straightforward process that allows users to save their contact information in a CSV file format. This file can be utilized to import contacts into other email accounts, ensuring that important contact information is not lost during transitions between platforms.
Step-by-Step Process to Export Contacts
Follow these steps to export your contacts from Outlook: 1. **Open Outlook**: Launch the Outlook application on your computer. 2. **File Tab**: Click on the 'File' tab located in the upper left corner of the window. 3. **Open and Export**: Select 'Open & Export' from the menu options. 4. **Import/Export Wizard**: Click on 'Import/Export' to open the wizard. 5. **Export to a File**: In the wizard, choose 'Export to a file' and select 'Comma Separated Values (CSV)'. 6. **Select Folder**: Choose the folder you want to export from, typically the 'Contacts' folder under your account. 7. **Save Location**: Specify the location where you want to save the CSV file and give it a name. 8. **Finish Exporting**: Click 'Next' and then 'Finish' to start the export process.
Completing the Export Process
Once you have completed the export process, a progress dialog box will appear, indicating that your contacts are being exported. After the process is finished, this dialog box will disappear, confirming that your contacts have been successfully saved in the specified location.
Verifying and Updating Contacts in Excel
To ensure that your contacts have been exported correctly, follow these steps: 1. **Open the CSV File**: Navigate to the location where you saved the CSV file and open it using Microsoft Excel. 2. **Check Contacts**: Review the contents of the file to confirm that all your contacts are present. 3. **Update Information**: You can use Excel to update any information in your CSV file as needed before importing it into another email account.
Conclusion
Exporting contacts from Outlook to a CSV file is a valuable skill that facilitates the transfer of important contact information between different email accounts. By following the outlined steps, users can ensure a smooth transition and maintain their contact lists effectively.

FAQ :

How do I export my contacts from Outlook?

To export your contacts from Outlook, go to the File tab, select 'Open and Export', then click on 'Import/Export'. Choose 'Export to a file', select 'Comma Separated Values', and follow the prompts to select the contacts folder and save the file.

What is a CSV file and why is it used for contacts?

A CSV file is a simple text file that uses commas to separate values. It is commonly used for exporting and importing data because it is compatible with many applications, making it easy to transfer contact information between different email accounts.

Can I edit my contacts in Excel after exporting them?

Yes, after exporting your contacts to a CSV file, you can open the file in Excel to update or modify the information as needed.

What should I do if my contacts do not appear in the exported CSV file?

If your contacts do not appear in the exported CSV file, ensure that you selected the correct contacts folder during the export process. You may also want to check if there are any filters applied that could be hiding your contacts.

Is it possible to import contacts from a CSV file back into Outlook?

Yes, you can import contacts from a CSV file back into Outlook by using the Import/Export Wizard. Select 'Import from another program or file', choose 'Comma Separated Values', and follow the prompts to import your contacts.

Quelques cas d'usages :

Migrating Contacts to a New Email Account

When switching to a new email provider, users can export their contacts from Outlook as a CSV file and then import them into the new email account. This process ensures that all important contact information is retained and easily accessible in the new account.

Updating Contact Information in Bulk

Users can export their contacts to a CSV file, make bulk updates in Excel (such as correcting phone numbers or adding new email addresses), and then re-import the updated CSV file back into Outlook. This method saves time compared to updating each contact individually.

Creating a Backup of Contacts

Exporting contacts from Outlook to a CSV file serves as a backup. Users can store this file securely and restore their contacts if needed, ensuring that important information is not lost.

Sharing Contacts with Team Members

A CSV file containing exported contacts can be shared with team members or colleagues, allowing them to import the same contacts into their email accounts. This is useful for maintaining consistent contact information across a team.

Integrating Contacts with Other Applications

Exporting contacts to a CSV file allows users to integrate their contact information with other applications, such as CRM systems or marketing tools, enhancing their ability to manage and utilize contact data effectively.

Glossaire :

CSV

CSV stands for Comma-Separated Values. It is a file format used to store tabular data, such as a spreadsheet or database, in plain text. Each line in a CSV file corresponds to a row in the table, and each value in that row is separated by a comma.

Outlook

Outlook is a personal information manager developed by Microsoft, primarily used as an email application. It also includes calendar, task manager, contact manager, note-taking, journal, and web browsing features.

Import/Export Wizard

The Import/Export Wizard in Outlook is a tool that helps users transfer data between different file formats and applications. It guides users through the process of importing or exporting data, such as contacts or emails.

Excel

Excel is a spreadsheet program developed by Microsoft that allows users to organize, format, and calculate data with formulas using a system of rows and columns.

Contacts Folder

The Contacts Folder in Outlook is a designated area where all contact information is stored. Users can create, edit, and manage their contacts within this folder.

00:00:05

a copy of your contacts is saved in a CSV file,

00:00:09

or another type.

00:00:11

You can then use this file to import your contacts

00:00:13

in a different email account.

00:00:16

To do this, in the file tab, select open and export.

00:00:21

Then click on import export.

00:00:24

The wizard opens, select export to a file,

00:00:30

comma separated values.

00:00:33

Then select the folder to export.

00:00:36

Navigate to the contacts folder under your account.

00:00:40

Choose the location where you want to save the file

00:00:43

and name it.

00:00:46

Click next and finally finish to start to export

00:00:49

your contacts immediately.

00:00:51

Once the process is complete,

00:00:53

the progress dialog box disappears.

00:00:57

Then open your new file in your computer with Excel

00:01:00

to check that your contacts are present.

00:01:03

You can now use Excel to update the information

00:01:06

in your CSV file.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

3348 Views

Microsoft Outlook Video Training – Intermediate

Through a logical progression of video tutorials, discover the intermediate features of Microsoft Outlook: Sorting & searching your mails, O...

2480 Views

Training Video Business Uses – Assistants

To write a last-minute document, optimize communication or quickly format documents, Office 365 provides a range of features that will meet ...

ALL COURSES