data, data journalism, data visualization, Interactivity, maps

How to: create maps with filters from Google spreadsheets in 6 steps

I just discovered Mapping Sheets, an add-on to your Google Spreadsheets to plot your data into a map with filters and columns without coding skills.

Here I explain how to do it in 6 steps:

1. Get Mapping Sheets on Google Chrome web store.

2. Create a spreadsheet or re-use an existing one

Make sure that the spreadsheet contains the location (latitude and longitude).

output_tqkeig

 

3. Go to Add-ons -> Mapping Streets

1.jpg

4. Select the columns that contain the title, the information that you want to filter and the location of the markers.

2

And click Build!

5. View the map and customise the information

3.jpg

6. Use the filters and the search box to look for the data

4

Take some time to check the information on the filters by location and type, you can always go back and change the columns.

Do you have more examples? Let me know in the comments or on Twitter at @mcrosasb

Advertisements
Standard

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s