Mapping Locations & Data on Google Map through Postal Codes

[sanits591]

Hi,

I am looking for some VBA codes in excel, which shall perform the following functions:

1. Available data: An excel sheet with the Col A - Location Name, Col B - Business Figure (numerical Value), Col-C-Share of Market (%), Col-D-Postal Code.

2. Now i want to map the data on the Google map, with the help of postal codes.

3. The data discussed above to shown on the Google Map, just like the comment box of excel.

Request to help me out on the above.

 

[CharlesChuckieCharles]

This is about programming Google Maps?

 

[sanits591]

Programming using vba in excel, may be using kml file for this, as mentioned in the link below.

http://theclosetentrepreneur.com/export-excel-data-to-google-maps

But, unable to get desired output through this. So, please help on this.

 

[Taul]

I have a similar thing with mapping company names and buisness data on Google maps.
I found several spreadsheets on the net that will do the job but none of then exactly what I wanted.
The best option (for me) was to use a Google spreadsheet, you will need to get a Google account first.
Within the "Documents" section of your Google account, you can download a template called "Spreadsheet Mapper v2.0" This will allow you to place your data into the spreadsheet and publish it to Google Earth but it is also compatible with Google maps provided you tidy up the kml file first, by tidy-up, I mean clear the blank spaces off the top row. GE does this automatically but GM needs to be manual.

You will need to host the kml file elswhere but the are quite a few free hosting places to use.

 

[sanits591]

This works great Paul-H. Thanks!

Now i need to know an excel VBA code a little further in detailing the data, like:

1. Depending upon the value of the data for that particular area, a dot gets mapped, e.g.
Place Data Value
A 20
B 50
C 10
D 200

Now the size of the dot placed on the map for the respective places must be related with respect to the value indicated against each place.

This shall lead to the variable density cloud of the data for different places, and shall lead to view the different statistics on a map in one go.

Please help on this.

 

[Taul]

The "Spreadsheet Mapper v2.0" template is really designed for placing a single map paddle on the map. The paddle is actually referenced as an address like :-
http://maps.google.com/mapfiles/kml/paddle/ylw-blank.png

It sounds like you are describing a "heat map" which would display a different colour or different size area on the map that relates to a known value.
I would suggest searching for "Heat Map", as that would provide something closer to what you want.

 

[sanits591]

I have searched, but hard luck, could not find any KML file for heat maps, as desired in the thread.

Please help.