Three Ways to Quickly Map Spreadsheet Data
14115
post-template-default,single,single-post,postid-14115,single-format-standard,bridge-core-1.0.7,ajax_fade,page_not_loaded,,qode-title-hidden,qode_grid_1300,hide_top_bar_on_mobile_header,qode-content-sidebar-responsive,qode-child-theme-ver-1.0.0,qode-theme-ver-18.2.1,qode-theme-bridge,disabled_footer_bottom,qode_header_in_grid,wpb-js-composer js-comp-ver-7.9,vc_responsive

22 Feb Three Ways to Quickly Map Spreadsheet Data

Posted at 10:33h in education by

I recently came across an older Towards Data Science article about ten ways to represent data on maps. Reading the article reminded me of something that I’ve tried to share with social studies teachers and students over the years. That thing is that a great data set can tell you a lot. A great map can tell you a lot. Putting them together can tell you even more. To that end, here are three ways to quickly create a map of data contained in a spreadsheet. 

Google’s My Maps tool lets you import a Google Sheet and have the data from that sheet displayed as placemarks on an interactive map. Watch this video that I created to learn how you can create a map based on data in a Google Sheet.

Felt is a relatively new multimedia mapping tool. In your Felt account you can upload a CSV or Excel file and have the data within the spreadsheet distributed as placemarks and or polygons on a map. After the data is initially loaded you can then customize the design of your map by altering the color, size, and shape of the placemarks and polygons. You can also customize the size and color of the labels on your map after the spreadsheet data has been imported onto your map. Watch my video below to learn how to display your spreadsheet data on a Felt map. 
Heat Map Tool is a tool for easily creating heat maps or incident maps from a CSV file. To create a heat map all you need to do is upload a CSV file then specify your desired display attributes like scale, colors, and opacity. You can edit the display attributes of your map whenever you like. If you’re wondering how to create a CSV file you can do so by exporting from a spreadsheet in Google Documents or exporting from an Excel file. Click here for directions on exporting from Excel. The free version of Heat Map Tool allows you to have up to 100 data points on your map and up to 500 hits per day on your map.

Are you a tech coach or media specialist looking for some new ideas to share with your colleagues? If so, 50 Tech Tuesday Tips is an eBook you need. You can get it right here.

I recently came across an older Towards Data Science article about ten ways to represent data on maps. Reading the article reminded me of something that I’ve tried to share with social studies teachers and students over the years. That thing is that a great data set can tell you a lot. A great map can tell you a lot. Putting them together can tell you even more. To that end, here are three ways to quickly create a map of data contained in a spreadsheet. Google’s My Maps tool lets you import a Google Sheet and have the data from that sheet displayed as placemarks on an interactive map. Watch this video that I created to learn how you can create a map based on data in a Google Sheet.Felt is a relatively new multimedia mapping tool. In your Felt account you can upload a CSV or Excel file and have the data within the spreadsheet distributed as placemarks and or polygons on a map. After the data is initially loaded you can then customize the design of your map by altering the color, size, and shape of the placemarks and polygons. You can also customize the size and color of the labels on your map after the spreadsheet data has been imported onto your map. Watch my video below to learn how to display your spreadsheet data on a Felt map. Heat Map Tool is a tool for easily creating heat maps or incident maps from a CSV file. To create a heat map all you need to do is upload a CSV file then specify your desired display attributes like scale, colors, and opacity. You can edit the display attributes of your map whenever you like. If you’re wondering how to create a CSV file you can do so by exporting from a spreadsheet in Google Documents or exporting from an Excel file. Click here for directions on exporting from Excel. The free version of Heat Map Tool allows you to have up to 100 data points on your map and up to 500 hits per day on your map.

Are you a tech coach or media specialist looking for some new ideas to share with your colleagues? If so, 50 Tech Tuesday Tips is an eBook you need. You can get it right here.Data Mapping, Felt, Felt Maps, Free Technology For Teachers, Geography, Google My Maps, History, how to, Social Studies, SpreadsheetRead More

Print page
0 Likes
No Comments

Sorry, the comment form is closed at this time.