How To: Turn a Spreadsheet Into Your Own Custom Google Map
This video covers how to upload a spreadsheet into a map using google maps. My first video so please correct me if instructions are incorrect or anything else is wrong, i'd appreciate it.
Here's a link to the map created in the video:
https://www.google.com/maps/d/edit?mid=zkSiGeyt1FzU.kk8VAOZOhmqs
you can edit the map or view it from that link.
If you don't want to watch the video, here's a quick description of how to do it:
1. Open a web browser and go to Google maps
2. make sure the search bar in Google Maps is empty and that you are signed in to your Google account. Below the search bar, there should be a few recent searches and then a bar labeled “my maps”. Click “my maps”, then click create.
3. Click the blue “Import” button, and find the spreadsheet you want to turn into a map. Ours is in Google drive so we find the spreadsheet we want, click the document and then click select.
4. Now Google will ask us what column in our spreadsheet it should use to position our nightlife places. The addresses are what google maps is going to use to plot our placemarks. So let’s select the address column. For the title of our markers, let’s choose the name column and then click finish.
5. Alright! We’ve got our map. Google took all of our addresses and used them to position the placemarks accordingly. If we click on a placemark, all the information in the spreadsheet about that placemark pops up for us.
6. Now let’s make some tweaks to our map so that it tells a story.
7. I want to group all of these places by how much money, in dollars, I spent at each place. To do this, I click uniform style and then change Group places by” from “Uniform Style” to “Style By Data Column-Spent”. Then change “Categories” to “ranges”. Now, our placemarks are color coded based on the data in my “Spent” column.
8. Okay, so now we have a beautiful map that tells a story. Thanks so much for watching ☺.
Видео How To: Turn a Spreadsheet Into Your Own Custom Google Map канала Cole Frankel
Here's a link to the map created in the video:
https://www.google.com/maps/d/edit?mid=zkSiGeyt1FzU.kk8VAOZOhmqs
you can edit the map or view it from that link.
If you don't want to watch the video, here's a quick description of how to do it:
1. Open a web browser and go to Google maps
2. make sure the search bar in Google Maps is empty and that you are signed in to your Google account. Below the search bar, there should be a few recent searches and then a bar labeled “my maps”. Click “my maps”, then click create.
3. Click the blue “Import” button, and find the spreadsheet you want to turn into a map. Ours is in Google drive so we find the spreadsheet we want, click the document and then click select.
4. Now Google will ask us what column in our spreadsheet it should use to position our nightlife places. The addresses are what google maps is going to use to plot our placemarks. So let’s select the address column. For the title of our markers, let’s choose the name column and then click finish.
5. Alright! We’ve got our map. Google took all of our addresses and used them to position the placemarks accordingly. If we click on a placemark, all the information in the spreadsheet about that placemark pops up for us.
6. Now let’s make some tweaks to our map so that it tells a story.
7. I want to group all of these places by how much money, in dollars, I spent at each place. To do this, I click uniform style and then change Group places by” from “Uniform Style” to “Style By Data Column-Spent”. Then change “Categories” to “ranges”. Now, our placemarks are color coded based on the data in my “Spent” column.
8. Okay, so now we have a beautiful map that tells a story. Thanks so much for watching ☺.
Видео How To: Turn a Spreadsheet Into Your Own Custom Google Map канала Cole Frankel
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to Create a DYNAMIC Map Chart With Drop-Down (works with ANY Excel version)Google Tip - Create A Google Map from Spreadsheet DataHow to create a custom Google Map with Route Planner and Location Markers - [ Google Maps Tutorial ]Set Mutli Locations on Map | Using Google Map JavaScript APIHow to Make a Google Map from Excel - Tutorial 📍🗺️How to Make a Google Map from ExcelUsing Google Spreadsheets as an API in under 4 minutes!GE graph. Drawing bar graphs on google earthGoogle Sheets and Fusion Tables Heat MapsHow to Build an Interactive Dashboard in Google Sheets, Part 1: Dynamic ChartingGoogle Maps for Real EstateConnect an Interactive GeoMap with Google Form Results (June 2015)Google Maps for Trip PlanningGoogle Maps JavaScript API TutorialMap My Sheet - How to present data from Google Sheets on Google MapsGoogle My Maps - Lesson 2 - Google Apps for Education - Training TutorialPet Sitters: Create a Service Area Map for Your WebsiteHow to Set My Business Address, Shop, Location, on Google MapsUltradox - How to merge data from Google Sheets into your documentsMake route in S&T using Excel data