Dynamic Google maps based on Excel Data points.

[watsukoguy]

Hi,

Currently I am able to import google maps based on directions. I have also been able to create a custom google map (on google site) by importing a data sheet.

My data changes on a weekly basis and I would like to import the google map interface and have it update based on Excel data sets. Key data points, Service level, Address, Customer, Quantities etc...


I understand it is likely easier to just have pin points on a map and that is my expectation but the ability to create a heatmap would be interesting too. Can you provide guidance on how to accomplish both of those?

thanks,

Mike.

 

[Taul]

Hi,
Take a look here
Google Maps distance function for Excel - oCoCarbon

There are links in the top right corner for further options that may assist.

HTH
Paul.

 

[watsukoguy]

I am not looking for distance per se and would prefer to have the work completed within Excel. Basically the data would look something like below and filled in on multiple rows. That data set will change Weekly and i would like the Pin points on the Map to change within an imported Google Maps. I would prefer the changes to happen automatically vs. using an external tool.




Customer Servicelevel part date address

XYZ 8x5 12345 6/1/2017 555 5th Avenue, Toronto, Ontario V5N 1A2