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
- 3423 views
-
Excel - Create a PivotTable and analyze your data
- 1:35
- Viewed 4001 times
-
Power BI - Recovering your Data from different sources
- 3:26
- Viewed 4334 times
-
Power BI - Creating your Datasets
- 2:26
- Viewed 3715 times
-
Power BI - Introduction to Power BI Building Blocks
- 3:07
- Viewed 4218 times
-
Power BI - Introduction to Power BI Desktop
- 2:52
- Viewed 4202 times
-
Power BI - General Introduction
- 2:54
- Viewed 5014 times
-
Outlook - Manage attachments
- 1:51
- Viewed 2942 times
-
Excel - Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2755 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 10032 times
-
Change the default font for your emails
- 1:09
- Viewed 7797 times
-
Answering a scheduling poll
- 1:14
- Viewed 7189 times
-
Create a scheduling poll
- 4:12
- Viewed 5526 times
-
Create and modify a group
- 2:19
- Viewed 5448 times
-
Saving a message
- 1:43
- Viewed 5358 times
-
Use the scheduling poll dashboard
- 2:42
- Viewed 4366 times
-
How do I block a sender?
- 1:01
- Viewed 4248 times
-
Tell me what you want to do
- 0:57
- Viewed 4171 times
-
Delay or schedule e-mail sending
- 2:14
- Viewed 4072 times
-
Join a group
- 1:34
- Viewed 4003 times
-
Discovering the Outlook 2016 interface
- 2:54
- Viewed 3939 times
-
Accessing applications from a group
- 1:59
- Viewed 3914 times
-
Organizing your messages using rules
- 2:54
- Viewed 3897 times
-
How do I share a document securely with Outlook?
- 1:49
- Viewed 3887 times
-
Attach a message, a contact, a file, or a task
- 2:22
- Viewed 3864 times
-
Creating a group
- 2:38
- Viewed 3838 times
-
Request a read receipt or confirmation of delivery
- 2:18
- Viewed 3834 times
-
Presentation of the task module
- 3:31
- Viewed 3829 times
-
Automatically mark deleted emails as read
- 0:46
- Viewed 3821 times
-
Recall or replace an e-mail you sent
- 1:25
- Viewed 3815 times
-
Recover deleted items
- 1:43
- Viewed 3791 times
-
Sending automatic replies
- 2:03
- Viewed 3780 times
-
Create a task and create a recurring task
- 2:30
- Viewed 3766 times
-
Process a received message
- 2:02
- Viewed 3742 times
-
Create a task from a message
- 2:14
- Viewed 3687 times
-
Introducing Outlook
- 0:50
- Viewed 3686 times
-
Translate your emails into Outlook
- 2:40
- Viewed 3650 times
-
Insert elements into the mails (table, graphic, images)
- 2:56
- Viewed 3649 times
-
Create an e-mail message
- 2:46
- Viewed 3647 times
-
Let Outlook read your emails out loud
- 0:32
- Viewed 3629 times
-
Presentation and discovery of contacts
- 1:09
- Viewed 3623 times
-
How to launch a New Teams Meeting in Outlook
- 3:49
- Viewed 3610 times
-
Respond to a meeting
- 0:48
- Viewed 3605 times
-
Manage Your Working Time in MyAnalytics
- 0:34
- Viewed 3572 times
-
Creating a draft
- 1:24
- Viewed 3535 times
-
Organizing in folders
- 2:36
- Viewed 3492 times
-
Schedule sending emails in Outlook
- 0:54
- Viewed 3489 times
-
Schedule a meeting
- 1:50
- Viewed 3471 times
-
Calendar delegation
- 1:28
- Viewed 3471 times
-
Using conversation mode
- 1:25
- Viewed 3445 times
-
Discover the new simplified ribbon
- 0:29
- Viewed 3424 times
-
Import contacts into Outlook
- 1:52
- Viewed 3411 times
-
Create a contact & add and use contacts
- 2:36
- Viewed 3404 times
-
Temporarily turn off notifications
- 0:23
- Viewed 3392 times
-
Getting Started with Outlook Mobile App
- 1:53
- Viewed 3370 times
-
The Bcc field in detail
- 1:54
- Viewed 3363 times
-
Dictate email messages in Outlook
- 0:34
- Viewed 3361 times
-
Manage recurring appointments
- 2:12
- Viewed 3354 times
-
Sharing the calendar
- 2:11
- Viewed 3345 times
-
Fill in your work schedules in Outlook
- 1:29
- Viewed 3317 times
-
Create a contact group & Communicate through contact groups (distribution list)
- 3:22
- Viewed 3315 times
-
Publish the calendar
- 1:20
- Viewed 3313 times
-
Quickly sort emails
- 0:27
- Viewed 3310 times
-
Manage displays
- 2:26
- Viewed 3303 times
-
Creating an e-mail template
- 1:16
- Viewed 3302 times
-
Display 3 time zones
- 0:37
- Viewed 3299 times
-
Ribbon preview
- 2:55
- Viewed 3282 times
-
Using categories
- 2:15
- Viewed 3280 times
-
Sorting & searching your mails
- 2:50
- Viewed 3271 times
-
Prevent forwarding of a meeting
- 0:29
- Viewed 3268 times
-
Junk email
- 2:16
- Viewed 3259 times
-
Cleaning your inbox
- 2:39
- Viewed 3259 times
-
Prevent recipients from forwarding emails
- 0:34
- Viewed 3249 times
-
Set or remove reminders
- 0:59
- Viewed 3248 times
-
Introducing Office 365 Groups
- 1:29
- Viewed 3247 times
-
Clutter
- 1:31
- Viewed 3235 times
-
Assigning a task
- 1:13
- Viewed 3235 times
-
Identify meeting members
- 0:26
- Viewed 3225 times
-
Printing messages
- 1:10
- Viewed 3222 times
-
Using the Scheduling Assistant
- 1:07
- Viewed 3203 times
-
Conduct surveys
- 1:38
- Viewed 3200 times
-
How do I recognize a fraudulent email?
- 2:01
- Viewed 3170 times
-
Open a shared calendar
- 1:30
- Viewed 3121 times
-
Custom your personal reminders and notifications
- 0:44
- Viewed 3120 times
-
Show other people's calendar
- 0:52
- Viewed 3114 times
-
Make your Outlook signature accessible
- 0:44
- Viewed 3098 times
-
Having a conversation within a group
- 3:21
- Viewed 3091 times
-
Edit and customize views
- 1:24
- Viewed 3067 times
-
Remove a member from a group
- 0:29
- Viewed 3026 times
-
Create and add a signature to messages
- 1:21
- Viewed 3011 times
-
Create an appointment
- 1:56
- Viewed 3001 times
-
How to protect an email by encryption?
- 2:41
- Viewed 2958 times
-
Manage attachments
- 1:51
- Viewed 2942 times
-
Create a meeting in the group calendar
- 1:12
- Viewed 2923 times
-
Manage new message notifications
- 1:42
- Viewed 2866 times
-
Go further with Outlook Mobile
- 2:24
- Viewed 2841 times
-
Presentation and discovery of the calendar
- 1:26
- Viewed 2807 times
-
Expand your LinkedIn network via Outlook
- 0:39
- Viewed 2795 times
-
General security practices in Outlook
- 1:03
- Viewed 2789 times
-
Outlook Mobile for Daily Use
- 4:46
- Viewed 2783 times
-
Improving email accessibility
- 1:33
- Viewed 2737 times
-
Improve the accessibility of your images in emails
- 0:46
- Viewed 2662 times
-
Add accessible tables and lists
- 0:49
- Viewed 2631 times
-
Edit or delete an appointment, meeting or event
- 1:11
- Viewed 2460 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 1773 times
-
Task Module Overview
- 01:56
- Viewed 653 times
-
Recover deleted items
- 01:09
- Viewed 641 times
-
Organize Your Messages with Rules
- 02:01
- Viewed 614 times
-
The Bcc Field in Detail
- 01:53
- Viewed 541 times
-
Grant delegate access in Microsoft 365 administration
- 01:23
- Viewed 518 times
-
Create your reservation page for appointment booking (Bookings)
- 03:17
- Viewed 503 times
-
Create a reminder for yourself
- 01:59
- Viewed 495 times
-
Request a Read Receipt or Delivery Confirmation
- 02:01
- Viewed 480 times
-
Edit or delete an appointment, meeting or event
- 01:50
- Viewed 480 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 433 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 423 times
-
Recall or replace an e-mail message
- 01:45
- Viewed 412 times
-
Send a survey or questionnaire by email
- 02:06
- Viewed 407 times
-
Add and manage multiple accounts on Outlook
- 01:24
- Viewed 401 times
-
Create and add a signature to messages
- 01:26
- Viewed 400 times
-
Block a sender
- 01:54
- Viewed 393 times
-
Manage new message notifications
- 01:40
- Viewed 391 times
-
Create an appointment or meeting
- 01:44
- Viewed 387 times
-
Create different types of events
- 01:46
- Viewed 386 times
-
Set Your Work Hours in Outlook
- 02:02
- Viewed 385 times
-
Create a Meeting Poll
- 02:48
- Viewed 382 times
-
Process an incoming message
- 01:53
- Viewed 380 times
-
Use the Meeting Dashboard
- 02:48
- Viewed 378 times
-
Send Emails on Behalf of Someone Else
- 01:13
- Viewed 369 times
-
Explore the Interface
- 03:22
- Viewed 366 times
-
Sort and filter emails
- 02:51
- Viewed 361 times
-
Edit and customize views
- 01:55
- Viewed 360 times
-
Presentation and introduction to the calendar
- 01:35
- Viewed 353 times
-
Respond to a meeting
- 01:00
- Viewed 353 times
-
Share a task list
- 03:10
- Viewed 352 times
-
Manage Teams online meeting options
- 01:56
- Viewed 346 times
-
Create a task or reminder
- 01:50
- Viewed 344 times
-
Create an Email Template
- 01:40
- Viewed 342 times
-
Collaborate directly during an event with Microsoft Loop and Outlook
- 02:01
- Viewed 341 times
-
Add a third-party application
- 02:40
- Viewed 341 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 339 times
-
Attach files efficiently in Outlook
- 02:20
- Viewed 338 times
-
Save and Print a Message
- 01:48
- Viewed 337 times
-
Send Automatic Out-of-Office Replies
- 02:22
- Viewed 335 times
-
Respond to a Meeting Poll
- 01:30
- Viewed 335 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 334 times
-
Organize into Folders
- 01:57
- Viewed 333 times
-
Change the default font of your emails
- 01:05
- Viewed 332 times
-
Manage Views
- 02:36
- Viewed 330 times
-
Create a task from a message
- 02:00
- Viewed 329 times
-
Prevent transfer for a meeting
- 01:19
- Viewed 328 times
-
Open a Shared Calendar
- 01:29
- Viewed 325 times
-
Use the Scheduling Assistant
- 01:42
- Viewed 323 times
-
Introduce the new version of Outlook
- 02:01
- Viewed 321 times
-
Calendar Delegation Setup
- 01:21
- Viewed 320 times
-
Share a document securely with Outlook
- 02:21
- Viewed 318 times
-
Delay Email Delivery
- 01:10
- Viewed 316 times
-
Identify a fraudulent email
- 02:06
- Viewed 316 times
-
Make Your Outlook Signature Accessible
- 01:12
- Viewed 315 times
-
Share Your Calendar
- 01:54
- Viewed 315 times
-
Improve Email Accessibility
- 02:02
- Viewed 312 times
-
Use a Shared Mailbox
- 01:18
- Viewed 311 times
-
Mailbox Delegation Setup
- 01:59
- Viewed 310 times
-
Prevent the forwarding of an email
- 01:01
- Viewed 306 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 304 times
-
Search options
- 01:23
- Viewed 301 times
-
Automate Routine Actions
- 02:19
- Viewed 298 times
-
Translate Emails in Outlook
- 01:32
- Viewed 297 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 295 times
-
Create and Manage Appointments in Delegated Calendars
- 02:04
- Viewed 295 times
-
View Other Calendars
- 00:50
- Viewed 292 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 291 times
-
Respond to invitations as a delegate
- 02:55
- Viewed 288 times
-
Use Categories
- 02:51
- Viewed 287 times
-
Use Conversation View
- 01:47
- Viewed 285 times
-
Clean Up Your Inbox
- 01:18
- Viewed 279 times
-
Display Three Time Zones
- 01:52
- Viewed 277 times
-
Protect an email by encrypting
- 01:10
- Viewed 273 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 272 times
-
Easily Sort Your Mails
- 01:38
- Viewed 266 times
-
Provide an overview of best security practices in Outlook
- 01:08
- Viewed 266 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 265 times
-
Respect Your Colleagues' Off Hours (Viva Insights)
- 01:27
- Viewed 259 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 249 times
-
Instant alerts tailored to your activities
- 01:53
- Viewed 4 times
-
Seamless collaboration inside Microsoft Teams
- 01:22
- Viewed 5 times
-
Easy sharing with your team or organization
- 01:12
- Viewed 4 times
-
Relevant views to highlight your information
- 01:52
- Viewed 10 times
-
Clear insights through filters and sorting
- 02:06
- Viewed 5 times
-
A well-structured form for easy entry
- 01:17
- Viewed 5 times
-
The right column type for each data set
- 02:35
- Viewed 4 times
-
Custom columns to match your needs
- 02:09
- Viewed 4 times
-
Smooth updates and management for any list
- 01:06
- Viewed 3 times
-
Simple ways to add data to your list
- 01:06
- Viewed 4 times
-
Excel data turned into a dynamic list
- 02:08
- Viewed 5 times
-
A fully custom list built from scratch
- 01:34
- Viewed 5 times
-
A quick setup with ready-made templates
- 01:34
- Viewed 6 times
-
Mobile access to your lists made simple
- 01:37
- Viewed 8 times
-
The essentials of the Lists interface
- 02:01
- Viewed 6 times
-
The key reasons to use Microsoft Lists
- 02:01
- Viewed 5 times
-
Introduction to PowerBI
- 00:60
- Viewed 280 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 265 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 257 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 290 times
-
Introduction to Planner
- 00:56
- Viewed 268 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 404 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 276 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 414 times
-
Introduction to Sway
- 01:53
- Viewed 351 times
-
Introducing to Word
- 01:00
- Viewed 254 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 243 times
-
Create a call group
- 01:15
- Viewed 442 times
-
Use call delegation
- 01:07
- Viewed 210 times
-
Assign a delegate for your calls
- 01:08
- Viewed 409 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 215 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 215 times
-
Manage advanced call notifications
- 01:29
- Viewed 226 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 361 times
-
Block unwanted calls
- 01:24
- Viewed 258 times
-
Disable all call forwarding
- 01:09
- Viewed 237 times
-
Manage a call group in Teams
- 02:01
- Viewed 257 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 210 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 215 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 233 times
-
Manage voicemail messages
- 01:55
- Viewed 366 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 401 times
-
Customize your voicemail greeting
- 02:17
- Viewed 210 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 275 times
-
Manage simultaneous calls
- 01:52
- Viewed 239 times
-
Support third-party apps during calls
- 01:53
- Viewed 333 times
-
Add participants quickly and securely
- 01:37
- Viewed 222 times
-
Configure call privacy and security settings
- 02:51
- Viewed 225 times
-
Manage calls on hold
- 01:20
- Viewed 223 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 230 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 217 times
-
Action Function
- 04:18
- Viewed 218 times
-
Search Function
- 03:42
- Viewed 265 times
-
Date and Time Function
- 02:53
- Viewed 285 times
-
Logical Function
- 03:14
- Viewed 445 times
-
Text Function
- 03:25
- Viewed 278 times
-
Basic Function
- 02:35
- Viewed 235 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 277 times
-
Introduction to Power Fx
- 01:09
- Viewed 278 times
-
The New Calendar
- 03:14
- Viewed 483 times
-
Sections
- 02:34
- Viewed 250 times
-
Customizing Views
- 03:25
- Viewed 240 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 548 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