Sunday, 16 October 2011

How to embed google map on excel sheet, .xls



How to add Google Map on a spreadsheet


If you want to publish an excel sheet with google map on it you need to follow following simple steps for that:
1) log in to http://docs.google.com, using your gmail ID or any other valid e-mail ID.

2) click on create button on the left panel and choose spreadsheet option.

3) this will open an unsaved spreadsheet. now you can edit this sheet or you can import a spreadsheet from your computer by click on FILE and then IMPORT.

4) now you have a spreadsheet with one column having some places written in its cells. choose INSERT -> GADGET -> MAPS and add the map to spreadsheet. select range by clicking on the cells.
you have a spreadsheet with a map.
click on publish in order to put it on your webpage.


India Mapia

No comments:

Post a Comment