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
- 3430 views
-
Excel - Create a PivotTable and analyze your data
- 1:35
- Viewed 4007 times
-
Power BI - Recovering your Data from different sources
- 3:26
- Viewed 4348 times
-
Power BI - Creating your Datasets
- 2:26
- Viewed 3723 times
-
Power BI - Introduction to Power BI Building Blocks
- 3:07
- Viewed 4230 times
-
Power BI - Introduction to Power BI Desktop
- 2:52
- Viewed 4215 times
-
Power BI - General Introduction
- 2:54
- Viewed 5021 times
-
Outlook - Manage attachments
- 1:51
- Viewed 2948 times
-
Excel - Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2760 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 10101 times
-
Change the default font for your emails
- 1:09
- Viewed 7865 times
-
Answering a scheduling poll
- 1:14
- Viewed 7199 times
-
Create a scheduling poll
- 4:12
- Viewed 5545 times
-
Create and modify a group
- 2:19
- Viewed 5482 times
-
Saving a message
- 1:43
- Viewed 5371 times
-
Use the scheduling poll dashboard
- 2:42
- Viewed 4377 times
-
How do I block a sender?
- 1:01
- Viewed 4263 times
-
Tell me what you want to do
- 0:57
- Viewed 4181 times
-
Delay or schedule e-mail sending
- 2:14
- Viewed 4085 times
-
Join a group
- 1:34
- Viewed 4014 times
-
Discovering the Outlook 2016 interface
- 2:54
- Viewed 3951 times
-
Accessing applications from a group
- 1:59
- Viewed 3925 times
-
Organizing your messages using rules
- 2:54
- Viewed 3911 times
-
How do I share a document securely with Outlook?
- 1:49
- Viewed 3900 times
-
Attach a message, a contact, a file, or a task
- 2:22
- Viewed 3880 times
-
Request a read receipt or confirmation of delivery
- 2:18
- Viewed 3856 times
-
Creating a group
- 2:38
- Viewed 3853 times
-
Presentation of the task module
- 3:31
- Viewed 3843 times
-
Automatically mark deleted emails as read
- 0:46
- Viewed 3834 times
-
Recall or replace an e-mail you sent
- 1:25
- Viewed 3828 times
-
Recover deleted items
- 1:43
- Viewed 3809 times
-
Sending automatic replies
- 2:03
- Viewed 3792 times
-
Create a task and create a recurring task
- 2:30
- Viewed 3780 times
-
Process a received message
- 2:02
- Viewed 3760 times
-
Create a task from a message
- 2:14
- Viewed 3701 times
-
Introducing Outlook
- 0:50
- Viewed 3694 times
-
Translate your emails into Outlook
- 2:40
- Viewed 3664 times
-
Create an e-mail message
- 2:46
- Viewed 3662 times
-
Insert elements into the mails (table, graphic, images)
- 2:56
- Viewed 3657 times
-
Presentation and discovery of contacts
- 1:09
- Viewed 3635 times
-
Let Outlook read your emails out loud
- 0:32
- Viewed 3635 times
-
How to launch a New Teams Meeting in Outlook
- 3:49
- Viewed 3620 times
-
Respond to a meeting
- 0:48
- Viewed 3612 times
-
Manage Your Working Time in MyAnalytics
- 0:34
- Viewed 3578 times
-
Creating a draft
- 1:24
- Viewed 3543 times
-
Schedule sending emails in Outlook
- 0:54
- Viewed 3500 times
-
Organizing in folders
- 2:36
- Viewed 3498 times
-
Schedule a meeting
- 1:50
- Viewed 3481 times
-
Calendar delegation
- 1:28
- Viewed 3476 times
-
Using conversation mode
- 1:25
- Viewed 3455 times
-
Discover the new simplified ribbon
- 0:29
- Viewed 3434 times
-
Import contacts into Outlook
- 1:52
- Viewed 3420 times
-
Create a contact & add and use contacts
- 2:36
- Viewed 3418 times
-
Temporarily turn off notifications
- 0:23
- Viewed 3410 times
-
Getting Started with Outlook Mobile App
- 1:53
- Viewed 3375 times
-
The Bcc field in detail
- 1:54
- Viewed 3373 times
-
Dictate email messages in Outlook
- 0:34
- Viewed 3368 times
-
Manage recurring appointments
- 2:12
- Viewed 3360 times
-
Sharing the calendar
- 2:11
- Viewed 3354 times
-
Create a contact group & Communicate through contact groups (distribution list)
- 3:22
- Viewed 3327 times
-
Fill in your work schedules in Outlook
- 1:29
- Viewed 3324 times
-
Publish the calendar
- 1:20
- Viewed 3321 times
-
Quickly sort emails
- 0:27
- Viewed 3317 times
-
Creating an e-mail template
- 1:16
- Viewed 3311 times
-
Manage displays
- 2:26
- Viewed 3309 times
-
Display 3 time zones
- 0:37
- Viewed 3305 times
-
Ribbon preview
- 2:55
- Viewed 3289 times
-
Using categories
- 2:15
- Viewed 3287 times
-
Prevent forwarding of a meeting
- 0:29
- Viewed 3283 times
-
Sorting & searching your mails
- 2:50
- Viewed 3277 times
-
Junk email
- 2:16
- Viewed 3269 times
-
Cleaning your inbox
- 2:39
- Viewed 3266 times
-
Set or remove reminders
- 0:59
- Viewed 3254 times
-
Prevent recipients from forwarding emails
- 0:34
- Viewed 3254 times
-
Introducing Office 365 Groups
- 1:29
- Viewed 3251 times
-
Assigning a task
- 1:13
- Viewed 3245 times
-
Clutter
- 1:31
- Viewed 3242 times
-
Printing messages
- 1:10
- Viewed 3233 times
-
Identify meeting members
- 0:26
- Viewed 3229 times
-
Using the Scheduling Assistant
- 1:07
- Viewed 3213 times
-
Conduct surveys
- 1:38
- Viewed 3204 times
-
How do I recognize a fraudulent email?
- 2:01
- Viewed 3178 times
-
Open a shared calendar
- 1:30
- Viewed 3128 times
-
Custom your personal reminders and notifications
- 0:44
- Viewed 3124 times
-
Show other people's calendar
- 0:52
- Viewed 3119 times
-
Make your Outlook signature accessible
- 0:44
- Viewed 3102 times
-
Having a conversation within a group
- 3:21
- Viewed 3101 times
-
Edit and customize views
- 1:24
- Viewed 3072 times
-
Remove a member from a group
- 0:29
- Viewed 3030 times
-
Create and add a signature to messages
- 1:21
- Viewed 3019 times
-
Create an appointment
- 1:56
- Viewed 3007 times
-
How to protect an email by encryption?
- 2:41
- Viewed 2966 times
-
Manage attachments
- 1:51
- Viewed 2948 times
-
Create a meeting in the group calendar
- 1:12
- Viewed 2932 times
-
Manage new message notifications
- 1:42
- Viewed 2872 times
-
Go further with Outlook Mobile
- 2:24
- Viewed 2845 times
-
Presentation and discovery of the calendar
- 1:26
- Viewed 2811 times
-
Expand your LinkedIn network via Outlook
- 0:39
- Viewed 2800 times
-
General security practices in Outlook
- 1:03
- Viewed 2794 times
-
Outlook Mobile for Daily Use
- 4:46
- Viewed 2788 times
-
Improving email accessibility
- 1:33
- Viewed 2742 times
-
Improve the accessibility of your images in emails
- 0:46
- Viewed 2668 times
-
Add accessible tables and lists
- 0:49
- Viewed 2636 times
-
Edit or delete an appointment, meeting or event
- 1:11
- Viewed 2466 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 1789 times
-
Task Module Overview
- 01:56
- Viewed 663 times
-
Recover deleted items
- 01:09
- Viewed 647 times
-
Organize Your Messages with Rules
- 02:01
- Viewed 622 times
-
The Bcc Field in Detail
- 01:53
- Viewed 547 times
-
Grant delegate access in Microsoft 365 administration
- 01:23
- Viewed 523 times
-
Create your reservation page for appointment booking (Bookings)
- 03:17
- Viewed 508 times
-
Create a reminder for yourself
- 01:59
- Viewed 499 times
-
Request a Read Receipt or Delivery Confirmation
- 02:01
- Viewed 487 times
-
Edit or delete an appointment, meeting or event
- 01:50
- Viewed 486 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 438 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 429 times
-
Recall or replace an e-mail message
- 01:45
- Viewed 418 times
-
Send a survey or questionnaire by email
- 02:06
- Viewed 412 times
-
Add and manage multiple accounts on Outlook
- 01:24
- Viewed 408 times
-
Create and add a signature to messages
- 01:26
- Viewed 407 times
-
Manage new message notifications
- 01:40
- Viewed 397 times
-
Block a sender
- 01:54
- Viewed 397 times
-
Set Your Work Hours in Outlook
- 02:02
- Viewed 394 times
-
Create an appointment or meeting
- 01:44
- Viewed 392 times
-
Create different types of events
- 01:46
- Viewed 390 times
-
Create a Meeting Poll
- 02:48
- Viewed 389 times
-
Process an incoming message
- 01:53
- Viewed 384 times
-
Use the Meeting Dashboard
- 02:48
- Viewed 382 times
-
Send Emails on Behalf of Someone Else
- 01:13
- Viewed 375 times
-
Explore the Interface
- 03:22
- Viewed 370 times
-
Edit and customize views
- 01:55
- Viewed 367 times
-
Sort and filter emails
- 02:51
- Viewed 366 times
-
Presentation and introduction to the calendar
- 01:35
- Viewed 358 times
-
Respond to a meeting
- 01:00
- Viewed 358 times
-
Share a task list
- 03:10
- Viewed 356 times
-
Create a task or reminder
- 01:50
- Viewed 350 times
-
Manage Teams online meeting options
- 01:56
- Viewed 349 times
-
Create an Email Template
- 01:40
- Viewed 349 times
-
Add a third-party application
- 02:40
- Viewed 349 times
-
Collaborate directly during an event with Microsoft Loop and Outlook
- 02:01
- Viewed 348 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 344 times
-
Attach files efficiently in Outlook
- 02:20
- Viewed 343 times
-
Change the default font of your emails
- 01:05
- Viewed 342 times
-
Save and Print a Message
- 01:48
- Viewed 342 times
-
Send Automatic Out-of-Office Replies
- 02:22
- Viewed 340 times
-
Organize into Folders
- 01:57
- Viewed 338 times
-
Respond to a Meeting Poll
- 01:30
- Viewed 338 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 338 times
-
Manage Views
- 02:36
- Viewed 337 times
-
Create a task from a message
- 02:00
- Viewed 334 times
-
Prevent transfer for a meeting
- 01:19
- Viewed 331 times
-
Use the Scheduling Assistant
- 01:42
- Viewed 329 times
-
Open a Shared Calendar
- 01:29
- Viewed 329 times
-
Introduce the new version of Outlook
- 02:01
- Viewed 326 times
-
Calendar Delegation Setup
- 01:21
- Viewed 325 times
-
Share a document securely with Outlook
- 02:21
- Viewed 323 times
-
Make Your Outlook Signature Accessible
- 01:12
- Viewed 320 times
-
Delay Email Delivery
- 01:10
- Viewed 319 times
-
Share Your Calendar
- 01:54
- Viewed 319 times
-
Identify a fraudulent email
- 02:06
- Viewed 319 times
-
Improve Email Accessibility
- 02:02
- Viewed 316 times
-
Use a Shared Mailbox
- 01:18
- Viewed 316 times
-
Mailbox Delegation Setup
- 01:59
- Viewed 315 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 310 times
-
Prevent the forwarding of an email
- 01:01
- Viewed 310 times
-
Search options
- 01:23
- Viewed 306 times
-
Translate Emails in Outlook
- 01:32
- Viewed 303 times
-
Automate Routine Actions
- 02:19
- Viewed 302 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 300 times
-
Create and Manage Appointments in Delegated Calendars
- 02:04
- Viewed 299 times
-
View Other Calendars
- 00:50
- Viewed 296 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 295 times
-
Respond to invitations as a delegate
- 02:55
- Viewed 292 times
-
Use Categories
- 02:51
- Viewed 291 times
-
Use Conversation View
- 01:47
- Viewed 289 times
-
Clean Up Your Inbox
- 01:18
- Viewed 284 times
-
Display Three Time Zones
- 01:52
- Viewed 283 times
-
Protect an email by encrypting
- 01:10
- Viewed 277 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 276 times
-
Easily Sort Your Mails
- 01:38
- Viewed 271 times
-
Provide an overview of best security practices in Outlook
- 01:08
- Viewed 270 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 269 times
-
Respect Your Colleagues' Off Hours (Viva Insights)
- 01:27
- Viewed 264 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 252 times
-
Instant alerts tailored to your activities
- 01:53
- Viewed 18 times
-
Seamless collaboration inside Microsoft Teams
- 01:22
- Viewed 14 times
-
Easy sharing with your team or organization
- 01:12
- Viewed 16 times
-
Relevant views to highlight your information
- 01:52
- Viewed 22 times
-
Clear insights through filters and sorting
- 02:06
- Viewed 14 times
-
A well-structured form for easy entry
- 01:17
- Viewed 18 times
-
The right column type for each data set
- 02:35
- Viewed 13 times
-
Custom columns to match your needs
- 02:09
- Viewed 14 times
-
Smooth updates and management for any list
- 01:06
- Viewed 14 times
-
Simple ways to add data to your list
- 01:06
- Viewed 14 times
-
Excel data turned into a dynamic list
- 02:08
- Viewed 15 times
-
A fully custom list built from scratch
- 01:34
- Viewed 18 times
-
A quick setup with ready-made templates
- 01:34
- Viewed 18 times
-
Mobile access to your lists made simple
- 01:37
- Viewed 21 times
-
The essentials of the Lists interface
- 02:01
- Viewed 16 times
-
The key reasons to use Microsoft Lists
- 02:01
- Viewed 15 times
-
Introduction to PowerBI
- 00:60
- Viewed 284 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 269 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 261 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 294 times
-
Introduction to Planner
- 00:56
- Viewed 271 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 410 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 280 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 418 times
-
Introduction to Sway
- 01:53
- Viewed 355 times
-
Introducing to Word
- 01:00
- Viewed 258 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 248 times
-
Create a call group
- 01:15
- Viewed 446 times
-
Use call delegation
- 01:07
- Viewed 214 times
-
Assign a delegate for your calls
- 01:08
- Viewed 416 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 219 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 219 times
-
Manage advanced call notifications
- 01:29
- Viewed 230 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 367 times
-
Block unwanted calls
- 01:24
- Viewed 262 times
-
Disable all call forwarding
- 01:09
- Viewed 243 times
-
Manage a call group in Teams
- 02:01
- Viewed 261 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 214 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 219 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 237 times
-
Manage voicemail messages
- 01:55
- Viewed 370 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 408 times
-
Customize your voicemail greeting
- 02:17
- Viewed 213 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 279 times
-
Manage simultaneous calls
- 01:52
- Viewed 245 times
-
Support third-party apps during calls
- 01:53
- Viewed 353 times
-
Add participants quickly and securely
- 01:37
- Viewed 230 times
-
Configure call privacy and security settings
- 02:51
- Viewed 230 times
-
Manage calls on hold
- 01:20
- Viewed 227 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 234 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 221 times
-
Action Function
- 04:18
- Viewed 225 times
-
Search Function
- 03:42
- Viewed 270 times
-
Date and Time Function
- 02:53
- Viewed 292 times
-
Logical Function
- 03:14
- Viewed 451 times
-
Text Function
- 03:25
- Viewed 283 times
-
Basic Function
- 02:35
- Viewed 240 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 282 times
-
Introduction to Power Fx
- 01:09
- Viewed 283 times
-
The New Calendar
- 03:14
- Viewed 487 times
-
Sections
- 02:34
- Viewed 253 times
-
Customizing Views
- 03:25
- Viewed 244 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 552 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.
Cette formation pourrait intéresser votre entreprise ?
Mandarine Academy vous offre la possibilité d'obtenir des catalogues complets et actualisés, réalisés par nos formateurs experts dans différents domaines pour votre entreprise