How to create interactive map in Google Sheets
Create interactive map in Google Sheets
Want to create a map chart to share, either by putting it online on your website like below, or sharing a picture ? And, on top of that, an interactive map?
Step 1: create new sheet
This is very easy with Google Sheets. Start by going on your Drive, and select NEW > Google Sheets:
![How to create interactive map in Google Sheets : Create new spreadsheet in Google Docs](https://www.ybierling.com/images/medium/web/createinteractivemap/createinteractivemap1.png)
In the spreadsheet, paste your values:
![How to create interactive map in Google Sheets : Paste data in Google Sheet](https://www.ybierling.com/images/medium/web/createinteractivemap/createinteractivemap2.png)
Select Insert > Chart…
Step 2: create a map chart from a spreadsheet
![How to create interactive map in Google Sheets : Create a chart in Google Sheets](https://www.ybierling.com/images/medium/web/createinteractivemap/createinteractivemap3.png)
Your chart might be setup as a bar chart. To change it to a map chart, select the chart, click on the three dots in the top right corner > Edit chart… and in the Chart editor, in customize tab, Chart type, select Geo chart
![How to create interactive map in Google Sheets : Change chart type in Google Sheets](https://www.ybierling.com/images/medium/web/createinteractivemap/createinteractivemap4.png)
You can then select how you want your chart to be displayed with the different options.
![How to create interactive map in Google Sheets : Customize a map chart in Google Sheets](https://www.ybierling.com/images/medium/web/createinteractivemap/createinteractivemap5.png)
For example, change the world region to be displayed.
![How to create interactive map in Google Sheets : Select visible world region of a map chart](https://www.ybierling.com/images/medium/web/createinteractivemap/createinteractivemap6.png)
Result example when selecting Europe:
![How to create interactive map in Google Sheets : Europe region of a map chart](https://www.ybierling.com/images/medium/web/createinteractivemap/createinteractivemap7.png)
Step 3: publish interactive map chart
To publish your chart, click on the three dots, and select Publish chart…
![How to create interactive map in Google Sheets : Map chart publish option](https://www.ybierling.com/images/medium/web/createinteractivemap/createinteractivemap8.png)
You can also get a static image to share.
Get a link to send it to your contacts, or to share it on social networks
![How to create interactive map in Google Sheets : Map chart publishing options](https://www.ybierling.com/images/medium/web/createinteractivemap/createinteractivemap9.png)
A box will ask you to confirm the publication:
![How to create interactive map in Google Sheets : Map chart publishing confirmation box](https://www.ybierling.com/images/medium/web/createinteractivemap/createinteractivemap10.png)
Step 4: share link or include in website
And link will be displayed, with quick links to share on common social networks like Google+, Gmail email, Facebook, and Twitter:
![How to create interactive map in Google Sheets : Map chart shareable link and social networks shortcuts](https://www.ybierling.com/images/medium/web/createinteractivemap/createinteractivemap11.png)
By going in embed, HTML data will be given to share on your website, as seen in the interactive chart above this article
![How to create interactive map in Google Sheets : Embed interactive map chart HTML code](https://www.ybierling.com/images/medium/web/createinteractivemap/createinteractivemap12.png)