Email list hosting service & mailing list manager

Add list members from a spreadsheet

Posted on Nov 27, 2017

When you start to build an email list you may only have a few members. If this is the case, inputting people’s details manually via the Simplelists members area is straightforward. When your list starts to grow, you may find it helpful to add a large number of subscribers at one time, from a spreadsheet. It is also useful to have a spreadsheet copy of all your list members for your own records. In this short post, we explain how to add members to your list from a spreadsheet.

Add list members from spreadsheet

Prepare the spreadsheet

First, open your spreadsheet. Your spreadsheet only needs three columns:

  • First name
  • Last name
  • Email address
If a name is missing, don’t worry as it can be left blank. You can also add notes in another column.

Remove any headers and titles from the spreadsheet (you may need to delete a row to do this). Your list is now ready to go.

Save as a .csv file

Save the file as a .csv file type using the 'Save As’ dialog box in your spreadsheet program. You may be asked if you are that you wish to save as a .csv file. Just select 'OK’ or 'Yes’ when asked. Remember where you save your file.

Upload to Simplelists

Finally, you want to upload the file to Simplelists. Log in to Simplelists and select the 'List members’ page. Click on the 'Upload file’ tab and search for the file that you saved earlier. Make sure that 'comma separated’ is chosen in the drop-down menu on the 'Upload file’ page in Simplelists. Then, click 'Next’.

On the next screen (’Select fields’), select the correct field name for each column of the file (First name, Last name, Email address, etc.). Then, click 'Next’.

The next screen will show you some 'Upload options’ which you can choose to select or not:
  1. By default an entry’s name will be updated when the email address matches an entry already in your address book. If you would also like to update the email address if the full name matches then please check this box.
  2. Send confirmation requests to all addresses uploaded (except those already in the address book and already confirmed).
  3. Delete current address book entries that are not in uploaded file.
When you have selected any options you wish to activate, click 'Finish’. The new members will now be added to your list. You can check that they have been added by viewing your address book from the 'Members home’ page.

You can also watch a short video of these instructions in an earlier post on our blog.

Tags: