Thank you for this interesting explanation, but is there a way to import the data, by being automatically from Google Drive or via the api, so that all the updates on the data change on the map
Love the video, I refer to it all the time. Need to know how to update the map if I changed the data on the original imported spreadsheet. Not sure If I have to reimport the data. Your help is appreciated. Kay
Thank you for the video. Do you know how I might be able to add data to an existing layer without having to re-enter all of the data, or is there a way I could have the layer automatically update as I enter new information into my Google Sheets?
Great tutorial video, Brandon! I know this isnt' the focus of your channel, but you did say that you would have a longer more complete video linked in the description. -- I don't see that link. *Can you please share a link to the longer video? Thanks and great work*
Really cool and extremely useful for a project I am working on. Is there a way I would I find the column information so I could upload an excel file with the images already in there.
Is it possible to associate a label next to each icon so that you can see the name of the location next to the icon instead of clicking the icon to see all available info? Thanks.
Hi, thanks for the valuable information , really helpful . ❤ I was able to import all the address to google , but I wasn’t able to use it as gps so I can reach each location by car . Is a way to use it as gps ? Thanks 🙏🏼
Hey thank you so much for you video, it was very helpful ! Do you know a way to have the photo directly imported from the CSV file ? It could be in the form of a URL in the excel file and My Maps would successfuly recognize it as the picture, so that it wouldn't be necessary to add them afterwards manually ?
Hello, I am trying to import my excel data into Google Maps but keeps tell me this "Oops! We're having trouble finding those locations. Did you pick the correct location columns? Can you anyone please help?
Great job! I'm a newer user, but I find MyMaps to be pretty user-friendly. Do you know of a way to create numbered pins? I'm trying to map out territory for a sales team and want the pins to be numbered, according to the order in the spreadsheet they are imported from.
Hey, Can you please tell me how to conditional format the google map? I mean to say in CSV file there is a column called height and I want to color-code those locations to RED , Yellow base on some condition in Height Column inside CSV
Hi! Thank you for a great video! :-) I was wondering if it is possible to add a radius border around the icons to see if the locations is for example less then 500 meters apart from each other? :-)
I work with a large dataset of over 2000 addresses. Is there an option that Google Maps to allow more than 2000 cases in one layer or do I have to split my Excel spreadsheet in separate files of up to 2000 rows?
Hi, Are you able to search for a name or title of one of my pins? Example: If I have a few thousand pins all with different names and I'm looking to search for a specific pin.
This is very helpful. Thanks. You talked about using and changing colors of the pins, can you use images? I’m wanting to create a map of my city with local restaurants instead of using pins, I’d like to use logos. Can that be done? And is there a way to outline cities or suburbs in a metro area?
Do you find that the addresses are off by about a block each time? I don't have that problem in normal google maps, just in "my maps". What am I doing wrong?
I am importing excel data by state into google maps. For some reason I get an error saying 20 of the 42 states on the list can't be added because of errors. It says to open the data table to fix the errors. However, when I open the data table, all the state entries are correct. Changing abbreviation to the state name doesn't work, because it defaults the state of Georgia to the country of Georgia. Clicking on the red triangle doesn't help, because t doesn't give any information.
Hi there Is it possible to export the organization name ,street name from google map to excel? actually i need exactly what you did but opposite way mean from map i need to find out what organization are available on a specific area and report it in excel format Kindly could you advice ?
Is there a way to show "concentrations"? When a marker lands too close to another marker we can't see both nd it looks like "one" ?? I'm thinking of a choropleth map ?
thanks. I have imported an excel file having district name state name company name and short address but it has no latitude and longitude information. after importing excel it shows the location of the companies on my googlemap. Now I would like to add latitude and longitude on the already imported excel file' in two columns. how it is possible?
I have a map with 573 addresses and 104 of them show ERROR. How can I determine what's causing the error. PO Box is pretty obvious, all of mine have exact addresses that were given to me.
I neeed to reach the destinations.and my map dont tell path like google map.I want to open it google map and click prview but it give message and map not open in google map.where I have error.
RIP my maps, used it for work for a long time but last year google gave it the axe on mobile. still kinda usfull on PC but definitely harder to use nowadays.
I REALLY NEED HELP. This isn't helping me at all because I'm trying to send My Places from Google Maps to MyMaps. I converted the JSON file to a KML file but every place is missing ALL of the information. All that shows up on MyMaps is the pinpoints (upside down teardrops) with no data whatsoever, not even the name of the place. Can anybody help me?
![Megan Thee Stallion - Roc Steady (feat. Flo Milli) [Official Video]](http://i.ytimg.com/vi/HozPPyqW0dY/mqdefault.jpg)
Just what I needed to make a map of households in my neighborhood that need economic assistance because of COVID 19. Many thanks on a great tutorial!
Wonderful! If you need any help at all just let me know!
I was surprised when Portland showed up! I was like "WAIT that looks familiar!" great video answered exactly what I needed!
Thank you for this interesting explanation, but is there a way to import the data, by being automatically from Google Drive or via the api, so that all the updates on the data change on the map
I would also be very interested in this!
Please help with this
Love the video, I refer to it all the time. Need to know how to update the map if I changed the data on the original imported spreadsheet. Not sure If I have to reimport the data. Your help is appreciated. Kay
Thank you for the video. Do you know how I might be able to add data to an existing layer without having to re-enter all of the data, or is there a way I could have the layer automatically update as I enter new information into my Google Sheets?
Great tutorial video, Brandon! I know this isnt' the focus of your channel, but you did say that you would have a longer more complete video linked in the description. -- I don't see that link. *Can you please share a link to the longer video? Thanks and great work*
Really cool and extremely useful for a project I am working on. Is there a way I would I find the column information so I could upload an excel file with the images already in there.
Is it possible to associate a label next to each icon so that you can see the name of the location next to the icon instead of clicking the icon to see all available info? Thanks.
Great tutorial and just what I was looking for to help in a project. Thanks!
Many thansks for this tutorial. I have a question. It's possible to hidden the default watchpoints in maps so I only see my imported data? Many thanks
can you upload not only "point in map" but route from A to B ? from spreadsheet?
I would be interested in importing route data as well!
Is it possible to import lines (shapes) into mymaps?
Yes but geodata needs to be in KML format.
Do you think it's possible to automate the import ? Like every change in the sheet to automatically update in the maps
Thanks. Can we make the regular Google businesses on the map go away so my data will be highlighted?
Thanks you actually saved me at work
Just seen this video really helpful can you add large data sets with this ?
Nice tutorial. Saved my day. Thanks
YOU HELPED ME A LOT. THANK YOU SO MUCH!
Hi, thanks for the valuable information , really helpful . ❤
I was able to import all the address to google , but I wasn’t able to use it as gps so I can reach each location by car . Is a way to use it as gps ?
Thanks 🙏🏼
Great video!!!! Helped me alot!
Wow! This is neat!
If you update the imported Google sheet or have a team of people updating it, will it able to update the MyMaps as well?
Whenever you want this to update you'll need to reupload the sheet. It might be automatic though Google Sheets but I'm not 100% sure.
TechHut yeah need to reupload, so if there were pictures on individual pins on MyMaps will need to update too
I'm trying to figure out how to reupload it.
Hey thank you so much for you video, it was very helpful !
Do you know a way to have the photo directly imported from the CSV file ? It could be in the form of a URL in the excel file and My Maps would successfuly recognize it as the picture, so that it wouldn't be necessary to add them afterwards manually ?
Hello, I am trying to import my excel data into Google Maps but keeps tell me this "Oops! We're having trouble finding those locations. Did you pick the correct location columns? Can you anyone please help?
cant wait for the lenghful video, This helped me sooo much!
is there a advancdet video?
Great job! I'm a newer user, but I find MyMaps to be pretty user-friendly. Do you know of a way to create numbered pins? I'm trying to map out territory for a sales team and want the pins to be numbered, according to the order in the spreadsheet they are imported from.
@Cly187 Yes: Immediately under the layer name, tap "Uniform Style" (or whatever is there) and instead choose "Sequence of Numbers."
Hey, Can you please tell me how to conditional format the google map? I mean to say in CSV file there is a column called height and I want to color-code those locations to RED , Yellow base on some condition in Height Column inside CSV
Hi! Thank you for a great video! :-)
I was wondering if it is possible to add a radius border around the icons to see if the locations is for example less then 500 meters apart from each other? :-)
Great and helpful , how to do maps video , thank you
I work with a large dataset of over 2000 addresses. Is there an option that Google Maps to allow more than 2000 cases in one layer or do I have to split my Excel spreadsheet in separate files of up to 2000 rows?
Hi, Are you able to search for a name or title of one of my pins? Example: If I have a few thousand pins all with different names and I'm looking to search for a specific pin.
This is very helpful. Thanks.
You talked about using and changing colors of the pins, can you use images? I’m wanting to create a map of my city with local restaurants instead of using pins, I’d like to use logos. Can that be done?
And is there a way to outline cities or suburbs in a metro area?
Thank you so much! This was incredibly helpful!
Do you find that the addresses are off by about a block each time? I don't have that problem in normal google maps, just in "my maps". What am I doing wrong?
Can you make it so your created map is viewable while offline?
Oops! We're having trouble finding those locations. Did you pick the correct location columns? I am having this, what I need to do?
I am importing excel data by state into google maps.
For some reason I get an error saying 20 of the 42 states on the list can't be added because of errors.
It says to open the data table to fix the errors.
However, when I open the data table, all the state entries are correct.
Changing abbreviation to the state name doesn't work, because it defaults the state of Georgia to the country of Georgia.
Clicking on the red triangle doesn't help, because t doesn't give any information.
Hi there
Is it possible to export the organization name ,street name from google map to excel?
actually i need exactly what you did but opposite way mean from map i need to find out what organization are available on a specific area and report it in excel format
Kindly could you advice ?
is it possible to auto-sync Google maps and Google Sheets? I want if I change something to my map, automatically update my sheets or the opposite.
Hi TechHut, I'm trying to create a map to outline and each city in a state. I'm wondering if you can do that with my maps.
Is there a way to show "concentrations"? When a marker lands too close to another marker we can't see both nd it looks like "one" ?? I'm thinking of a choropleth map ?
How do you make this map with the POI's added your default map?
That's very nice I need to navigate mymap into google Maps 🗺️ how to do could u please take a session for that pplease
It's under 'Saved' and then 'Maps' if you're logged into the same Google Account.
thanks. I have imported an excel file having district name state name company name and short address but it has no latitude and longitude information. after importing excel it shows the location of the companies on my googlemap. Now I would like to add latitude and longitude on the already imported excel file' in two columns. how it is possible?
I have a map with 573 addresses and 104 of them show ERROR. How can I determine what's causing the error. PO Box is pretty obvious, all of mine have exact addresses that were given to me.
You could import the KML File os the Colorado Counties.
I neeed to reach the destinations.and my map dont tell path like google map.I want to open it google map
and click prview but it give message and map not open in google map.where I have error.
I add more 15000 point but if search by name that not showing
How do you make look good on mobile? Thanks.
Remind us how to make it an icon instead of a color tap? Also if I want others to SEE my map but not EDIT how can I share it?
Great video!! i hit the like button as payment. :)
RIP my maps, used it for work for a long time but last year google gave it the axe on mobile. still kinda usfull on PC but definitely harder to use nowadays.
How to enable current location in MyMaps?
great vid dude
4:32 What about an Atlantic piece of data?
These locations are how to publish?
I could use help on a mapping project if possible.
I REALLY NEED HELP. This isn't helping me at all because I'm trying to send My Places from Google Maps to MyMaps. I converted the JSON file to a KML file but every place is missing ALL of the information. All that shows up on MyMaps is the pinpoints (upside down teardrops) with no data whatsoever, not even the name of the place. Can anybody help me?
Excelente..
sir how we can downloads data table in
excel
How we add images in Google map by one click
Its not working can you help me that how to use
tnk u -
I would like this to be automatic
I am trying to import but it keeps saying "Error". It is an official Excel document. Sigh
thanks
Grt
Not enough colors? There are at least 16 million on an average computer :D