How To Paste A List Of Emails Into Excel
Emails are a fundamental part of modern communication, and integrating them into your Excel spreadsheets can enhance your data management capabilities. If you find yourself needing to import a long list of emails into Excel, you’re in the right place. In this article, we’ll walk you through the most effective methods and provide useful tips to simplify the process. By the end, you’ll have a comprehensive understanding of how to seamlessly paste your email data into Excel for improved organization and analysis.
We have these email addresses that need to be pasted in MS Excel.
Method 1 – By Using Text To Column Feature
First we need to separate the email addresses. To do this we will use excel’s Text to column feature.
The Text to Columns feature in Excel is a powerful tool that allows you to split a single column of text into multiple columns based on a specified delimiter or fixed width. This feature is particularly useful when you have data in a single column that needs to be separated or parsed into different categories or fields.
Step 1 – Copy The Email Address
- Copy the email addresses that need to be pasted in excel.
- You can use the shortcut key CTRL + C or right click on the selection & choose copy command from the context menu.
Step 2 – Paste Email Addresses
- Select the cell & paste the email addresses in excel using shortcut key CTRL + V.
Step 3 – Go To The Data Tab
- Go to the data tab, under Data Tools, click on the Text To Column button.
Step 4 – Text To Column Wizard (Step 1)
- Convert text to column wizard will appear on your screen.
- Select Delimited option & click Next button.
Step 5 – Text To Column Wizard (Step 2)
- Check mark semicolon option & click Next button.
Step 6 – Text To Column Wizard (Step 3)
- Set the data format (if you want to) & click the Finish button.
Step 7 – Email Addresses Separated
- All the email addresses will be placed in separate columns.
- You can now cut / paste the email address at the destination cells or you can copy & transpose them using the paste special command.
Method 2 – By Using Power Query Feature
Power Query is a powerful data transformation and data preparation tool in Excel that allows you to import, combine, shape, and transform data from various sources. It provides a user-friendly interface for performing advanced data manipulations and automating data cleansing tasks.
Step 1 – Copy The Email Address
- Copy the email addresses that need to be pasted in excel.
- You can use the shortcut key CTRL + C or right click on the selection & choose copy command from the context menu.
Step 2 – Paste Email Addresses
- Select the cell & paste the email addresses in excel using shortcut key CTRL + V.
Step 3 – Convert The Data Into Table
- Now convert the data into table.
- You can use the shortcut key CTRL + T or you can choose Table styles from the Home tab, under styles group.
- You will be asked to select the source. Click the OK button to insert the Table.
Step 4 – Go To The Data Tab
- Select table, go to the Data tab.
- Click on From Table/Range button under Get & Transform Data group.
Step 5 – Power Query Editor
- Power query editor will appear on your screen.
Step 6 – Go To Transform Tab
- Go to the transform tab, click the split column button under Text Column group.
- Choose By Delimiter option from the drop down menu.
Step 7 – Split Column By Delimiter
- Select Semicolon as delimiter from the drop down menu.
- Under split at, choose Each occurrence of the delimiter.
- For split into, choose Rows.
- Click the OK button.
Step 8 – Go To Home Tab
- Go to the home tab, and under the close group, click on the close & load button.
Step 9 – Table With Email Addresses Inserted
- A new sheet with email address in separate rows will be inserted.