How to Create a Mailing List from a Google Docs Spreadsheet

Step-by-Step Guide

1. 1

   Step 1: Login to your google account at Google Docs;

   A confirmation saying you can now run the script should have shown up.
   
   Now when looking at your spreadsheet you should see an additional menu item called "Copy & Paste Inversely" (If not: hit file and save, then reload the spreadsheet) This will be used in the next couple of steps. ,,, If so, we can move on to the final steps of the process. ,,
2. 2

   Step 2: Create a New Spreadsheet

3. 3

   Step 3: Paste your column of of emails into the new spreadsheet Select the first cell of the spreadsheet Right click

4. 4

   Step 4: and "Paste"

5. 5

   Step 5: Install a Script to convert the Column into a Row.

6. 6

   Step 6: Copy the Column with the new Script Click the column header to select the entire row

7. 7

   Step 7: or select just the emails you want to make into the list

8. 8

   Step 8: Create a New Sheet Click the symbol at the bottom of the screen

9. 9

   Step 9: Past the Column as a Row with the Script Select the first cell at the top left of the new sheet Now you should have a list of emails going across the screen instead of in a column.

10. 10

    Step 10: Export the Sheet as a CSV file (Comma Separated Values) Select a download directory that you can easily access

11. 11

    Step 11: Open the file in a Text Editor such as Notepad Right click the file

12. 12

    Step 12: "Open with"

13. 13

    Step 13: "Notepad" You will now see that you have a comma separated email list that you can copy and paste into any email application and send your email!

Detailed Guide

About the Author