*Copy the names and emails to a file
   *Save the file as "CSV"
   *Open Google Sheets
   *File / import
   *Select the file that was just created

{{:google-sheets-import.jpg?200|}}  

   *Select replace spreadsheet and comma
   *Click on import
   *You should now have a spreadsheet with all the names and email addresses in a single row
   *Next, we need to convert this to a single column
   *In cell A2 type =transpose(1:1) and hit enter
   *Copy all the cells from A2 and down
   *Use ctrl V to select all and delete
   *Click on cell A1
   *Edit / Paste special / Values only
   *Move the column divider between A and B
   *Click in cell B1 and type =split(A1,"<>") and hit enter
   *Select column A and B and copy
   *Use ctrl V to select all and delete
   *Click on cell A1
   *Edit / Paste special / Values only
   *File / Download as / Comma-separated values
   *Save 

  * Open MailChimp
  * Lists
  * Click on the email list
  * Add contacts / Import contacts
  * CSV or Tab-delimited text file
  * Next
  * Browse to select file
  * Next
  * Use the drop down box to select Name for the first column and save
  * Use the default name for the second column and save
  * Next
  * Import