If you already have a list of people who've asked to hear from you, such as a spreadsheet or a list from another service, you can bring them all onto your mailing list at once. You can also download everyone on your list, or one person's mailing list details. If you haven't turned your mailing list on yet, start with Set up your mailing list.
Add people from a spreadsheet
Save your list as a CSV file first, as described below. Then go to Mailing listPeople and choose Import CSV. Under Add new people to, choose your General mailing list or one of your topics.
Tick These people asked to hear from me. Choose file stays greyed out until you do. Then choose Choose file and pick the file to upload. The import starts as soon as you've picked it.
Importing doesn't change whether people already on your list are on your general mailing list, and anyone who's unsubscribed isn't signed back up. Importing into a topic does add them to that topic, though, and tags in your file are added to theirs.
While you send from the Macadamia mailing address, the people you import are sent an invitation to confirm their email address, spread over a few days. Each person only gets one invitation, so importing someone again won't send them another. They'll get your emails once they've confirmed.
Get your CSV file ready
Most spreadsheet apps can save a sheet as a CSV file. Your file needs a column headed "email". A column headed "Email Address", like Mailchimp uses, works too.
You can also include columns for "first_name", "last_name", "name", "phone" and "tags". If someone has more than one tag, put them in the same cell, separated by commas or semicolons.
A file can be up to 10MB and 50,000 rows. If the same email address appears more than once, those rows are combined into one person.
If some rows don't import
When the import finishes, you'll see how many new people were added, how many were already on your list and how many rows couldn't be added. If any rows couldn't be added, the import window stays open and lists the ones with a problem, such as "That doesn’t look like an email address" or "This row has no email address".
Fix those rows in your spreadsheet, then choose Choose file again and pick the corrected file. People who've already been added aren't added twice.
If the import says it couldn't be confirmed, check your list of people to see who was added before you try again.
Download everyone on your list
On Mailing listPeople, search or filter the list if you only want some people, then choose Export CSV.
You'll get a spreadsheet file with each person's email, name, phone, status and tags, along with when and how they agreed to join. The status says the same as the People page, such as Waiting to confirm. It includes up to 10,000 people, so if your list is bigger than that, you might need to download it in parts using the filters.
Download one person's mailing list details
If someone asks what you hold about them on your mailing list, open their row on Mailing listPeople and choose Download their details. It downloads a file with their details, their topics and a record of the emails sent to them.
This only covers your mailing list. For their bookings, payments and client details, see Download or remove a client's data.