Author Archives: marcus

print yahoo contacts using excel

How to Export and Print Yahoo Contacts?

Do you have a lot of contacts in your Yahoo Mail? If you have many contacts in your Yahoo address book, then this article will be helpful for you because today, I will guide you on how to print yahoo contacts.

As there isn’t any printing option from the page itself, the “Export CSV” feature in Yahoo Contacts enables you to print the address book. Especially for those users who have many contacts and whose address book doesn’t only contain contacts but also email address and other relevant contact information, targeting those users, Yahoo features the “Export CSV.”

How to Print My Yahoo Contacts?

As there isn’t an option to print Yahoo Contacts directly from the Yahoo Mail, we are printing it with the help of an Excel file. So, I have divided the steps into two parts one downloading the Yahoo Contacts CSV file. Or, in simple words exporting the Yahoo Contacts. And the next step to adjusting the Yahoo contacts and downloading via the Excel file.

Steps to Export Yahoo Contacts

To print your address book and contacts, first, you should have access to your account and download your contacts; “Export CSV.”

export yahoo contacts

  1. Log in to your Yahoo Mail account (Username and password)
  2. After you get access to your Yahoo Mail account, On the homepage you will see Mail icon, click on the Mail icon.
  3. After that, on the right side of your screen, click on the Contacts icon beside of calendar and notepad.
  4. Now under Contacts, click on the All, which is the middle of the Top and Lists.
  5. Now, after you click on the All, you will see a list of all contacts you have in your Yahoo Mail.
  6. Click on the three horizontal dots; now you will see two options in the drop-down menu.
  7. Now, hover your mouse over Export (CSV), and click it.
  8. After you click on the Export (CSV) wait a minute, it will download all your contacts in an Excel file.
  9. Now close your browser and Go to Download folder in your device.
  10. Now under the Download folder, you will see Contacts in the “.csv” file format. Open the file in an Excel file to view contact, or you can also print an Excel file.

To Print Yahoo Contacts via Excel

After you download all your contacts from your Yahoo Mail account, if you want to print contacts, then you can print your all contacts via Excel. However, if you come across any problem while printing your contacts via Excel, here is the step to print Yahoo contacts via Excel.

print yahoo contacts via excel

  1. Browse the location on your computer where you have downloaded your contacts.
  2. Now, open the file in Excel. To do so, right-click the file, then click on open with option. Now, select Excel from the list of options.
  3. Once you open the file, you will have to make some changes to your file before printing your Yahoo Contacts, for example, deleting unused labels.
    Here in this article, I only need the Name, Email Address 1, and the primary phone number of each and every person. So, I am deleting the rest of the labels.
  4. Now, make sure your printer is on and press the Keyboard shortcut key “Ctrl+P” on your excel file. This will open the print settings page, which will display how your page will look when it gets printed.
  5. This is the time you adjust your excel cells. Sometimes, when the cells are too big, the content gets out of the printing page, making the printer unable to print the information that is past the printing line.
  6. Now, once you are done editing and adjusting the printing settings, press the print button.

There you go, you have successfully downloaded the Yahoo Contacts CSV file and printed these contacts to a hardcopy.


If you have printed your Yahoo contacts, then you will have all your contacts in your hand. If you need to make a new Yahoo Mail account or if your account is hacked or permanently blocked, then you can add your contacts looking at the contacts, you have printed. And, if you have any questions regarding this article, then you can leave us a comment in our comment box below. Was This Article Helpful? 😊

Frequently Asked Questions [FAQs]

How do I export Yahoo Contacts to excel?

Microsoft Excel supports CSV format too. By default, Yahoo Contacts is in CSV format. Hence you need to download the Yahoo Contacts to export to excel. The detailed step to download Yahoo Contacts is mentioned above on Sub Heading Steps to Export Yahoo Contacts.

How do I export Yahoo Contacts to my Outlook?

First thing first, you need to download yahoo Contacts. The steps are mentioned above in this article. After you download the Contacts CSV file. Follow these steps to export Yahoo Contacts to Outlook:

  1. Choose File option from the top menu bar. File Menu will appear.
  2. From File Menu, choose Open & Export > Import/Export. Import/Export wizard gets started.
    Outlook Import/Export
  3. From the Import/Export wizard, Choose option Import from another program or file, and then click Next.
  4. Choose Comma Separated Values [because our Yahoo Contacts is in CSV format], and then choose Next.
    Import/Export Wizard Outlook
  5. In the Import a File box, import your Yahoo Contacts CSV with the help of the browse button.
  6. Microsoft has provided Options to handle duplicates. There are three options which you can see on Import a File Box
    Replace duplicates with items imported:   Replace your contact to the contact present in Outlook, if a contact is already in Outlook and your contacts file.|
    Allow duplicates to be created [Default Option]: Keeps both the contact: In your Yahoo Contact list as well as in Outlook. There is an option to combine info for those people later to eliminate duplicate contacts.
    Do not import duplicate items: If a contact is present in Outlook and as well as your Yahoo contacts file, the contact of Outlook is kept, and the contact of the Yahoo contact file is discarded.
  7. Select the option as per your need and click Next.
    Import File Outlook
  8. In the Select a destination folder box, select the appropriate destination folder and click Next.
  9. Finally, click Finish. Boom! You successfully imported all Your Yahoo Contact list to Outlook.

[Note: The steps are for Outlook 2016, but the steps are very similar for other Versions of Outlook too.]

How do I export Yahoo Contacts to my Gmail?

Assuming that you have downloaded the Yahoo Contact CSV with the help of our article, here are the steps to export Yahoo Contact to Gmail Account.

  1. On your computer browser, navigate to Google Contacts.
  2. If you aren’t logged in, you will be redirected to google login. Login with correct credentials and proceed further.
  3. Select Import Option from the left navigation menu. Import contacts modal will pop up.
  4. Click Select File and Select the Yahoo Contact CSV file you exported from Yahoo Mail. Google support CSV and vCard format file.
    Gmail Import Contacts
  5. Click on Import.
  6. Congratulation, you have successfully Imported Yahoo Contacts to your Gmail Account.

How do I export my Yahoo Contacts to icloud?

Though CSV is a very popular format to store the Contact list, iCloud don’t support CSV format for Contacts. Instead, it prefers a VCF (vCard) format. Hence, importing CSV file contacts to iCloud is a bit complex.

Assuming you have already downloaded the Yahoo Contacts file (CSV file) from Yahoo, the next step is to convert the Yahoo CSV file to vCard format. There are lots of methods to convert CSV files to the VCF (v Card) file. Some of them are:

  1. Import the CSV contact file to Gmail or outlook and again export it back on VCF format.
  2. There are lots of tools online that convert CSV contact to v Card contact. Just google it. One paid tool is SysTools

I prefer method one as it is free.

After you get your CSV contact file on VCF format, you can export that file to iCloud. Here are the steps:

  • Navigate to iCloud using browser or via App. Login to iCloud with correct Apple username and Password
  • Once you are logged in, click on the Contacts icon from the grid menu.
  • From the iCloud Contacts, click the Action pop-up menu [setting icon] in the sidebar, then choose Import vCard option.
    iCloud Contacts
  • Now browser the VCF format of the Yahoo Contacts we converted and then click on the open button. iCloud will import all the contacts on VCF file to iCloud Contacts.
  • Now, you can access Yahoo Contact from iCloud too.

How to Get Rid of Popping Ads on Yahoo?

In this article today, I will guide you on how to get rid of popping ads on yahoo. Not only in Yahoo but every site and URL. You can use software by downloading, or you can use an extension to block pop up ads. Are you irritated with Pop-Up Ads? 

Usually, when we use any web-browser, we get a lot of Pop-Up Ads which irritates and ruin our mind. And the most irritating part, sometimes irritation turns into anger, while you are in a hurry and you need to send urgent text, message or send attachment and browser throws Ads which doesn’t only disturb you but also makes your device hang. To avoid such a case, you can get rid of popping ads on the Yahoo homepage by using block Ads extensions.

Using Block Ads extensions will block all ads and pop up messages that will display in your web browser. Now you can do your work without any irritation or frustration. So, let’s see how to get rid of Pop-Up ads.

Get Rid of Pop up Ads.

The web browser doesn’t have any blocking ads features, but you can use an extension to block those Popping ads. You can use extensions in any web browser like Google Chrome, Mozilla Firefox, Internet Explorer.

How to install Ads blocker extensions on Google Chrome

Google chrome is the most used browser with advance features and smoothness. Using extension doesn’t block Yahoo ads only but also all Ads you will get in your Google Chrome. You can also manually set up and block ads on a particular URL. So, make sure is not in the list “Allowed sites.”

  1.  Open Google Chrome from your device.
  2. Now in the search field of Google Chrome, search ads blocker.
  3. After that, you will see the search result on your screen. Now scroll down and choose any ads Blocker you want to use.
  4. Click on the link and open the Extension.
  5. Now on the right side of the extension name, you will see Add to Chrome.
  6. Click on the Add to Chrome. After that, you will see the pop-up message, click on the Add extension.
  7. Now wait for few minutes, it will automatically install in your device, and you will get a notification.
  8. You on the navigation bar, you will see Ads blocker icon-only, if it was successfully installed.

How to install Ads blocker extensions on Mozilla Firefox?

You can download extensions, or you can also directedly insert them in your Mozilla by installing an inside the browser. After you download and install the extension you can add Block manually and set up to block Ads on Yahoo install the extension and make sure is not in the list, the URL in the list will not block ads its “Allowed sites.”

  1. Open Mozilla Firefox in your device you are using.
  2. In the search field of Mozilla, search Ad-block plus or any extensions you want to add.
  3. Now, click on the link and open the extension you want to use.
  4. Now, under Ads blocker name, you will see the Download Now button. Click on the Download Now button.
  5. Now you will see “learn more about Firefox,” click on the Download anyway link just below learn about Firefox.

  6. Now this will download the extension in your device, open download extension from Download file.
  7. Now you will see the setup of the extension box, after that click on the Ads blocker and install button bottom right of the box.
  8. Now you will see a successful notification after you install it. Now go to Mozilla Firefox you will see the extension in the navigation bar.

You can also Add ads block extension following steps.

  • Open Mozilla Firefox and search for the Ads blocker extension.
  • Now click on the green arrow icon from the extension.
  • After that, click on Add to Firefox of the extension.
  • Install the extension, click on the Install, and then click on the Restart Now if error.
  • Now after successful Install, you will be notified and can see an extension in the navigation bar of Mozilla Firefox.

How to install Ads blocker extensions on Internet Explorer?

In Internet Explorer, you can use simple Ad-block or Ad-block IE to block popping ads. After installing extension and software, you can set it manually or leave it default. The default will block all the ads in your Internet Explorer, but you can allow other URLs to get ads by mentioning URL in “Allowed sites.” Make sure is not listed.

Internet Explorer: Simple AdBlock (Extension)

  1. Open Internet Explorer and navigate to AdBlock.
  2. Choose Adblocker and click on the Download Now.
  3. After that, click on the Download Installer.
  4. Now, after you download, click on the Run button after that accept the terms of the license agreement.
  5. Now follow the prompts and install the add-on.
  6. After you install, click on the Finish and then click on the Enable.
  7. After you install and enable the extension, you can see an extension you added in the navigation bar of the Internet Explorer.

Internet Explorer: AdBlock IE (Software)

  1. Open Internet Explorer and navigate to AdBlock IE.
  2. Choose AdBlock IE and click on the Download AdBlock IE and then click on the Run button.
  3. After that, click on the Yes if prompted.
  4. Now click on the Next button and install the software. Go through terms and accept the agreement.
  5. After that, click on the Enable button to add an extension.
  6. You can find software in setting, the software you are using to block ads.


Now you can stop/block pop up ads and messages while you are using your Yahoo Mail in Google Chrome, Mozilla Firefox, or Internet Explorer. You can also manually select the URL that you want to see ads and insert URL in the “Allowed Sites” list. I hope you can now block Pop-Up Ads and messages. If you have any questions regarding this article, then you can leave us a comment in the comment section below, and you can visit our official website for more Yahoo guide.

Was this article helpful?

set up filter in yahoo mail

How to Set up Filter / Create Rule in Yahoo Mail

Is Yahoo Mail account the primary email service that you use for your business purpose? Do you get a lot of emails daily or get spam messages, notification, and subscription messages? These unwanted emails take over your inbox and will make a mess to your mailbox. If you are one of those people, don’t worry we have got your back. Today in this article, we are going to guide you on how to set up a filter in Yahoo Mail or set a rule for email you receive from a specific place or any people so that all your emails are in one place.

Spam messages, or any unwanted messages takeover your mailbox and move your important emails down on the list making the emails hidden from your sight. So, in such situations, you can either block an unauthorized email address or unwanted emails, or you can create a filter/set a rule in Yahoo Mail. Setting up a filter in yahoo can separate filtered emails to a folder grouping them together in one place. When you create a filter based on specific criteria, you can also manually move all the related messages into a folder, archives, or the trash.

So, without further ado, let’s move to the steps by step procedure to create a filter or set rule in Yahoo Mail, I am writing this guide with an example so that it will be helpful for you to understand and set up a filter in Yahoo Mail.

How to Set up Filter in Yahoo Mail?

  1. Go to any web browser you are using.
  2. Enter URL
  3. Log in using the email address and password.
  4. Now click on the Mail icon, which is in the upper right corner of your screen.
  5. Next, click on the Gear icon that’s at the upper right corner of your Mailbox, this will open up the setting drop-down menu.
  6. Now, scroll down the settings drop-down menu and click on the …More settings.
  7. From the settings page look for Filters on the left sidebar and Now click on the Filters from the lists.
  8. Now click on the Add New Filter from the Filters Settings.
  9. Once you click on the add new filters a form will appear on the view page of the filter page where you will have to give in the detail about the filter.
    I have provided the detail information or let’s say guide on how to fill up the filter form right after the steps completes. so, if you have any problems regarding the form follow the steps written in the example below.
  10. Fill (Filter name>Setup rules>Choose a folder to move to). Finally, click on the Save button.

You have successfully created a filter and set rules for a filter message.

set up filter in yahoo mail

Example of How to Fill up Forms to set up Filter in Yahoo Mail.

After you follow the steps on how to create a filter in the filter, now, I will guide you on how to fill-up the form before clicking on the Save button.

  1. The first information you need to fill up is a Filter name in a text area for the filter name “Type a filter name.” Now you can give any random name for the filter.
  2. Then the second information you have to fill up is set rules, where you can see different subheadings to fill the information.
    Now under From drop-down menu, select any filter criterion and provide an email address of the sender (for example, [email protected]); make sure the Match case is not checked.
    To receive your email and send it to your alternative address, put your alternative address in the text field under To/CC.
    Under Subject, select the option contains the list. And type the main keyword in the text field that might be important such as (Yahoo mail); if you enter Yahoo Mail in the text field then, all the email messages containing Yahoo Mail get the filter and saved in the folder you choose.
    Now, move the messages you filter, it can be moved to a folder. For example, you can select folder name (inbox) or any from the list, and even you can make your folder by giving a name in the Folder name
  3. Finally, after you fill up all the sections from the form, you can click the Save button to set a rule.

How to Edit created Filters in Yahoo Mail?

  1. Go to any web browser you are using.
  2. Type, to redirect to the Yahoo login.
  3. Log in using the email address and password.
  4. Now click on the Mail icon, which is in the right corner of your screen.
  5. You will see the gear icon as settings. Click on the Gear icon.
  6. When settings open, scroll down and click on the …More settings.
  7. You will see a list of settings. Now click on the Filters from the lists.
  8. Now, select the filter name you want to edit. You will see the Edit filter just right side.
  9. After that, edit the information in the text field likewise, you fill-up the form while creating.
  10. After you finish editing, click on the Save button to save the change.

Now you have successfully edited the filter that you have created.

How to Delete a Filter in Yahoo Mail?

If you think to create a filter in Yahoo Mail is not essential for your email service and if you get fewer messages and it’s your personal account where you have selective people then you can delete the filtered after you set the rule. To delete your filter in Yahoo Mail, follow the following steps mentioned below;

  1. Go to any web browser.
  2. Go to
  3. Log in using the email address and password.
  4. Now click on the Mail icon.
  5. After you click on the Mail icon, you will see the gear icon. Click on the Gear icon.
  6. When settings open, scroll down and click on the …More settings.
  7. After you click on the more settings, you will see a list of settings. Now click on the Filters from the lists.
  8. When you click on the Filters, on the left side of your screen you will see Add New Filter and just right to it there is a trash icon. Select the filter you want to delete and click on the trash icon.
  9. Now to confirm the deletion, click on the Delete button.

Now you will see a message on your screen in the middle of the page, ” Message filter has successfully saved.


Now you can create a folder for important messages or spam messages to group them in the same folder and set up a filter in Yahoo Mail or set a rule for email you receive by following the steps mentioned above. It will manage your inbox like a furnished home (haha!!). I hope you will be able to follow the step easily. If you have any questions and doubts regarding steps then, you can feel free and leave a comment in the comment section below we will try to provide an answer to your question. Thank you!

Was this article helpful?