Export Yahoo Contacts to Outlook: Steps and Common Fixes

Yes. Export your Yahoo contacts as a CSV file, then import that file into Outlook; CSV is the practical route for moving a whole address book because it can carry names, email addresses, phone numbers, and other contact fields. Export first, check the file, and use Outlook’s contact-import option rather than opening the CSV as a spreadsheet.

What the transfer does—and what it does not do

The export-and-import process copies contact details from Yahoo into Outlook. It does not move your Yahoo mailbox, calendar, folders, or messages, and it does not link the two address books for ongoing synchronization. After importing, a change to a contact in Yahoo will not automatically update its Outlook copy. If you want both services to contain the same people, you will need to repeat the export and import occasionally or maintain one address book as your main copy.

A contact file can include more than a person’s name and email address. Depending on the information saved in Yahoo and the export format, it may contain phone numbers, company details, addresses, notes, and additional email fields. Outlook’s contact fields do not always match Yahoo’s field names exactly, so some information may need to be mapped during import or checked afterward. The number of contacts and the available fields also depend on what is actually stored in your Yahoo account.

For a one-time transfer, CSV is usually easier to inspect and import than a vCard file. A vCard, often ending in .vcf, is convenient for sharing one contact or for importing into address-book apps that favor that format. If Yahoo offers a Microsoft Outlook CSV choice, use it; otherwise, use the general CSV export and review the imported fields.

Export your Yahoo contacts to a file

Yahoo’s layout can change, but the goal is to find the contact export command in Yahoo Contacts. Sign in to Yahoo Mail, open Contacts—often through the contacts icon or the app navigation—and look for an actions, more-options, or export menu. Select the option to export contacts and choose a CSV format if Yahoo asks which format to use.

Sign in to the Yahoo account that contains the address book.
Open Yahoo Contacts and locate its export command. It may appear under an actions or more-options menu.
Choose a CSV option, preferably one labeled for Outlook if that choice is presented.
Confirm the export and save the downloaded file somewhere easy to find, such as Downloads. Keep its .csv extension.
Optionally open the file in a spreadsheet or text editor to check that it contains the expected contacts. Do not save it again in a different format unless you know how that affects its columns and encoding.

If you cannot find the export control, confirm that you are in Contacts rather than simply viewing the Yahoo Mail inbox. Menu names and placement can differ between desktop and mobile layouts. For a large transfer, the desktop website is generally easier to navigate and makes it simpler to locate the downloaded file afterward.

Import the CSV into Outlook

The exact steps depend on which Outlook you use. In classic Outlook for Windows, the built-in Import/Export Wizard is the standard way to bring in a CSV. Open Outlook and choose File > Open & Export > Import/Export. Select Import from another program or file, choose Comma Separated Values, and browse to the Yahoo CSV. When asked how to handle duplicates, choose an option that fits your goal: replace existing contacts, allow duplicates, or avoid importing duplicates. If this is your first import, avoiding duplicates is often the least surprising choice.

Next, select the Outlook contacts folder that should receive the records. Most people choose the main Contacts folder for the intended mailbox. Use the wizard’s field-mapping control if it is shown, and check that Yahoo’s name and email columns correspond to Outlook’s matching fields. Complete the wizard and allow Outlook to finish. The imported records should then appear in the selected folder; search for a distinctive name or email address to confirm that the import worked.

In Outlook on the web, open People, then choose Manage contacts > Import contacts and select the Yahoo CSV file. Follow the prompts to complete the import. The People experience in new Outlook for Windows may provide the same or a similar contacts-management route; if the labels differ, look in People for the contact-management or import option. Outlook for Mac has a different interface from classic Outlook for Windows, and the available import path can vary by version. If you do not see a CSV import option in your Mac edition, use Outlook on the web with the same Microsoft account as a practical alternative.

Outlook may take a little time to display a large imported list, especially if it is syncing to an online mailbox. Avoid running the same import repeatedly just because the contacts do not appear instantly. First refresh People or Contacts, check the selected account and folder, and search for a contact you know was in the CSV.

Check field mapping and contact details

CSV files store information in columns, while Outlook stores it in named contact fields. For example, a Yahoo column for a first name should populate Outlook’s first-name field, and an email column should populate an email-address field. A field that has no clear Outlook equivalent may be left unmapped or placed in a less suitable field. That is why checking a few records after import matters, particularly if you rely on company names, multiple phone numbers, postal addresses, or notes.

When the classic Outlook wizard offers Map Custom Fields, compare the fields on the source side with the destination fields. Drag a source field to the corresponding Outlook field when the wizard requires manual mapping. Do not assume that similarly named columns always land correctly. For instance, a display name may import as a single name rather than being separated into first and last names. If the result is imperfect, a clean re-import after correcting the mapping may be easier than editing every contact individually.

Before making a large change, test with a small sample if your export method allows it, or import once and inspect several representative entries. Check a contact with only an email address, one with a company and phone number, and one with multiple details. This can reveal a mapping issue that would be hard to notice by looking only at the total contact count.

Prevent duplicates and avoid repeated imports

Importing the same CSV more than once can create duplicate contact records, depending on the Outlook version, the duplicate-handling choice, and whether Outlook recognizes the entries as existing contacts. A person may also appear twice if the Yahoo address book already contains separate records for the same person, or if you have imported contacts into more than one Outlook account or folder.

Before importing, decide whether the file represents a first-time migration or a refresh of contacts already in Outlook. For a first import, an option to skip duplicates can reduce clutter, but matching rules may not identify every equivalent record. For a refresh, replacing existing records may be appropriate only if you understand which Outlook entries will be affected. Allowing duplicates is useful for a controlled test, but it is usually not the right choice for a routine full-address-book import.

Do not treat CSV import as a merge or synchronization tool. If you need to update old records, compare the relevant lists and choose a method that preserves the details you want. Keep a copy of the original Yahoo export before editing, and avoid deleting the Yahoo contacts until you have verified the Outlook copy and confirmed that it is in the correct account.

Common problems and practical fixes

Outlook cannot find the file: Check the folder where your browser saves downloads, and confirm that the selected file ends in .csv. If the browser renamed it, select the actual downloaded file rather than a shortcut.
The import wizard shows unreadable characters: The file may use an encoding Outlook does not interpret as expected. Avoid changing the file with an editor that may alter its encoding. If needed, export a fresh copy from Yahoo and try that file.
Names or phone numbers are in the wrong fields: Review the field mapping, especially in the classic Outlook wizard. Some phone labels or extra email columns may not map automatically to the fields you expect.
Contacts appear missing: Check the destination account and Contacts folder, refresh the People view, and search for a known contact. A contact may have been imported into a different mailbox or folder than the one currently displayed.
There are too many duplicate records: Stop repeating the import. Use Outlook’s contact list to identify and remove duplicates carefully, or restore a prior state if your account offers one. For future imports, select a duplicate-handling option before completing the wizard.
The file opens as a jumble in a spreadsheet: That does not necessarily mean the export is broken. A CSV is plain text containing delimited columns, and regional settings can affect how spreadsheet software displays separators. Outlook’s import tool may still read it correctly.

CSV files can also be affected by commas, line breaks, and regional list-separator settings. A properly exported CSV generally quotes text that contains delimiters, but editing and resaving the file in a spreadsheet can change its structure. If a file that worked before fails after editing, try the untouched Yahoo download first.

Privacy, verification, and keeping a backup

Your contact export contains personal information, so treat it like an address book rather than a harmless download. Save it on a device you control, avoid uploading it to unfamiliar conversion websites, and delete extra copies from shared or public computers. If you no longer need the file after confirming the import, remove it from Downloads and empty the recycle bin or trash if appropriate. Remember that copies may also exist in a backup or cloud-synced folder.

Verify the result before relying on it. Check the total list at a high level, then inspect several individual records for correct email addresses, phone numbers, and names. Send a test message only if appropriate, and confirm that Outlook is showing the destination account you intended. Keep the original Yahoo account and export until you are satisfied that important entries have transferred. An export is a copy, not proof that the destination contains every field in the form you expect.

When a different method makes sense

If you only need to move a handful of people, exporting the whole address book may be unnecessary. Yahoo may let you export an individual contact as a vCard, which can then be opened or imported by compatible contact applications. This approach is handy for a few records but becomes tedious for a large list. If your goal is to keep Yahoo and Outlook synchronized continuously, a one-time CSV transfer will not do that; check the current account and synchronization options available in both services before choosing a separate sync solution.

Another option is to keep Yahoo as the address-book source and use it when composing messages, but that does not place the contacts inside Outlook. The right method depends on the outcome you need: CSV for a bulk one-time copy, vCard for selected contacts, or a supported ongoing sync arrangement if you require updates to flow between services. Avoid assuming that connecting an email account to Outlook automatically imports its contact list; mail access and contact transfer are separate tasks.

Frequently Asked Questions

Can I export Yahoo contacts directly to Outlook?
Not as a direct live transfer in the usual workflow. Export the Yahoo address book to a CSV file, then import that file into Outlook. The CSV acts as the handoff between the services.

Will exporting contacts delete them from Yahoo?
No. Exporting creates a file containing a copy of the selected contact information. It does not normally remove the original contacts from Yahoo. Keep the Yahoo address book until you have checked the Outlook import.

Can I import Yahoo contacts into Outlook.com?
Yes. Open People in Outlook.com, choose Manage contacts and then Import contacts, and select the CSV file. Check that you are signed in to the Microsoft account where you want the contacts stored.

Why did Outlook create duplicate contacts?
Duplicates can result from importing the file more than once, choosing to allow duplicates, or having repeated entries in Yahoo or Outlook already. Check the duplicate-handling choice in the import process and avoid rerunning the same import without first checking the results.

Can I use a VCF file instead of CSV?
Sometimes. VCF is useful for individual contacts and may work with compatible Outlook versions or contact apps, but bulk workflows vary. For a whole Yahoo address book, CSV is generally the clearer choice when Yahoo provides it and Outlook offers a CSV import option.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.