How to quickly create a mailing list
In this tutorial, I will show you how to extract all your email in a Gmail account and download them into an editable spreadsheet so you can quickly create a mailing list.
EDIT: I have recorded a video walk through of exactly how to do this - click here and then select the second course - "How to create an email list in 1 day".
Of course, it is not quite that simple. Your list should be warm, engaged and you should never spam your list, but you need to start somewhere. Here is the simplest way to begin.
The great news is you already have a list locked up in your inbox. I am willing to bet there are hundreds, if not thousands of emails addresses inside your email client.
In this tutorial, I will show you how to extract all your email in a Gmail account and download them into an editable spreadsheet. This should apply equally to other email clients like Outlook. From there, you can clean up the list ready for upload to your favourite email marketing tool.
Step 1 - open Gmail (duh!)
- Click the 9 dots on your upper right screen.
- Then click "contacts".
- You will be directed to your contacts. On the left navigation click "Other contacts". You will be able to view all your email contacts.
- Select the first record in the list. This will bring up a toolbar which lets you do step 5.
- Click the small drop down arrow in the tool bar and click "all". C
- lick the 3 dots on the upper part, then export. Choose google CSV.
- Now you can edit the spreadsheet in your favourite spreadsheet prgm. I recommend google sheets.
Step 2 - Extract the names
- Open the sheet. You will see multiple columns that are blank.
- Delete all the blank ones so you are just left with those columns that have meaningful data. Gmail will have done its best to place the first name in the "Given Name" column. But in many instances, it will be blank. You want the first name so that your emails can addressed to "Dear Joe"
- Sort the sheet by the “Given Name” column in descending order. This will place all the blank cells, ie no 1st name at the bottom of the list.
- Paste "=LEFT(E12,SEARCH("@",E12)-1)" into the 1st blank cell in the "Given Name" column. You may need to change the "," to a ";" depending on the spread sheet program you are using.
- Replace “E12” with cell address of the cell that has the email address and press enter. This will populate the cell with all the text before the @ of the email address.
- Drag the formula through all the bank cells and hey presto, U should have 1st names (mostly) for your email address.
Step 3 - Remove the role based address
The next step is to work through your email address and remove all the generic email address like info@ or admin@. Also, delete emails you know are not valid or you do not want in your list. Correct the 1st names as well. The formula will have done the heavy lifting but you will need to polish up the results.
Step 4 - Review your list
Do not just upload this list and bulk send. This has been a great start but you need to spend time really working through the list. It may seem like a tedious process but you can get it done in a day, whereas collecting email address via your website opt-ins can take months even years.
Remember, while each of these people has emailed you, they have not opted in to your email list. If you start bombarding them you will get a ton of bounces, unsubscribes and end up being blacklisted super quickly and that is a disaster.
Step 5 - Segment, send and get permission
I suggest really painstakingly working through your list and segmenting it into friends, customers, family and so on. Then bit by bit email small sub-segments inviting them to join your list. Give them a compelling reason to do so.
Keep the sub-segments small so that any bounces or spam listing is small. Don’t be in a rush, you can spread this out over several months. Again, it may seem tedious but is 10 times faster than building a brand new list from scratch via website opt-ins.