Importing users from Excel to MailChimp
It might sound simple but when working with two data sources many times issues will arrise. As such in this video we cover both the steps involved with uploading users ontop MailChimp but also the steps involved with reformatting your data using Excel
Video Transcript
00:00All right, so we're gonna start off with showing you how could you copy paste from Excel to do that
00:04We're gonna go directly and by the way right now we're in our live account
00:08You can see that we have already 28 members in this live account
00:11We have only another 240 emails that we could be adding in before we move on to the next price because we already have
00:19More than 2,000 subscribers. So if we click into the copy
00:23Paste from Excel to import and we click right away in there
00:28You'll see that it opens up this list and it basically tells me the order that the list needs to be in and needs to be
00:34Set into email address first name last name now
00:37What if you had 5,000 people in the list and it wasn't in this order for example, how about you have a list of this sort?
00:45So in this case, we have your only 12 members
00:46But what if we have a timestamp name and then email so in this case, we're using open office
00:53And if you don't have open office, I do recommend you download it because it's completely free
00:58Personally, I think free is better than charge whenever there's a good alternative that's free and in this case
01:03This is a fantastic alternative. So first of all, I'm gonna move my email list from column C to column D
01:09And literally it's because I want to be able to move the name and move the names from the name area that it's at right now
01:16The next step that I want to do is I'm gonna select the name column
01:20And then I'm gonna go up into my data column in the open office and click on to the data
01:26And then select text to columns
01:29Once I do that a menu will open up and it'll basically by default tell me that it's gonna separate it by tabs
01:35But it's also gonna show me a live preview
01:38So I'm gonna deselect tab because it's not the way I want to check the separators in our case the space that users put
01:44In is what we want to use
01:45So I'm just gonna click on space and you could see this live update showing us that the information that is going to be
01:51Ported and this is perfect. This is exactly how we want it to look like so we'll click on the ok
01:56Button now that we click the ok button. We have our first name last name and email and we're ready to go
02:03And we're sorted
02:04So all that's left for me to do is to copy all these names and emails all these three columns
02:09Go back into my list and just paste inside my new my information
02:14Basically the separation here is of tabs
02:17So now that I have these names
02:19I'm gonna then select if I want to auto update existing lists or not
02:23What does that mean? What that means is if I already have a user that has this email address
02:28But their name is different. It will update the name information. So it's gonna cross reference the information by default
02:35It's not gonna import an email that is already in there
02:38But on top of that it's also going to validate that if you the user has more up-to-date information
02:43If we think this is the most concurrent up-to-date information
02:46Then we can make sure that we auto update the existing list
02:49it might take longer but that longer period of time that it takes will make sure that it validates and
02:55Import those of the usernames in our case in our form actually on our website right now
03:00There isn't actually a way for users to add their first name
03:03So in this case, we're actually adding in their name if they don't have it and they already submitted inside
03:08So we're gonna click on that import list
03:11Once we click into that import list, we'll see that first of all our list volume already grew
03:15We didn't even complete yet and you can see that first of all our list now is already 31 just moments ago
03:22It was 28. So we see that our list is already growing organically from our site already directly
03:27First of all, we want to figure out is this the first name? Yeah, this is the first names
03:31We're gonna click on ok for first name and for the last name is this the last name
03:35It definitely is if it wasn't we could have opened up and selected different
03:40Possibility notice that there are always there's also different information such an opt-in time
03:45Which might be important to you to make sure that you still know when that happened
03:49So with that said if we look back into our application again or look back into our document
03:54We'll see that we do have a timestamp. So how about we undo what we just did these steps
04:00I'm gonna cancel and re-upload the list again
04:03But this time around what I want to do is I'm gonna copy from and paste from Excel
04:07But this time I'm also gonna paste inside the actual dates where they submitted the timestamp because we have it
04:14So I'm gonna click on to that
04:16Copy everything including the timestamp and let's see what happens this time around
04:20So if I click on paste and I continue on and I definitely do want to update my existing list
04:26I'm gonna click on import list
04:28Once I do that notice that now we have your first of all it thinks it's the first name and that's not true
04:33What it actually is is the opt-in time
04:36And we're gonna click on ok
04:38We want to put in also what this is is the first name that is true
04:42Is this the last name that is true is that the email address that is true as well?
04:47So we got all of our information
04:49Connected accurately all that's left for us to do is to continue onwards and click on that done
04:55Now notice that even though we have duplicate names, it shouldn't add that name twice
05:00It will once it completes and actually uploading the information
05:05Even though our information when we look at our file had what was it a 12 minus one
05:10So it's 11 names were put it inside. Notice that George Burks has no email notice that some of our email
05:17Here's our duplicate. So these two are duplicates are really we would expect only for 10 to be submitted
05:23Well in this case if we have your 11 and we would expect only 9 to be submitted and let's see how many new emails
05:29We're added in once we click on that done. So we're gonna click on the done button and
05:35Once we do that do that
05:37We're done
05:38We added those users in and now we can see that we have seven new members that were added in
05:43Or eight members that were added in which makes sense
05:45It means that probably one of the names have been already in there before and if we go and click into
05:51managing our subscriptions and looking at the
05:54Subscriber list we'll see that we won't have any duplicates in that subscriber list
05:59All right, and whoever it did we did have a name would be added in you can see that Michael is not hasn't been added twice
06:06All right. So there we go. So that's how you add in by copying and pasting names into a list
06:11So we're gonna go back into our list itself
06:14But what I want to do is I want to go back into that import column because we still have more items to import
06:20The next thing that we're gonna import is we're gonna try to import a file as well
06:24And we'll see you in the next video when we do that
