How to import mail adress to excel

There are a few ways to import email addresses from a mail client or a file to Excel:

Method 1: Using Outlook

1. Open Outlook and select the folder containing the email addresses you want to import.
2. Go to "File" > "Open & Export" > "Export to a file".
3. Select "Comma Separated Values (CSV)" as the file format.
4. Choose a location to save the file and click "Export".
5. Open Excel and go to "Data" > "From Text" > "Text Files".
6. Select the CSV file you just exported and click "Import".
7. In the "Text Import Wizard", select "Delimited Text" and click "Next".
8. Choose the delimiter (e.g., comma) and click "Finish".

Method 2: Using Gmail

1. Log in to your Gmail account and go to the "Contacts" page.
2. Click on the "More" menu and select "Export".
3. Choose the format as "CSV" and click "Export".
4. Save the file to your computer.
5. Open Excel and go to "Data" > "From Text" > "Text Files".
6. Select the CSV file you just exported and click "Import".
7. In the "Text Import Wizard", select "Delimited Text" and click "Next".
8. Choose the delimiter (e.g., comma) and click "Finish".

Method 3: Using a CSV file

1. Export your email addresses from your mail client or a file to a CSV file.
2. Open Excel and go to "Data" > "From Text" > "Text Files".
3. Select the CSV file and click "Import".
4. In the "Text Import Wizard", select "Delimited Text" and click "Next".
5. Choose the delimiter (e.g., comma) and click "Finish".

Tips

• Make sure to select the correct delimiter (e.g., comma, semicolon, or tab) when importing the file.
• You can also use the "Text to Columns" feature in Excel to import the email addresses from a CSV file.
• If you have a large number of email addresses, you may want to consider using a third-party add-in or tool to import them into Excel.