 This video is going to walk you through what to do next with the CSV file that you've just created above. So step number one, go into Google Sheets and create a new blank spreadsheet. Click on blank at the top of the page and we now have a blank, untitled spreadsheet. Now go to the top under File and click Import. I have the entities one CSV that I've just created, so I'm going to select it and then hit Select. Now I'm going to hit Import Data and voila, it's there. Okay, now at the top of the screen, I have to click on Data Menu and select Create a Filter. Data Menu, Create a Filter. The next step is to click on the triangular icon in the type cell, so that's row one column D and then I am going to deselect everything. I'm going, sorry, I'm going to select everything except location. So I need to come down here, deselect location, but make sure everything else is checked. So I'm going to scroll through and make sure that's that's accurate and it is. So now I select OK. Now I click on the row beneath the header. So what I'm trying to do here is I'm going to try to select everything in this set except the header because I want to keep the header. So in this case, I'm going to click here on number three. Now what I need to do is drag, click and drag this all the way through the set. And the problem is it's a huge set, so it's going to take forever. So what I'm going to do is I'm going to pause and then when I come back, I will show you what to do next. So hold on one second. All right. So now I have all 37,000 plus rows highlighted. I'm now going to right click on that and select delete selected rows. Now again, once I do this, it's going to take a while because it's a huge set. So I'm going to pause and then I'll come back and we'll keep going from there. Right click on the blue and select delete selected rows. Okay. Welcome back. I just went downstairs, made a sandwich called some loved ones on the phone and now I'm back. So now that we have this empty data set, you now go back up to the data menu at the top and select remove filter. So now what you're looking at is just the set with just the type of as a location, which is what we need for putting this into Google Maps. So now in the upper left hand corner, I need to select so that I can get the whole sheet selected. Okay. So now the whole sheet is blue and then I am going to go back into the data menu, select data cleanup and then remove duplicates. Now on this pop up, what I'm going to do is select the top one. So data has a header row. Then I'm going to go down and I'm going to deselect all and then I'm just going to select column A and column C. Then at the bottom, I'm going to click on remove duplicates. Then I say, okay, now once this is done, I'm now ready to pull it into Google Maps. But first I should give it a name. So at the top, I'm just going to call it unique, but that just unique. All right. So now it's named. Now I go into my maps. Again, there's a link to my maps in the instructions. And then the top, there's a red button that says create a new map. Now in the pop up underneath untitled layer, I'm going to click on import. Now I'm going to go into Google Drive because that's where I saved the spreadsheet. I'm going to click on the unique spreadsheet. Then I'm going to click select. Now I'm going to get two pop up boxes. The first one I'm going to select entity, click continue. Then I'm going to select entity again and then select finish. Now what's going to happen is now this map is going to have a pin for every location that is mentioned in the Walter Tevis collection that we've created, the work set that we've created in Hottie Trust.