Importing users from CSV 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 CSV.
Video Transcript
00:00Hello again. So this is me, Ben, but from the future,
00:03I just wanted to add something really small in case you are in the future,
00:07just like I am. So notice how the menu just a little bit changed.
00:11So what you want to do is if you couldn't find that import when you're going
00:15into your list one, you still have that access from your menu of import.
00:19But if you're already inside of the list,
00:21you will not see the import anymore in the top menu and said that right now
00:26you'll find it in the ad subscribers. So if you click on that,
00:29you'll find import subscribers and we'll continue with our video. Welcome back.
00:33So we're still importing subscribers.
00:36The next step for us is I want to show you how to import subscribers from the
00:39list that you have saved as a file.
00:41So instead of actually uploading or copy pacing from an Excel,
00:44how do we upload a file directly? So again, I'm going to have a list,
00:48a starter list that I have here. And again,
00:50because we know that Mailchimp really wants to separate between name and last
00:54name, we want to do that as well.
00:56So I'm going to just make sure that I update the information in the same way
01:00that we've done in the last video. So again,
01:02I'm going to select the column of a name and I'm going to click up into the
01:06data option. If you're working with open office, every single, um,
01:10Excel editor has this capability.
01:12You just have to check with that specific manufacturer.
01:15How do you do it with open office? You would then go to text to columns.
01:19In our case, we want to separate it based on space. And we could see that,
01:23first of all, we have our space in here.
01:25Our only problematic item is, um, um, um,
01:29Evan J Hernandez because he has three names. So what I'm going to do is,
01:33first of all, I'm going to, before I actually do this,
01:35I'm going to go into that name and I'm just going to make sure that I'm going
01:38to actually, um,
01:39just delete it in our case because I just don't want to mess up our actual,
01:44um, columns. Cause we only want to have three columns.
01:48So once I've done that, I'm going to go back into my data column again,
01:50selecting column a into data text to columns. And again,
01:55I'm going to do the by other and with a space and I'm making sure that way
01:58there's only two lines, not more than that. And we're good with that.
02:02So I'm going to click on. Okay. Once I do that,
02:06we'll see that our names have been listed. Everything here looks good.
02:09We could have copied pasted it just as we've done before.
02:13But instead of that, what I'm going to do, I'm going to save the file.
02:16Now when you click on to upload a file, upload file, and again,
02:19I'm doing it maybe a little bit too fast. Let me click on the back button here.
02:22Oops. So we're going to click on import. And in our import area,
02:26you'll notice the first of all, you have your upload from file.
02:29When you click on to upload from file,
02:33you'll see that an upload from violent it X the acceptable type of file is a
02:37CSV file, not an Excel file. Now in our case,
02:42because we're working with open office by default,
02:44the file extension is going to be ODS,
02:47but that's not what Mailchimp wants. Now, by the way,
02:50usually that's the CSV file extension is usually what you would get when you
02:54export a list from a live site. All right.
02:58But we're not going to dig into that because that's more of a programmer kind of
03:02topic. If you had a database,
03:04but you could always ask your developer if you're not a developer to export
03:08your mail list into a CSV file. And if you do,
03:12then you could just upload the file immediately in our case,
03:15because we're working with an ODS file.
03:17What we could do is click on the file save as,
03:21and when you click into the save as you'll see that in the file type,
03:24you could actually open up the menu and then select text.
03:28C S V by doing that,
03:31you're actually converting the file to be a C S V file.
03:34So I'm going to click on save and I'm fine with the default options.
03:39And I'm going to click on, um, and by the way,
03:42if we might want to be able to, we want, might want to check.
03:46So the one thing that we could see is that it's or tab delimited text file.
03:50Basically, ideally for it, it wants to be a tab that the little,
03:54I hate that word, but knowing that we could even go into our field,
03:59delimited or hate this word, this hate word that we hate.
04:02And we could actually change it with a tab if we think that the tab is what
04:06is needed. So we could actually click a tab instead of a comma,
04:09but I believe a comma would be accepted. And if not,
04:11we could always revert back and change it into a tab.
04:14So we're going to leave it with a comma, a comma, and I'm going to click on,
04:19okay, once I do that, fair enough.
04:24So only the list that we're actually in is being saved.
04:26If we had a few sheets,
04:27it wouldn't save each and every one of them separately.
04:30And once we've done that,
04:31the file itself should be saved now as a list C S V.
04:36The last thing that's left for us to do is to actually upload this file
04:40directly in our browser.
04:42I'm just going to make sure that I'm going to file save as,
04:45but this time I'm just going to make sure I'm saving it on my desktop and not
04:48into my documents. So I'm going to save that as a C S V file,
04:52click on save and it's fine without warning.
04:55That way I get my list right on my desk so I could upload it immediately.
04:59And I could then just dropping it doesn't recognize it.
05:02So we're going to click on browse desktop and just scroll for our list.
05:07Let me just type your L I S T find our list that C S V click on open.
05:13Once we do that, we're really set.
05:15All it's left for us to do is to click on that auto update because we do care to
05:19make sure that we're updating the name,
05:20especially if we set them up as we talked about in the previous video and we'll
05:24click on import list. That's all we really had to do.
05:28And again,
05:28we're going to do the same exact steps as the steps in the last video.
05:31This is true. This is the first name.
05:33This is the last name and this is the email all is matching up correctly.
05:36It's recognizing the right places.
05:39And all that's left for us to do is to click on done.
05:44Once we click on done,
05:44it will import that list and add into our list.
05:47Now we have 49 members in our list. All right.
05:51So that's how we upload a file directly.
05:53We saw how to paste information inside.
05:56We saw how to upload a CSV file in the next video.
06:00We're even going to see how could we do this directly using Google docs without
06:04using any software.
