Outlook - Export contacts from Outlook Video
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
- 3385 views
-
Excel - Create a PivotTable and analyze your data
- 1:35
- Viewed 3940 times
-
Power BI - Recovering your Data from different sources
- 3:26
- Viewed 4218 times
-
Power BI - Creating your Datasets
- 2:26
- Viewed 3655 times
-
Power BI - Introduction to Power BI Building Blocks
- 3:07
- Viewed 4129 times
-
Power BI - Introduction to Power BI Desktop
- 2:52
- Viewed 4106 times
-
Power BI - General Introduction
- 2:54
- Viewed 4969 times
-
Outlook - Manage attachments
- 1:51
- Viewed 2906 times
-
Excel - Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2687 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 9668 times
-
Change the default font for your emails
- 1:09
- Viewed 7510 times
-
Answering a scheduling poll
- 1:14
- Viewed 7133 times
-
Create a scheduling poll
- 4:12
- Viewed 5388 times
-
Saving a message
- 1:43
- Viewed 5274 times
-
Create and modify a group
- 2:19
- Viewed 5122 times
-
Use the scheduling poll dashboard
- 2:42
- Viewed 4327 times
-
How do I block a sender?
- 1:01
- Viewed 4110 times
-
Tell me what you want to do
- 0:57
- Viewed 4094 times
-
Delay or schedule e-mail sending
- 2:14
- Viewed 3969 times
-
Join a group
- 1:34
- Viewed 3913 times
-
Discovering the Outlook 2016 interface
- 2:54
- Viewed 3894 times
-
Accessing applications from a group
- 1:59
- Viewed 3839 times
-
Organizing your messages using rules
- 2:54
- Viewed 3801 times
-
How do I share a document securely with Outlook?
- 1:49
- Viewed 3793 times
-
Attach a message, a contact, a file, or a task
- 2:22
- Viewed 3778 times
-
Presentation of the task module
- 3:31
- Viewed 3759 times
-
Creating a group
- 2:38
- Viewed 3749 times
-
Recall or replace an e-mail you sent
- 1:25
- Viewed 3746 times
-
Automatically mark deleted emails as read
- 0:46
- Viewed 3744 times
-
Sending automatic replies
- 2:03
- Viewed 3711 times
-
Create a task and create a recurring task
- 2:30
- Viewed 3693 times
-
Request a read receipt or confirmation of delivery
- 2:18
- Viewed 3690 times
-
Recover deleted items
- 1:43
- Viewed 3674 times
-
Introducing Outlook
- 0:50
- Viewed 3651 times
-
Process a received message
- 2:02
- Viewed 3644 times
-
Create a task from a message
- 2:14
- Viewed 3624 times
-
Translate your emails into Outlook
- 2:40
- Viewed 3603 times
-
Insert elements into the mails (table, graphic, images)
- 2:56
- Viewed 3592 times
-
Let Outlook read your emails out loud
- 0:32
- Viewed 3578 times
-
How to launch a New Teams Meeting in Outlook
- 3:49
- Viewed 3553 times
-
Presentation and discovery of contacts
- 1:09
- Viewed 3547 times
-
Create an e-mail message
- 2:46
- Viewed 3546 times
-
Respond to a meeting
- 0:48
- Viewed 3540 times
-
Manage Your Working Time in MyAnalytics
- 0:34
- Viewed 3511 times
-
Creating a draft
- 1:24
- Viewed 3483 times
-
Schedule sending emails in Outlook
- 0:54
- Viewed 3447 times
-
Calendar delegation
- 1:28
- Viewed 3432 times
-
Organizing in folders
- 2:36
- Viewed 3423 times
-
Schedule a meeting
- 1:50
- Viewed 3410 times
-
Using conversation mode
- 1:25
- Viewed 3402 times
-
Discover the new simplified ribbon
- 0:29
- Viewed 3382 times
-
Import contacts into Outlook
- 1:52
- Viewed 3374 times
-
Create a contact & add and use contacts
- 2:36
- Viewed 3365 times
-
Temporarily turn off notifications
- 0:23
- Viewed 3341 times
-
Getting Started with Outlook Mobile App
- 1:53
- Viewed 3326 times
-
Dictate email messages in Outlook
- 0:34
- Viewed 3325 times
-
Manage recurring appointments
- 2:12
- Viewed 3322 times
-
The Bcc field in detail
- 1:54
- Viewed 3295 times
-
Sharing the calendar
- 2:11
- Viewed 3294 times
-
Publish the calendar
- 1:20
- Viewed 3274 times
-
Manage displays
- 2:26
- Viewed 3265 times
-
Fill in your work schedules in Outlook
- 1:29
- Viewed 3263 times
-
Quickly sort emails
- 0:27
- Viewed 3259 times
-
Creating an e-mail template
- 1:16
- Viewed 3253 times
-
Display 3 time zones
- 0:37
- Viewed 3252 times
-
Create a contact group & Communicate through contact groups (distribution list)
- 3:22
- Viewed 3244 times
-
Using categories
- 2:15
- Viewed 3234 times
-
Ribbon preview
- 2:55
- Viewed 3224 times
-
Sorting & searching your mails
- 2:50
- Viewed 3223 times
-
Junk email
- 2:16
- Viewed 3213 times
-
Set or remove reminders
- 0:59
- Viewed 3210 times
-
Introducing Office 365 Groups
- 1:29
- Viewed 3210 times
-
Cleaning your inbox
- 2:39
- Viewed 3204 times
-
Prevent recipients from forwarding emails
- 0:34
- Viewed 3197 times
-
Clutter
- 1:31
- Viewed 3196 times
-
Assigning a task
- 1:13
- Viewed 3190 times
-
Prevent forwarding of a meeting
- 0:29
- Viewed 3176 times
-
Identify meeting members
- 0:26
- Viewed 3173 times
-
Printing messages
- 1:10
- Viewed 3170 times
-
Conduct surveys
- 1:38
- Viewed 3165 times
-
Using the Scheduling Assistant
- 1:07
- Viewed 3152 times
-
How do I recognize a fraudulent email?
- 2:01
- Viewed 3120 times
-
Custom your personal reminders and notifications
- 0:44
- Viewed 3077 times
-
Open a shared calendar
- 1:30
- Viewed 3073 times
-
Show other people's calendar
- 0:52
- Viewed 3063 times
-
Make your Outlook signature accessible
- 0:44
- Viewed 3048 times
-
Edit and customize views
- 1:24
- Viewed 3022 times
-
Having a conversation within a group
- 3:21
- Viewed 3011 times
-
Create and add a signature to messages
- 1:21
- Viewed 2980 times
-
Remove a member from a group
- 0:29
- Viewed 2979 times
-
Create an appointment
- 1:56
- Viewed 2952 times
-
Manage attachments
- 1:51
- Viewed 2906 times
-
How to protect an email by encryption?
- 2:41
- Viewed 2896 times
-
Create a meeting in the group calendar
- 1:12
- Viewed 2857 times
-
Manage new message notifications
- 1:42
- Viewed 2828 times
-
Go further with Outlook Mobile
- 2:24
- Viewed 2810 times
-
Presentation and discovery of the calendar
- 1:26
- Viewed 2773 times
-
Expand your LinkedIn network via Outlook
- 0:39
- Viewed 2763 times
-
Outlook Mobile for Daily Use
- 4:46
- Viewed 2751 times
-
General security practices in Outlook
- 1:03
- Viewed 2741 times
-
Improving email accessibility
- 1:33
- Viewed 2692 times
-
Improve the accessibility of your images in emails
- 0:46
- Viewed 2625 times
-
Add accessible tables and lists
- 0:49
- Viewed 2594 times
-
Edit or delete an appointment, meeting or event
- 1:11
- Viewed 2428 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 1705 times
-
Task Module Overview
- 01:56
- Viewed 597 times
-
Organize Your Messages with Rules
- 02:01
- Viewed 596 times
-
Recover deleted items
- 01:09
- Viewed 573 times
-
The Bcc Field in Detail
- 01:53
- Viewed 504 times
-
Create a reminder for yourself
- 01:59
- Viewed 462 times
-
Grant delegate access in Microsoft 365 administration
- 01:23
- Viewed 461 times
-
Request a Read Receipt or Delivery Confirmation
- 02:01
- Viewed 450 times
-
Edit or delete an appointment, meeting or event
- 01:50
- Viewed 448 times
-
Create your reservation page for appointment booking (Bookings)
- 03:17
- Viewed 447 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 408 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 402 times
-
Send a survey or questionnaire by email
- 02:06
- Viewed 381 times
-
Add and manage multiple accounts on Outlook
- 01:24
- Viewed 380 times
-
Create and add a signature to messages
- 01:26
- Viewed 374 times
-
Manage new message notifications
- 01:40
- Viewed 372 times
-
Create different types of events
- 01:46
- Viewed 368 times
-
Recall or replace an e-mail message
- 01:45
- Viewed 367 times
-
Set Your Work Hours in Outlook
- 02:02
- Viewed 364 times
-
Use the Meeting Dashboard
- 02:48
- Viewed 364 times
-
Create an appointment or meeting
- 01:44
- Viewed 360 times
-
Create a Meeting Poll
- 02:48
- Viewed 358 times
-
Block a sender
- 01:54
- Viewed 357 times
-
Process an incoming message
- 01:53
- Viewed 353 times
-
Sort and filter emails
- 02:51
- Viewed 346 times
-
Explore the Interface
- 03:22
- Viewed 340 times
-
Send Emails on Behalf of Someone Else
- 01:13
- Viewed 340 times
-
Presentation and introduction to the calendar
- 01:35
- Viewed 338 times
-
Edit and customize views
- 01:55
- Viewed 334 times
-
Share a task list
- 03:10
- Viewed 333 times
-
Respond to a meeting
- 01:00
- Viewed 330 times
-
Create a task or reminder
- 01:50
- Viewed 326 times
-
Attach files efficiently in Outlook
- 02:20
- Viewed 323 times
-
Save and Print a Message
- 01:48
- Viewed 322 times
-
Create an Email Template
- 01:40
- Viewed 322 times
-
Respond to a Meeting Poll
- 01:30
- Viewed 322 times
-
Add a third-party application
- 02:40
- Viewed 321 times
-
Manage Teams online meeting options
- 01:56
- Viewed 319 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 318 times
-
Organize into Folders
- 01:57
- Viewed 317 times
-
Create a task from a message
- 02:00
- Viewed 316 times
-
Change the default font of your emails
- 01:05
- Viewed 314 times
-
Manage Views
- 02:36
- Viewed 309 times
-
Send Automatic Out-of-Office Replies
- 02:22
- Viewed 309 times
-
Open a Shared Calendar
- 01:29
- Viewed 306 times
-
Introduce the new version of Outlook
- 02:01
- Viewed 302 times
-
Use the Scheduling Assistant
- 01:42
- Viewed 300 times
-
Improve Email Accessibility
- 02:02
- Viewed 297 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 297 times
-
Collaborate directly during an event with Microsoft Loop and Outlook
- 02:01
- Viewed 297 times
-
Make Your Outlook Signature Accessible
- 01:12
- Viewed 294 times
-
Use a Shared Mailbox
- 01:18
- Viewed 294 times
-
Share Your Calendar
- 01:54
- Viewed 293 times
-
Prevent transfer for a meeting
- 01:19
- Viewed 292 times
-
Search options
- 01:23
- Viewed 291 times
-
Delay Email Delivery
- 01:10
- Viewed 290 times
-
Calendar Delegation Setup
- 01:21
- Viewed 287 times
-
Identify a fraudulent email
- 02:06
- Viewed 285 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 284 times
-
Automate Routine Actions
- 02:19
- Viewed 282 times
-
Share a document securely with Outlook
- 02:21
- Viewed 282 times
-
Mailbox Delegation Setup
- 01:59
- Viewed 280 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 279 times
-
Create and Manage Appointments in Delegated Calendars
- 02:04
- Viewed 276 times
-
View Other Calendars
- 00:50
- Viewed 272 times
-
Use Categories
- 02:51
- Viewed 271 times
-
Use Conversation View
- 01:47
- Viewed 270 times
-
Prevent the forwarding of an email
- 01:01
- Viewed 270 times
-
Translate Emails in Outlook
- 01:32
- Viewed 268 times
-
Clean Up Your Inbox
- 01:18
- Viewed 264 times
-
Respond to invitations as a delegate
- 02:55
- Viewed 264 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 260 times
-
Display Three Time Zones
- 01:52
- Viewed 256 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 254 times
-
Protect an email by encrypting
- 01:10
- Viewed 253 times
-
Easily Sort Your Mails
- 01:38
- Viewed 249 times
-
Provide an overview of best security practices in Outlook
- 01:08
- Viewed 243 times
-
Respect Your Colleagues' Off Hours (Viva Insights)
- 01:27
- Viewed 242 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 242 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 231 times
-
Introduction to PowerBI
- 00:60
- Viewed 255 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 242 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 239 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 267 times
-
Introduction to Planner
- 00:56
- Viewed 250 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 288 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 252 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 364 times
-
Introduction to Sway
- 01:53
- Viewed 329 times
-
Introducing to Word
- 01:00
- Viewed 238 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 227 times
-
Create a call group
- 01:15
- Viewed 384 times
-
Use call delegation
- 01:07
- Viewed 193 times
-
Assign a delegate for your calls
- 01:08
- Viewed 352 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 196 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 198 times
-
Manage advanced call notifications
- 01:29
- Viewed 204 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 317 times
-
Block unwanted calls
- 01:24
- Viewed 233 times
-
Disable all call forwarding
- 01:09
- Viewed 217 times
-
Manage a call group in Teams
- 02:01
- Viewed 238 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 195 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 197 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 217 times
-
Manage voicemail messages
- 01:55
- Viewed 317 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 351 times
-
Customize your voicemail greeting
- 02:17
- Viewed 191 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 244 times
-
Manage simultaneous calls
- 01:52
- Viewed 217 times
-
Support third-party apps during calls
- 01:53
- Viewed 260 times
-
Add participants quickly and securely
- 01:37
- Viewed 205 times
-
Configure call privacy and security settings
- 02:51
- Viewed 201 times
-
Manage calls on hold
- 01:20
- Viewed 208 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 207 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 200 times
-
Action Function
- 04:18
- Viewed 202 times
-
Search Function
- 03:42
- Viewed 248 times
-
Date and Time Function
- 02:53
- Viewed 255 times
-
Logical Function
- 03:14
- Viewed 393 times
-
Text Function
- 03:25
- Viewed 260 times
-
Basic Function
- 02:35
- Viewed 220 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 262 times
-
Introduction to Power Fx
- 01:09
- Viewed 256 times
-
The New Calendar
- 03:14
- Viewed 433 times
-
Sections
- 02:34
- Viewed 231 times
-
Customizing Views
- 03:25
- Viewed 225 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 489 times
-
Guide to Using the Microsoft Authenticator App
- 01:47
- Viewed 273 times
-
Turn on Multi-Factor Authentication in the Admin Section
- 02:07
- Viewed 196 times
-
Concept of Multi-Factor Authentication
- 01:51
- Viewed 257 times
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.