Edutech Magazine
Image default
Tools & Resources

Three Good Ways to Map Spreadsheet Data

In my previous post about how to create a story map I featured a tool called StoryMap JS. That tool is great for making story maps that have no more than about twenty scenes. Any more than that and the process becomes a bit cumbersome and tedious. Fortunately, there are tools that you can use to quickly map a lot of information at once. 

Storyline JS lets you create an interactive, annotated line chart. The purpose of Storyline JS is to enable you to add detailed annotations to the data points displayed on your line charts. Watch my video below to see how to create an annotated line chart with Storyline JS.

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.

Related posts

Canva, Pictures, and Micro:bits – The Month in Review

Lesson Plans for Setting SMART Goals This Fall

How Wastewater Gets Recycled

How to Collaborate on Google Slides

100+ Math in “Real Life” Lessons

A New Accessible PhET Simulation

Leave a Comment